microsoft.public.access.queries
By Thread
2900 messages sorted by: [ date ]
Starting: 05/31/04
Ending: 06/30/04
- Summing Fields by Given Period Tan SH (06/30/04)
- Average of last 5 results Grant (06/30/04)
- I have a problem with dates in queries. P Van Veen (06/30/04)
- Query Disturbezz (06/30/04)
- Sentence Case Michael (06/30/04)
- Re: query to append data to tables in another database that is password protected BayesTex (06/29/04)
- join query problem Alex (06/29/04)
- RE: Date format in queries mb (06/29/04)
- Calculated number SM (06/29/04)
- Q: passthrough update queries hanging Access? MarkD (06/29/04)
- Determining Weekdays in a Date Range Lori Jo (06/29/04)
- query to create fields tony wong (06/29/04)
- Time Calculation Robb (06/29/04)
- Parameters Angela Hunt (06/29/04)
- create a flat file Maggie (06/29/04)
- Sorting Question, Please Help! Paul (06/29/04)
- Append Query - Multiple records based on qty field John V (06/29/04)
- Monthly fajita (06/29/04)
- queries Access 97 GRCC (06/29/04)
- UnMatched query Leif (06/29/04)
- Can not allocate(distribute) data equally(evenly) J.Brunt (06/29/04)
- Not include certain data Alicia (06/29/04)
- left outer join problem Alex (06/29/04)
- count zero values in a query steve carpineta (06/29/04)
- Queries bmersereau_at_zelle.com (06/29/04)
- Round function Emmy (06/29/04)
- Summing Fields per record alex (06/29/04)
- List Box Larry (06/29/04)
- select top X Scott Shively (06/29/04)
- Emailing the current record TK (06/29/04)
- I am a complete novice in access help Help me please totals on page in report (06/29/04)
- query info from two tables bobby (06/29/04)
- Searching Memo Fields Brandon Campbell (06/29/04)
- order by date in query Sean (06/29/04)
- comparing the first character in two different fields Leslie (06/29/04)
- Problems with duplicate but not duplicate entries JOHN (06/29/04)
- Carriage Return Matthew DeAngelis (06/29/04)
- Year Query Sue (06/29/04)
- Make Table querys with SQL Chris H (06/29/04)
- calculations in a querie Boo (06/29/04)
- query2table Michael Firsching (06/29/04)
- copy query2table? Michael Firsching (06/29/04)
- copy query2table Michael Firsching (06/29/04)
- Query Query Simon Dowse (06/29/04)
- Make Table query on ODBC table changes NULLs to empty strings in Access 2002 Les Mercer (06/29/04)
- Crosstab query question? Jerry (06/29/04)
- interesting query design linqlin (06/29/04)
- SQL Error .... HELP Please Arookie VB'er Named Bob (06/29/04)
- Crosstab Queries KC (06/28/04)
- Help with an append queries Ann (06/28/04)
- Query Error Chris (06/28/04)
- Aggregate Query Gamliel (06/28/04)
- Need help with if statement in query and deleting a row Scott (06/28/04)
- Error using text functions in queries Ron (06/28/04)
- Can't Get Rid Of Quotes Brad (06/28/04)
- I need help on date subtraction Al (06/28/04)
- You cancelled the previous operation. mrs (06/28/04)
- Queries filling up SQL server! Craig (06/28/04)
- Update Query Becky (06/28/04)
- Help updating table from linked table(linked table is a csv) Thierry (06/28/04)
- all data from two tables Alex (06/28/04)
- Help Please with TOP - I think... Mike (06/28/04)
- Database Construction Query Matthew DeAngelis (06/28/04)
- Criteria data type mismatch ET (06/28/04)
- Striping a Date from a Date/Time Field Laura G (06/28/04)
- Crosstab query date sort Tracy (06/28/04)
- Union Queries anonymous_at_discussions.microsoft.com (06/28/04)
- More than just the Top 15 Heather (06/28/04)
- requirments caleb (06/28/04)
- Omitting a field when using SELECT * Nath (06/28/04)
- Append only present record an (06/28/04)
- Query shows duplicate results Mr. X (06/28/04)
- Access 2000 Vs Access 2003 adam (06/28/04)
- Query with input parms WarrenR (06/28/04)
- Spelling or syntax problem with SQL JonR (06/28/04)
- Simple Subtraction George (06/28/04)
- Bug? Limiting and ordering by datefield... Per-Olov Jernberg (06/28/04)
- Does Access know something like the Intersect expression? Alex Willinek (06/28/04)
- transposing rows to columns James Jones (06/28/04)
- Duplicate Values Query David Patterson (06/27/04)
- Bug? - Group By turning field property from Memo to Text Callaway (06/27/04)
- ACCESS DATE FORMAT GERALD HALES (06/27/04)
- PathName Declaration Bob (06/27/04)
- udate query won't Rover (06/27/04)
- Merge Tables Hadi Lalani (06/27/04)
- Singling out fields by text primary key Casa (06/27/04)
- Creating Indexes on Linked Tables Jim Pockmire (06/27/04)
- Combine update queries into one query anonymous_at_discussions.microsoft.com (06/27/04)
- Need Help with Pass-Through Query cil (06/27/04)
- General info... Ute (06/27/04)
- Merge a table and query into new table? Shyguy (06/26/04)
- VB and SQL Gym (06/26/04)
- Search Engine type query Bob (06/26/04)
- Problem with search Evan (06/26/04)
- Access Query Totals Question Hadi Lalani (06/26/04)
- Get record base on a date field Gary (06/26/04)
- Difficult Query jgspeer (06/26/04)
- Query a field to find an asterisk in the field Mark Stewart (06/26/04)
- Multiple Queries on one field Michael (06/26/04)
- Calculating Weekly Totals Van (06/26/04)
- Comparing first 5 characters Dave Redmond (06/26/04)
- Re: Comparing first 5 characters Van T. Dinh (06/26/04)
- Re: Comparing first 5 characters Dave Redmond (06/26/04)
- Re: Comparing first 5 characters Ken Snell (06/26/04)
- Re: Comparing first 5 characters fredg (06/26/04)
- Re: Comparing first 5 characters Dave Redmond (06/26/04)
- Re: Comparing first 5 characters Gary Walter (06/26/04)
- Re: Comparing first 5 characters Ken Snell (06/26/04)
- Re: Comparing first 5 characters Dave Redmond (06/26/04)
- Re: Comparing first 5 characters Gary Walter (06/26/04)
- Re: Comparing first 5 characters Ken Snell (06/26/04)
- Re: Comparing first 5 characters Dave Redmond (06/26/04)
- Re: Comparing first 5 characters Ken Snell (06/26/04)
- Re: Comparing first 5 characters Dave Redmond (06/26/04)
- Re: Comparing first 5 characters Ken Snell (06/26/04)
- Re: Comparing first 5 characters Dave Redmond (06/27/04)
- Re: Comparing first 5 characters Ken Snell (06/27/04)
- Re: Comparing first 5 characters Dave Redmond (06/26/04)
- Re: Comparing first 5 characters Van T. Dinh (06/26/04)
- Syntax assistanc requested for [last,first] conversion anonymous_at_discussions.microsoft.com (06/25/04)
- Select Queries: Finding the next record Tammie (06/25/04)
- why does this query not run? somanybugssolittletimetofixthem (06/25/04)
- export as .csv Michael D. McGill (06/25/04)
- the same query problem Alex (06/25/04)
- Very Slow Query Chaplain Doug (06/25/04)
- SQL mrs (06/25/04)
- Averaging a query with a subquery Gamliel (06/25/04)
- Circular reference error in query kicks me out of Access Kbone (06/25/04)
- Crosstab Worries Jeremy Noland (06/25/04)
- disregard last message from me Andrew Gould (06/25/04)
- INSERT INTO syntax problem Andrew Gould (06/25/04)
- Crosstab Query link to Form Don (06/25/04)
- Table update problem Dave (06/25/04)
- Reset Auto Number Jean (06/25/04)
- Unmatched Query - Please Help Nikhil (06/25/04)
- RE: need help using IIf condition in a query Fredrick Smith (06/25/04)
- Carried Forward Amounts Bruum (06/25/04)
- Selection criteria JonR (06/25/04)
- Update queries Amorfosis (06/25/04)
- select count (distinct) issue BearTrap3 (06/25/04)
- Access changes bracketing of subqueries in joins causing syntax er David Yanacek (06/25/04)
- Repost: Parsing data into multiple fields Avid Reader (06/25/04)
- newbie's question raj (06/25/04)
- Criteria - multiple column table Sophisticated Penguin (06/25/04)
- Access changes bracketing of subqueries in joins, causing syntax e David Yanacek (06/25/04)
- Alter Table Query - Easy Question R Weston (06/25/04)
- Carried Forward Query Bruum (06/25/04)
- Access changes bracketing of subqueries in joins, causing syntax e David Yanacek (06/25/04)
- Access changes bracketing of subqueries in joins, causing syntax e David Yanacek (06/25/04)
- Why is this not updatable? Darren (06/25/04)
- Access to SQL Server-Date functions Arch (06/25/04)
- ReturnsRecords problem? Tom (06/25/04)
- specific fajita (06/25/04)
- Query Problem Diana (06/25/04)
- Eliminating blanks from a query Eirc (06/25/04)
- Query by date ranges Todd (06/25/04)
- Sum By Week ????? Tim N (06/25/04)
- Select Query - Data type Allison (06/25/04)
- Part of text field extract Bobby Internet (06/25/04)
- Requery Method Nexus (06/25/04)
- Query to Stored Procedure Keith Emery (06/25/04)
- query error lin qin (06/25/04)
- interesting query problem lin qin (06/25/04)
- Top # query question Gregg (06/24/04)
- Query Design View Application Error Simon (06/24/04)
- Parsing data into multiple fields Avid Reader (06/24/04)
- Text to Date Jeremy Noland (06/24/04)
- string fns in query liva (06/24/04)
- Query challenge Mark Burns (06/24/04)
- Leave Records Update Monthly Pete T (06/24/04)
- An update query? Heather (06/24/04)
- Good - Bad Query George (06/24/04)
- Null Query Field Brook (06/24/04)
- Need to use unbound calcuated total on subform in a query C. Homey (06/24/04)
- Help me please! Divatox (06/24/04)
- tables' relationship problem Alex (06/24/04)
- Crosstab Combine Jeremy Noland (06/24/04)
- Query Syntax Error R Weston (06/24/04)
- Update Query and Add Dates Tom Nowak (06/24/04)
- Urgent - deleting partial amounts of a field Nikhil (06/24/04)
- DLookUp Mike C (06/24/04)
- Slow Query Chaplain Doug (06/24/04)
- NPV Mark (06/24/04)
- Query Help (again!) Alex (06/24/04)
- Sorting Months Jim (06/24/04)
- outlook and Access Phil (06/24/04)
- Convert Time to Decimal V Terry (06/24/04)
- Parse Expression Nichole (06/24/04)
- Remove duplicate records? Jackmac (06/24/04)
- TransferSpreadsheet Problem RudiK (06/24/04)
- Error: Not enough space on temoporary disk rob parkin (06/24/04)
- Make table query into password protected mdb Walter Hofmann (06/24/04)
- Countif ? marcus. (06/24/04)
- Need help with query strategy Jerry (06/24/04)
- qrydef to pass a form control to an existing query Darrell (06/24/04)
- Using Switch Function to Group Column Headings in a Crosstab Query Karen (06/23/04)
- How: if not null then delete text in a query Michelle Watson (06/23/04)
- Query is only displaying from one table and not the other Jazz (06/23/04)
- Please help.... Bill (06/23/04)
- tables to queies to reports fajita (06/23/04)
- Using two or more tables: No Shows? fajita (06/23/04)
- Using two or more tables: No Shows? fajita (06/23/04)
- Calculated Query??? Alex (06/23/04)
- Cross tab queries Mark (06/23/04)
- Transform??? Alejandra Parra (06/23/04)
- Time Elapsed Ashley (06/23/04)
- Crosstab problem David (06/23/04)
- Specifying Criteria Lost In Queries (06/23/04)
- can anyone provide a query for this madhur (06/23/04)
- 'Full' outer join syntax DOTJake (06/23/04)
- assign value to take all records AlexD (06/23/04)
- Drop down box for criteria Barry (06/23/04)
- Access Project ADP Dib (06/23/04)
- calculation in a table steve c (06/23/04)
- Lookup Problem Peter (06/23/04)
- slow queries Alex (06/23/04)
- Query from 2 tables Ashley (06/23/04)
- convert text to number Rob (06/23/04)
- sorting address/streets kathy (06/23/04)
- Comparison Query sh (06/23/04)
- Sort of a Access Query riddle with address fields. landen (06/23/04)
- Date/Time query Doesn't Work :( Mike E (06/23/04)
- Increment number in append query Jean (06/23/04)
- count individuals of a certain sizes in one query jw (06/23/04)
- Top 10 on multiple rows Sean (06/23/04)
- What is Date/Time format in SQL string statements? SROSeaner (06/23/04)
- Use of Last function in a query Andy (06/23/04)
- Criteria/Parameter Prompt for Multiple Values Allan (06/23/04)
- Duplicate Delete Query? Barry Hammill (06/23/04)
- Unmatched Query Allison (06/23/04)
- Print a Name Badge steve matco (06/23/04)
- Table name as parameter in SQL query Art (06/23/04)
- Is this a Query sh (06/23/04)
- Passing Filtered Recordset to an Update query Noel (06/23/04)
- Null Values Colin Basterfield (06/23/04)
- Expression Problem JH (06/23/04)
- Query Criteria from Unbound Calendar Mark Warren (06/23/04)
- Need help w/ Challenging Query Tom (06/22/04)
- Moving Multiple Related Records Tony (06/22/04)
- Using an update query to load one table from another gglazer (06/22/04)
- dynamic alias? mark (06/22/04)
- query+date order J.J. (06/22/04)
- Query Multiple Fields Cecil (06/22/04)
- Complex Crosstab Query Jeremy Noland (06/22/04)
- Update Query Jim (06/22/04)
- Simple Query Not Working Michael DiCostanzo (06/22/04)
- Crosstab changes periods d33 (06/22/04)
- Select query Allison (06/22/04)
- IIf statement in Criteria Brent_Fanguy (06/22/04)
- AVERAGE SteveL (06/22/04)
- calculated flds problem? data type mismatch in criteria expression JPM (06/22/04)
- if statement??? Alienz (06/22/04)
- WHERE statement from variable? Kyle B. (06/22/04)
- Is there a way around a Type Mismatch Error? Kristen (06/22/04)
- Access 2000 to 2003 mail merge to word JJ (06/22/04)
- DatePart Melinda (06/22/04)
- Where is the PRINT button? wthebnartheujkelsbnt (06/22/04)
- embedded hyperlink in access Pat (06/22/04)
- Easy Update question Angi (06/22/04)
- alpha query Alex (06/22/04)
- GROUP BY help David (06/22/04)
- invalid argument kathy (06/22/04)
- COUNT + HELP J.J. (06/22/04)
- Error: Undefined function Maureen (06/22/04)
- Ranking query running EXTREMELY slow Sean G. (06/22/04)
- Need to select between dates JonR (06/22/04)
- Self join query MK (06/22/04)
- need help with this query keyur (06/22/04)
- Re post as no responses - join problem with query Julia Boswell (06/22/04)
- Name field with variable? mgp (06/22/04)
- Wildcards in records possible? Ralph Hersener (06/22/04)
- Data Type Mismatch - no missing references Nolan Madson (06/22/04)
- Update Query (searching with wildcards and replacing) Alex1984 (06/22/04)
- Select between 2 dates RC (06/22/04)
- Re: query a string of text John Vinson (06/22/04)
- what went wrong ?? - DateValue Query Mann (06/22/04)
- What's wrong with my DateValue Query mann (06/22/04)
- Top 3 Group By stumper topdog (06/22/04)
- Re: Top 3 Group By stumper Dale Fye (06/22/04)
- Re: Top 3 Group By stumper topdog (06/22/04)
- Re: Top 3 Group By stumper Gary Walter (06/22/04)
- Re: Top 3 Group By stumper topdog (06/26/04)
- Re: Top 3 Group By stumper Gary Walter (06/26/04)
- Re: Top 3 Group By stumper topdog (06/27/04)
- Re: Top 3 Group By stumper Gary Walter (06/27/04)
- Re: Top 3 Group By stumper topdog (06/27/04)
- Re: Top 3 Group By stumper Gary Walter (06/27/04)
- Re: Top 3 Group By stumper Gary Walter (06/29/04)
- Re: Top 3 Group By stumper topdog (06/22/04)
- Re: Top 3 Group By stumper Dale Fye (06/22/04)
- Trouble with RunningSum Tammy (06/22/04)
- Developing a Query Tammy (06/21/04)
- INSET SELECT with Union Dan (06/21/04)
- making a join case sensitive Amy H. (06/21/04)
- Trying to create a total Kelli McCann (06/21/04)
- Temp/Main RecNo Increments Praveen Manne (06/21/04)
- Selecting between two dates JonR (06/21/04)
- Changeing Date Formats Mars (06/21/04)
- DATEPART Function Adam (06/21/04)
- Changeing Date formats Mars (06/21/04)
- HELP me solve this ODBC connection ERROR !!! VJ (06/21/04)
- DCount problem Tom (06/21/04)
- SQL problem - need advice wthebnartheujkelsbnt (06/21/04)
- work hours vs home hours V. Terry (06/21/04)
- Muli layered query Rich (06/21/04)
- 4 months less from today in where Alex (06/21/04)
- Unique records Andrea (06/21/04)
- Crosstab - Make table DEI (06/21/04)
- Running a report to print a name badge Steve (06/21/04)
- Referenceing subforms Scott (06/21/04)
- Monthly Compare Mickey (06/21/04)
- no results returned in query anonymous_at_discussions.microsoft.com (06/21/04)
- Update another table with a Max record query Ngan (06/21/04)
- Cross Tab Query Veti (06/21/04)
- Calculated Expressions with IIF Statement Tina Hudson (06/21/04)
- calculating grand total anonymous_at_discussions.microsoft.com (06/21/04)
- Invalid Operation error? djc (06/21/04)
- System Resource Exceeded Mike (06/21/04)
- Functions/Operators Resource needed V. Terry (06/21/04)
- Need Help with LIKE Tony B (06/21/04)
- RE: Lock-up with IN keyword Eric Cárdenas [MSFT] (06/21/04)
- practice on queries maryam (06/21/04)
- combobox criteria for parameter query ed (06/21/04)
- Date reference as criteria in query Tim Brown (06/20/04)
- WildCard Mike (06/20/04)
- InputParameters BlackSun (06/20/04)
- access 2003 select query closes access Keith G Hicks (06/20/04)
- Percentage Query Max (06/20/04)
- Vlookup variation Yandros (06/20/04)
- How to show percent variation over time Sidnei B Cordeiro (06/20/04)
- Why doesn't my LEFT JOIN work? Dave (06/20/04)
- duplicate rows returned in a query Ray (06/20/04)
- duplicate rows returned Ray (06/20/04)
- Showing overlapping Dates Jeff (06/20/04)
- Add column to query table Mimi (06/19/04)
- removing letters from s/n Paul sullivan (06/19/04)