microsoft.public.access.queries
By Thread
4046 messages sorted by: [ date ]
Starting: 02/29/04
Ending: 03/31/04
- Getting: Invalid Argument when trying to save a simple query Public Served (03/31/04)
- date function query nerd (03/31/04)
- Need to select first N rows which meet criteria mike klein (03/31/04)
- Expression help Book Man (03/31/04)
- Counting Karen (03/31/04)
- multiple Criteria Georgia (03/31/04)
- query from 2 tables maggie (03/31/04)
- crosstab query does not recognize form reference SusanW (03/31/04)
- Missing Numbers AHopper (03/31/04)
- BIZZARE issue can not view data added to table DBarker (03/31/04)
- Re: $B6u9A$NF|(B Dale (03/31/04)
- sum up the column tony wong (03/31/04)
- multiple field "or" criteria nd (03/31/04)
- expression and new field on query Marko (03/31/04)
- Query? anonymous_at_discussions.microsoft.com (03/31/04)
- Rank Function Dan (03/31/04)
- Find records without any corresponding record in another table Brad (03/31/04)
- Find duplicates - multiple column combination MDW (03/31/04)
- Update Query Not Updatable anonymous_at_discussions.microsoft.com (03/31/04)
- How to select row numbers? Jarek (03/31/04)
- Migrating to SQL Server from Access May (03/31/04)
- update query not updatable Jazinwaz (03/31/04)
- Networkdays function in Access Joey (03/31/04)
- Date Restrictor ChuckW (03/31/04)
- Order by 4 columns at once Michael Hetrick (03/31/04)
- Query Syntax error for Concatenate DBarker (03/31/04)
- OverFlow Error Message Russ (03/31/04)
- Delete Query does not work! Renvik (03/31/04)
- Update query - multiple criterias Carlos (03/31/04)
- Count Query AHopper (03/31/04)
- Queries with no records - John Viescas?? Tony Williams (03/31/04)
- Re: Queries with no records - John Viescas?? John Viescas (03/31/04)
- Re: Queries with no records - John Viescas?? Tony Williams (03/31/04)
- Re: Queries with no records - John Viescas?? John Viescas (03/31/04)
- Re: Queries with no records - John Viescas?? Tony Williams (03/31/04)
- Re: Queries with no records - John Viescas?? John Viescas (03/31/04)
- Re: Queries with no records - John Viescas?? Tony Williams (03/31/04)
- Re: Queries with no records - John Viescas?? John Viescas (03/31/04)
- Re: Queries with no records - John Viescas?? Tony Williams (03/31/04)
- Re: Queries with no records - John Viescas?? John Viescas (03/31/04)
- Access Query dates Gerald (03/31/04)
- Srvey query help needed Mark (03/31/04)
- Parameter query Steve (03/31/04)
- Counting Karen (03/31/04)
- D COUNT DD (03/31/04)
- More info for below question Dennis (03/31/04)
- Compare 2 files and delete Dennis (03/31/04)
- Creating a Primary Key Max Palmer (03/31/04)
- How to build the SQL of getting fields property? Tiger (03/31/04)
- updating a field in the "one" table Paul James (03/31/04)
- Concatenate String mj (03/30/04)
- Joining on a Field with Leading Zeros Dori (03/30/04)
- Removing Duplicate Records Jasmine (03/30/04)
- Rank (Simple Order) John R. Baker (03/30/04)
- Rounding averages shaggles (03/30/04)
- Query converted to VBA code Chris (03/30/04)
- problem with parameter query Dogface (03/30/04)
- Challenging Query/report Sophia (03/30/04)
- pass through query Alison (03/30/04)
- String function for update query? Amit (03/30/04)
- Assistance with this query Terri (03/30/04)
- Queries RAD (03/30/04)
- group/sort George Schneider (03/30/04)
- Make Table Query Helen (03/30/04)
- Cumulative Total - repost Shawna (03/30/04)
- How to properly join/relate tables in a query to populate fields MacLean (03/30/04)
- Rounding numbers Mark (03/30/04)
- Filtering Question Zane (03/30/04)
- totals George Schneider (03/30/04)
- Select distinct question hedrew3 (03/30/04)
- Counting records John (03/30/04)
- Maximum values Chad (03/30/04)
- select in the midle of a criteria with iif... Luis Assunção (03/30/04)
- Excluding Weekends Dave (03/30/04)
- Find records based on dates in another table Paul Fenton (03/30/04)
- Finding a MAX value across columns. DPCpresto (03/30/04)
- Top 1 ? Mike (03/30/04)
- data manipulation Jasmine (03/30/04)
- Queries John (03/30/04)
- Field Automatically Allison (03/30/04)
- Validation/expression Cool J (03/30/04)
- unwanted parameters john (03/30/04)
- Paramter queries accessed remotely Steve (03/30/04)
- How to do this? Nich (03/30/04)
- Expression help needed ken (03/30/04)
- Expressions Marko (03/30/04)
- User Defined Constraints John (03/30/04)
- Parameter Query David Sullivan (03/30/04)
- Sub Query Problem Chris (03/30/04)
- SV: Quering Active Directory from Access WoC (03/30/04)
- Cumulative Qty Shawna (03/30/04)
- get back on a sql command Rodolfo Fontes (03/30/04)
- graph crosstab kniva (03/30/04)
- You tried to execute a query that does not include the specified expression <name> as part of an aggregate function. (Error 3122) Chiral (03/30/04)
- Re: You tried to execute a query that does not include the specified expression <name> as part of an aggregate function. (Error 3122) Michel Walsh (03/30/04)
- Re: You tried to execute a query that does not include the specified expression <name> as part of an aggregate function. (Error 3122) Van T. Dinh (03/30/04)
- Query about joining table Edmund (03/30/04)
- Totals Query James (03/30/04)
- specific query sarah kiernan (03/30/04)
- Need Idiots guide to this please Sal (03/30/04)
- Equivalent of start with and connect by clause in MS Access 2000 Kutub (03/30/04)
- Query Criteria JChick (03/30/04)
- NOT use in a query Purny (03/30/04)
- tks mark (03/30/04)
- Format date/time column to select dates between Brian L. Thor (03/30/04)
- Retrieve Multiple Values into a comma-delimited string W Dean (03/30/04)
- Attn Fredg Lurch (03/30/04)
- Query Calculation RobinF (03/30/04)
- Error message on query Kirk P (03/30/04)
- Now for my next question... Lurch (03/30/04)
- Trouble with Criteria in query Lurch (03/30/04)
- Union Query TWLiz (03/29/04)
- Update 5,000 records at a time johnduran (03/29/04)
- form/subform Tom (03/29/04)
- Outputting each group to diff table Akira (03/29/04)
- Update Query help needed Amit (03/29/04)
- combine queries TY (03/29/04)
- Counting Number of Accounts Patrick Graham (03/29/04)
- SQL Reference David Rovetto (03/29/04)
- Top 2 records from related table Steve (03/29/04)
- Fields Automatically Allison (03/29/04)
- Group Counts Amy (03/29/04)
- Grouping by Weight Groups tmkscout575 (03/29/04)
- Saving complex query blows up Access 2002! Mark Burns (03/29/04)
- need to find total hours for each employee meangoose (03/29/04)
- Joins anonymous_at_discussions.microsoft.com (03/29/04)
- Undefined function in expression error anonymous_at_discussions.microsoft.com (03/29/04)
- Query for all Journal entries per CaseID Karen (03/29/04)
- Select excluding multiple records in the same field Not Like Ian Eagland (03/29/04)
- Update Query Allison (03/29/04)
- Creating expressions Book Man (03/29/04)
- Dropdown List Craig (03/29/04)
- dynamic suquery Luis Assunção (03/29/04)
- Crosstab Query help ken (03/29/04)
- Access/Direct Mail Manager problems Russ (03/29/04)
- Q. How do I total the number of fields in a table ? Jim Jones (03/29/04)
- Change the text on the fieldname to record info. Karen (03/29/04)
- need help on INNER JOIN mark (03/29/04)
- interactive query Taco (03/29/04)
- Average of values in several fields Herman (03/29/04)
- FAO Kevin Sprinkel (Totals Query) James (03/29/04)
- Access2000: ODBC query from VBA - like one in Excel Arvi Laanemets (03/29/04)
- search report data source? eddiec (03/29/04)
- Format Expression sort problem Nilesh Butala (03/29/04)
- Using Format expresstion for date Nilesh BUtala (03/29/04)
- Dsum Frank Dulk (03/29/04)
- querydef help missing. B Nieds (03/29/04)
- Query Criteria from a Selection Mike S. (03/29/04)
- Duplicates Dennis (03/29/04)
- Next record data needed for calc Malcolm (03/29/04)
- autonumber in a query? Frank Dulk (03/29/04)
- Merging two tables Mark G. (03/28/04)
- language version Yohann (03/28/04)
- cumulative total query Shawna (03/28/04)
- Britney Spears nude celebsrus (03/28/04)
- Counting Across Fields Mike DeNuccio (03/28/04)
- Reply: SQL View - Library Database Marko (03/28/04)
- Help Marko (03/28/04)
- SQL View - Library Database Marko (03/28/04)
- Library Database ozogeordie_at_hotmail.com (03/28/04)
- Library Database Marko (03/28/04)
- query variable Vsn (03/28/04)
- Library Database fines query Marko (03/28/04)
- Library Database fines query Marko (03/28/04)
- query calculation Vsn (03/28/04)
- Show what's NOT there John Vinson (03/28/04)
- Access upgrades needhelp (03/28/04)
- StrConv Error in Access 200 Query John Van Dusen (03/28/04)
- I need a customer sales listing that includes no-sales months. Frank Martin (03/28/04)
- QueryDefs.Delete marc (03/28/04)
- crosstab query - find maximum Value each Day, report time of day David (03/28/04)
- problem with using "SUBSTRING" function in a query Mike Legaspi (03/27/04)
- Delete query to Form and SubForm fields an (03/27/04)
- Test for IT Course Megan (03/27/04)
- Query in code Marc (03/27/04)
- Fines Marko (03/27/04)
- Library Database Jay (03/27/04)
- Working out Fines for library Marko (03/27/04)
- Append Query - Need Help! Fred Worthington (03/27/04)
- Microsoft Access Date Calculation Marko (03/27/04)
- Re: Microsoft Access Date Calculation Steve Schapel (03/27/04)
- Re: Microsoft Access Date Calculation Douglas J. Steele (03/27/04)
- Re: Microsoft Access Date Calculation Gerald Stanley (03/27/04)
- Re: Microsoft Access Date Calculation John Vinson (03/27/04)
- Microsoft Access Date Calculation Bernie (03/27/04)
- Creating a Tag Susan C (03/27/04)
- Complex Query Joe (03/27/04)
- Problem with subtracting amounts Jean du Plessis (03/27/04)
- Exclude latest record KevinW (03/27/04)
- Exclude latest record KevinW (03/27/04)
- Same data in field Viv (03/27/04)
- untach rows JIM.H. (03/27/04)
- Add non-existing records? Alp Bekisoglu (03/27/04)
- ÃÀºÃÊôÓÚÄú ºú¿¡ÖÐ (03/27/04)
- Update date if other field "yes" Dennis (03/27/04)
- Re: Update date if other field "yes" Duane Hookom (03/27/04)
- Re: Update date if other field "yes" Dennis (03/27/04)
- Re: Update date if other field "yes" Duane Hookom (03/27/04)
- Re: Update date if other field "yes" Dennis (03/27/04)
- Re: Update date if other field "yes" Duane Hookom (03/28/04)
- Re: Update date if other field "yes" Dennis (03/28/04)
- Re: Update date if other field "yes" Duane Hookom (03/28/04)
- Re: Update date if other field "yes" Dennis (03/28/04)
- Re: Update date if other field "yes" Dennis (03/27/04)
- Re: Update date if other field "yes" Duane Hookom (03/27/04)
- Import Theory Dennis (03/27/04)
- Concatenation Dilemma Don Hicks (03/27/04)
- WHERE in code to a query Marc (03/27/04)
- Summing like fields across tables lars (03/27/04)
- Sum individual counts Vincent (03/26/04)
- Fancy Crosstab Try Again! Susy (03/26/04)
- Fancy Crosstab Susy (03/26/04)
- Query merge to Word problem dyaussi (03/26/04)
- Check Box in Access Query Asa Kaplan (03/26/04)
- Criteria for Yes/No and Check Box Asa Kaplan (03/26/04)
- Help with SQL Syntax... Louie Warren (03/26/04)
- Average Duration Per month ken (03/26/04)
- Missing operator in join query Jon Cosby (03/26/04)
- No Current Record? Lynne (03/26/04)
- create query with a loop (in SQL?) Zac (03/26/04)
- Date Query Dave Spence (03/26/04)
- Do While Loop maybe? Bob (03/26/04)
- Can't Update table from Crosstab Data? WHY not? fred (03/26/04)
- update query and working with dates Paul Kinville (03/26/04)
- How can I set DefaultValue in a SQL script? Servane (03/26/04)
- How do I search for a specific date? How do I search for specific date? (03/26/04)
- Update Query Help! PLEASE!!! Paul Kinville (03/26/04)
- Creating a Bill of Materials Query Mike (03/26/04)
- different sorting order Rawley (03/26/04)
- Access Query Bob Leonard (03/26/04)
- Query based form question Jeremy Dove (03/26/04)
- SQL.Log file enormous. Brad Vontur (03/26/04)
- FAO Kevin Sprinkel (Totals Query) James (03/26/04)
- Auto lookup Query Adrienne (03/26/04)
- Export Date as DDMMYYYY Mo (03/26/04)
- test mo (03/26/04)
- Error messages displaying in foreign language rmcclelland (03/26/04)
- Operation Must Use An Updateable Query Jay (03/26/04)
- CrossTab-Columns Calculation Djoezz (03/26/04)
- Help !!!! ... please :-) User Defind function, Access Session not closing Kevin McCartney (03/26/04)
- Queries with no records Tony Williams (03/26/04)
- Help !!! - Recordset set to Me.RecordsetClone Kevin McCartney (03/26/04)
- Updating a Linked ODBC table bj (03/26/04)
- Access 2000 Asa Kaplan (03/26/04)
- Query keeps freezing Andrew (03/26/04)
- Last-n in totals query grid Steve (03/26/04)
- Datatype mismatch problem when using user-defined function in select query Nelson C (03/25/04)
- Simple Date() criteria Ron Mohr (03/25/04)
- Determine if number is even or odd SGURDON (03/25/04)
- Help on Query Bill (03/25/04)
- Simple MAX Query? dlw (03/25/04)
- decimal places anonymous_at_discussions.microsoft.com (03/25/04)
- Top 20 Recs in group Savadi (03/25/04)
- Reserved error -1517 George Lob (03/25/04)
- Parsing names Hanksor (03/25/04)
- Update Query to transfer data from one table to another. Jay (03/25/04)
- quotes around exported numbers anonymous_at_discussions.microsoft.com (03/25/04)
- Syntax Dave Karmens (03/25/04)
- problems with ordering by date aa (03/25/04)
- Crosstab and NOT EXISTS Bas Cost Budde (03/25/04)
- Is it possible to do a Bi-monthly DateDiff? Lynndyhop (03/25/04)
- Query by Date DCost_at_Sovereignbank.com (03/25/04)
- Percentage Query Sal (03/25/04)
- Append Query question Saul (03/25/04)
- Subquery in an Update statement. Why doesn't this work? Jarek (03/25/04)
- Using a Memo Field in a Combo Box Pete Hadden (03/25/04)
- extracting partial string SK (03/25/04)
- Access Summing Sal (03/25/04)
- Queries in data access pages Dan (03/25/04)
- Alter Table Greg (03/25/04)
- Invalid query name Keith H. (03/25/04)
- HEEEELLLLPPPP tinwood (03/25/04)
- Search Worksheet Function mcl (03/25/04)
- Remove duplicates and capture duplicates again and again? Omahadave (03/25/04)
- Seconds in Decimal formet to Long Time Hasan (03/25/04)
- URGENT!!! parameter queries Colleen (03/25/04)
- Concatenating field value and text to get new field name William P. (03/25/04)
- Limit on IIF's Perico (03/25/04)
- Recordset set to Me.RecordsetClone Kevin McCartney (03/25/04)
- value max every year giorgio (03/25/04)
- Parameter Query Janet F (03/25/04)
- Query not returning any records Tara (03/25/04)
- don joebob (03/25/04)
- Export result of SQL query to Excel Jonathan Blitz (03/25/04)
- Need help nesting a formula Patti (03/25/04)
- Syntax error in date in query expression for Swiss Italian date format Timothy M Hodgson (03/25/04)
- Field Breakup DW (03/25/04)
- Help Darren Spooner (03/25/04)
- lookup in access sheetal (03/25/04)
- lookup in access sheetal (03/25/04)
- limiting a query KATH (03/25/04)
- editing query with functions gives app error Zac (03/25/04)
- Rounding Up George Schneider (03/25/04)
- Sum of Sums aa (03/25/04)
- Highest Value Sal (03/25/04)
- Access Averaging Sal (03/25/04)
- FAO Kevin Sprinkel (Totals Query) James (03/25/04)
- Yes/no criteria Clare (03/25/04)
- Find no matches on the many side PizzaBoy (03/25/04)
- Delete Query giving a 3086 error of "read only file" dwilson (03/25/04)
- Concatenate Text Field DBarker (03/25/04)
- RE: Concatenate Text Field Jim Richards (03/25/04)
- RE: Concatenate Text Field DBarker (03/25/04)
- Re: Concatenate Text Field John Spencer (MVP) (03/25/04)
- Re: Concatenate Text Field DBarker (03/25/04)
- Re: Concatenate Text Field John Spencer (MVP) (03/26/04)
- Re: Concatenate Text Field DBarker (03/27/04)
- Re: Concatenate Text Field DBarker (03/27/04)
- Re: Concatenate Text Field John Spencer (MVP) (03/28/04)
- Re: Concatenate Text Field anonymous_at_discussions.microsoft.com (03/31/04)
- RE: Concatenate Text Field DBarker (03/25/04)
- RE: Concatenate Text Field Jim Richards (03/25/04)
- Duplicate Query SeRene (03/25/04)
- Update table from other (multiple) tables. Please help! Max (03/25/04)
- Adding and Subtracting Times Daniel Brown (03/24/04)
- Group by - Concatenate Jeremy (03/24/04)
- Join types Luke Bellamy (03/24/04)
- Problem retrieving the MAX date in a a query Jason M (03/24/04)
- merge 3 columns into 1 with a query Kathy (03/24/04)
- Help with Query mxinter (03/24/04)
- Need help writing report Rawley (03/24/04)
- IF Then Statement matt (03/24/04)
- Round Down an Expression jlp (03/24/04)
- Grouping by month tod (03/24/04)
- Need help aggregating and using WHERE Sandy S (03/24/04)
- multiple table query emily (03/24/04)
- Using Excel.Application Jose (03/24/04)
- SQL "Memo" select Larry (03/24/04)
- Automation Object error message Tom (03/24/04)
- Query Design Grid disappeared Dkline (03/24/04)
- number format for text export sandie (03/24/04)
- Re: Anybody Found A Long Lasting Access Contract In Last Two Years? Sirocco (03/24/04)
- Why isnt this working? Messenger69 (03/24/04)
- delete query gives read only property dwilson (03/24/04)
- memo to text field Shailesh Patel (03/24/04)
- datediff in parameter query Kenny G (03/24/04)