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)
- Re: datediff in parameter query John Viescas (03/24/04)
- Re: datediff in parameter query Kenny G (03/25/04)
- Re: datediff in parameter query John Viescas (03/25/04)
- Re: datediff in parameter query Kenny G (03/25/04)
- Re: datediff in parameter query John Viescas (03/26/04)
- Re: datediff in parameter query Kenny G (03/26/04)
- Re: datediff in parameter query John Viescas (03/26/04)
- Re: datediff in parameter query Kenny G (03/26/04)
- Re: datediff in parameter query John Viescas (03/26/04)
- Re: datediff in parameter query Kenny G (03/29/04)
- Re: datediff in parameter query Kenny G (03/25/04)
- Re: datediff in parameter query John Viescas (03/24/04)
- Accessing query through vb Dan (03/24/04)
- Simple date range selection DaveM (03/24/04)
- Minimum Length of a field in a query Erin (03/24/04)
- Creating multiple fields in a query from one table field Water Engineer (03/24/04)
- Finding Lower Case Characters Xavier (03/24/04)
- criteria in query anonymous_at_discussions.microsoft.com (03/24/04)
- Access Queries Sal (03/24/04)
- accounting for leap years in data calculations dc2696 (03/24/04)
- Using a Query parameter in an "In()"-Clause Hyko (03/24/04)
- Find most recent assignment for each employee Rick (03/24/04)
- Distinguish Language Character Set KTsolis (03/24/04)
- Top Value for a subgroup Richardson (03/24/04)
- Crosstab/Subquery Question??? Deville (03/24/04)
- Multiple Serial Number Query Denise (03/24/04)
- Making a calculation with a Text field HM (03/24/04)
- Make Table Queries Tim (03/24/04)
- date calculate Ezekiël (03/24/04)
- Weeknumber (Week of Year) Heinz Kammerlander (03/24/04)
- Add up a column of hours Brandon (03/24/04)
- Square root command in SQL David Gartrell (03/24/04)
- Splitting Fieild Data Phil Jones (03/24/04)
- Lazy Teacher Ripper (03/24/04)
- Subtracting date and time values Calvin Shane (03/24/04)
- Re: Subtracting date and time values Tom Ellison (03/24/04)
- Re: Subtracting date and time values Calvin (03/24/04)
- Re: Subtracting date and time values Tom Ellison (03/24/04)
- Re: Subtracting date and time values Calvin Shane (03/24/04)
- Re: Subtracting date and time values Tom Ellison (03/24/04)
- Re: Subtracting date and time values Calvin Shane (03/25/04)
- Re: Subtracting date and time values Calvin Shane (03/25/04)
- Re: Subtracting date and time values Tom Ellison (03/25/04)
- Re: Subtracting date and time values Tom Ellison (03/25/04)
- Re: Subtracting date and time values Calvin Shane (03/25/04)
- Re: Subtracting date and time values Tom Ellison (03/25/04)
- Re: Subtracting date and time values Calvin Shane (03/25/04)
- Re: Subtracting date and time values Tom Ellison (03/26/04)
- Re: Subtracting date and time values Calvin Shane (03/26/04)
- Re: Subtracting date and time values Tom Ellison (03/26/04)
- Re: Subtracting date and time values Calvin Shane (03/26/04)
- Re: Subtracting date and time values Tom Ellison (03/26/04)
- Re: Subtracting date and time values Calvin Shane (03/27/04)
- Re: Subtracting date and time values Tom Ellison (03/27/04)
- Re: Subtracting date and time values John Vinson (03/27/04)
- Re: Subtracting date and time values Calvin Shane (03/30/04)
- Re: Subtracting date and time values Tom Ellison (03/30/04)
- Re: Subtracting date and time values Calvin Shane (03/24/04)
- Re: Subtracting date and time values Calvin Shane (03/24/04)
- Re: Subtracting date and time values Tom Ellison (03/24/04)
- Re: Subtracting date and time values Calvin (03/24/04)
- Re: Subtracting date and time values Tom Ellison (03/24/04)
- Get max # record from related table Steve Sherman (03/24/04)
- Problem mailmerging query data into MS Word Ross Gwyther (03/24/04)
- Using data from one subform in the calculation of another Mark Schwartz (03/24/04)
- Help with multiple criteria query Jason M (03/24/04)
- Re: Query combo box on tab question John Spencer (MVP) (03/24/04)
- WHERE clause applies to right-hand table of LEFT JOIN Joseph Geretz (03/23/04)
- Re: WHERE clause applies to right-hand table of LEFT JOIN Dan Guzman (03/24/04)
- Re: WHERE clause applies to right-hand table of LEFT JOIN Joseph Geretz (03/24/04)
- Re: WHERE clause applies to right-hand table of LEFT JOIN Tibor Karaszi (03/24/04)
- Re: WHERE clause applies to right-hand table of LEFT JOIN Dan Guzman (03/24/04)
- Re: WHERE clause applies to right-hand table of LEFT JOIN Joseph Geretz (03/24/04)
- Re: WHERE clause applies to right-hand table of LEFT JOIN david epsom dot com dot au (03/25/04)
- Re: WHERE clause applies to right-hand table of LEFT JOIN Joseph Geretz (03/24/04)
- Re: WHERE clause applies to right-hand table of LEFT JOIN Dan Guzman (03/24/04)
- Delete from Duplicate Query Wizard Toan Chau (03/23/04)
- Rolling 1 year max zac (03/23/04)
- Output query to template Dan (03/23/04)
- Special Linking: Optimizations/Suggestions? Ken (03/23/04)
- Show zero count as 0 Sam (03/23/04)
- Please ignore Please Ignore (03/23/04)
- Can't Get Update Query To Work Robert (03/23/04)
- SELECT qry - type mismatch Mimi (03/23/04)
- Select date of last visit Toni (03/23/04)
- Status Bar Message Display Rami (03/23/04)
- Month Names Al (03/23/04)
- Show Null Count Alex (03/23/04)
- Multiple Crosstab Queries grouped by a field Autumn (03/23/04)
- Criteria Vina (03/23/04)
- Query with multiple criteria esi (03/23/04)
- Replace Query for 2000 Jean D (03/23/04)
- Creating a CD w/ a database Dan (03/23/04)
- Run Query error Adrienne (03/23/04)
- Transpose Vertical to Horizontal MIke (03/23/04)
- Prior record Brooke (03/23/04)
- Making a Query compare entries in seperate tables Scott Crews (03/23/04)
- query outer join?? katie (03/23/04)
- "IN" Wei (03/23/04)
- a query to view all the invoice numbers and their totals aa (03/23/04)
- What is <1? Perico (03/23/04)
- Getting a percentage ten-d (03/23/04)
- Change sub-form using combo box & query? Kitt (03/23/04)
- Update query- update a copy of entire table Gabe (03/23/04)
- How do a make a query see a text string for criteria as a Variable not a Value? jason potter (03/23/04)
- showing columns and a column's sum aa (03/23/04)
- Adding two fields together Graham (03/23/04)
- passing a parameter to LIKE "*.....*" aa (03/23/04)
- DATE CONTROLED AUTO ENTRY Mick K (03/23/04)
- related ranking prob..... ana (03/23/04)
- Action will reset the current code in break mode - bug? Nekdo Od Nekje (03/23/04)
- Re: Action will reset the current code in break mode - bug? John Viescas (03/23/04)
- Re: Action will reset the current code in break mode - bug? Nekdo Od Nekje (03/24/04)
- Re: Action will reset the current code in break mode - bug? John Viescas (03/24/04)
- Re: Action will reset the current code in break mode - bug? Nekdo Od Nekje (03/24/04)
- Re: Action will reset the current code in break mode - bug? Michel Walsh (03/24/04)
- Re: Action will reset the current code in break mode - bug? Nekdo Od Nekje (03/25/04)
- Re: Action will reset the current code in break mode - bug? John Viescas (03/26/04)
- Re: Action will reset the current code in break mode - bug? Joan Wild (03/24/04)
- Re: Action will reset the current code in break mode - bug? Nekdo Od Nekje (03/24/04)
- Re: Action will reset the current code in break mode - bug? Nekdo Od Nekje (03/24/04)
- Re: Action will reset the current code in break mode - bug? John Viescas (03/23/04)
- Using NZ function & Allow Zero Length Aaron (03/23/04)
- parameter query mary (03/23/04)
- Lookup in a query??? Sad (03/23/04)
- Max Date? need help (03/23/04)
- "data type mismatch in criteria expression" marcus. (03/23/04)
- Export query result to .xls file Clementius (03/23/04)
- Beginner here ... Rob (03/23/04)
- AutoNumber in Query MEG (03/23/04)
- Subquery problem Alex (03/23/04)
- Using calculations in ACCESS Diana (03/23/04)
- create an accumulated field Frank Dulk (03/23/04)
- Sum of more then 80 values in one record Falck (03/23/04)
- URGENT! anonymous_at_discussions.microsoft.com (03/23/04)
- Using value from Combo box in query Pharoah (03/23/04)
- using LIKE JSP (03/23/04)
- Query w/ User Input Chris S. (03/22/04)
- Paged query James (03/22/04)
- multiselect listbox value mike (03/22/04)
- Calculated query from a calculated query Culbert (03/22/04)
- forat to Days, Hours and Minutes Russ (03/22/04)
- Help please Anonymous (03/22/04)
- conditons for queries nicole (03/22/04)
- query question Wei (03/22/04)
- weird problem Daniel Brown (03/22/04)
- Update query Lori (03/22/04)
- Help with report query. Karen (03/22/04)
- Urgent Help Required Vasant (03/22/04)
- Delete query problem... Fred (03/22/04)
- Update two fields in a Query Steve s. (03/22/04)
- Rounding problem Perico (03/22/04)
- Representing related records in a single row. Rajesh B. Patel (03/22/04)
- need to know who if there are no records martin (03/22/04)
- Type mismatch error in SQL expression... Fred (03/22/04)
- Duplicate Value Chris (03/22/04)
- How do I extract a return value from a pass-through Query using code? Dick Marcum (03/22/04)
- Currency and Number data type Mary Ann (03/22/04)
- Number of digits displayed George Schneider (03/22/04)
- error message "not enough space on temporary disk" Randal (03/22/04)
- Join two table with one to many relation Shailesh Patel (03/22/04)
- Querry result to form field? Jason Rhymes (03/22/04)
- Make Table Behavior Bob barnes (03/22/04)
- Using IN statement in Query Criteria Field mike (03/22/04)
- How to split the columns anonymous_at_discussions.microsoft.com (03/22/04)
- Top Values View- Please Help Tom (03/22/04)
- Sorting in an Access Query Nick (03/22/04)
- Convert data type in query Juana (03/22/04)
- relationships Giles_at_tcturt.co.uk (03/22/04)
- Query for an Invoice Report Douglas (03/22/04)
- how to show an entire date span Jenny (03/22/04)
- Query Running TOO SLOOOOW! Fred (03/22/04)
- Query for importing data from Excel Mike (03/22/04)
- looking for samples on how functions are used panicked (03/22/04)
- looking for samples on how functions are used panicked (03/22/04)
- Query more than 1 table? Fred (03/22/04)
- reporting revisits from a query Telsys (03/22/04)
- Repeating Parameters Bryan (03/22/04)
- table analyzer BSO (03/21/04)
- Query using crosstab data Chris (03/21/04)
- "insert into" query Guldo K (03/21/04)
- Date Format tobai (03/21/04)
- Stripping Out Carriage Returns Gina (03/21/04)
- Limit query output Harmannus (03/21/04)
- dates Bert (03/21/04)
- Re: dates Douglas J. Steele (03/21/04)
- Re: dates Bert (03/23/04)
- Re: dates John Spencer (MVP) (03/24/04)
- Re: dates Bert (03/24/04)
- Re: dates John Spencer (MVP) (03/25/04)
- Re: dates bert (03/25/04)
- Re: dates Bert (03/25/04)
- Re: dates John Spencer (MVP) (03/26/04)
- Re: dates John Spencer (MVP) (03/26/04)
- Re: dates Tom Ellison (03/26/04)
- Re: dates Bert (03/26/04)
- Re: dates Tom Ellison (03/26/04)
- Re: dates John Spencer (MVP) (03/28/04)
- Re: dates Bert (03/23/04)
- Re: dates Douglas J. Steele (03/21/04)
- Round as calculator Dennis (03/21/04)
- Re: Round as calculator JulieD (03/21/04)
- Re: Round as calculator Steve Schapel (03/21/04)
- Re: Round as calculator Dennis (03/21/04)
- Re: Round as calculator John Viescas (03/21/04)
- Re: Round as calculator Dennis (03/22/04)
- Re: Round as calculator John Viescas (03/22/04)
- Re: Round as calculator Dennis (03/23/04)
- Re: Round as calculator John Viescas (03/23/04)
- Re: Round as calculator Dennis (03/23/04)
- Re: Round as calculator John Vinson (03/23/04)
- Re: Round as calculator Dennis (03/21/04)
- Re: Round as calculator John Viescas (03/21/04)
- Re: Round as calculator John Spencer (MVP) (03/21/04)
- Break Excel into Header/Footer Maureen (03/21/04)
- Re: Break Excel into Header/Footer Tom Ellison (03/21/04)
- Re: Break Excel into Header/Footer Maureen (03/21/04)
- Re: Break Excel into Header/Footer Tom Ellison (03/22/04)
- Re: Break Excel into Header/Footer Maureen (03/23/04)
- Re: Break Excel into Header/Footer Tom Ellison (03/23/04)
- Re: Break Excel into Header/Footer Maureen (03/23/04)
- Re: Break Excel into Header/Footer Tom Ellison (03/23/04)
- Re: Break Excel into Header/Footer Maureen (03/23/04)
- Re: Break Excel into Header/Footer Tom Ellison (03/23/04)
- Re: Break Excel into Header/Footer Maureen (03/24/04)
- Re: Break Excel into Header/Footer Tom Ellison (03/24/04)
- Re: Break Excel into Header/Footer Maureen (03/24/04)
- Re: Break Excel into Header/Footer Tom Ellison (03/24/04)
- Re: Break Excel into Header/Footer Maureen (03/24/04)
- Re: Break Excel into Header/Footer Tom Ellison (03/24/04)
- Re: Break Excel into Header/Footer Maureen (03/25/04)
- Re: Break Excel into Header/Footer Tom Ellison (03/25/04)
- Re: Break Excel into Header/Footer Maureen (03/21/04)
- Re: Break Excel into Header/Footer Tom Ellison (03/21/04)
- Updating Field to a new format Bob (03/21/04)
- Crosstab counts aggregated by day ranges Jody (03/20/04)
- Re: Crosstab counts aggregated by day ranges John Viescas (03/21/04)
- Re: Crosstab counts aggregated by day ranges Jody (03/21/04)
- Re: Crosstab counts aggregated by day ranges John Viescas (03/21/04)
- Re: Crosstab counts aggregated by day ranges Jody (03/21/04)
- Re: Crosstab counts aggregated by day ranges John Viescas (03/21/04)
- Re: Crosstab counts aggregated by day ranges Jody (03/21/04)
- Re: Crosstab counts aggregated by day ranges John Viescas (03/21/04)
- Re: Crosstab counts aggregated by day ranges Jody (03/21/04)
- Re: Crosstab counts aggregated by day ranges John Viescas (03/21/04)
- date problem Brad Onuch (03/20/04)
- listings (records) in query John Wood (03/20/04)
- Proper syntax for DLookup criteria George (03/20/04)
- Help! Have I lost my query? Stacy (03/20/04)
- Query for importing data from Excel Mike (03/20/04)
- Update error. prior_121 (03/20/04)
- How do I 'add' results produced by the 'greatest' macro? Eric (03/20/04)
- Possible to Get prior records? sara (03/20/04)
- StatusID's on 1 line? Harmannus (03/19/04)
- Transform Query Mike Klein (03/19/04)
- TOP doesn't work with ORDER BY correctly, please help James (03/19/04)
- EXPRESSION BUILDING MAUREEN (03/19/04)
- Dropdown list prompt running query George Wilson (03/19/04)
- User input into a query Jon R. Johansen (03/19/04)
- summation of deliveries Rawley (03/19/04)
- Trying to glean log information Sean McGilloway (03/19/04)
- Outer Joins msquery vs access John Beecroft (03/19/04)
- Dates Tom (03/19/04)
- Is a query with a field subquery updatable? Winnetou (03/19/04)
- Re: Is a query with a field subquery updatable? John Viescas (03/19/04)
- Re: Is a query with a field subquery updatable? Winnetou (03/20/04)
- Re: Is a query with a field subquery updatable? John Viescas (03/20/04)
- Re: Is a query with a field subquery updatable? Winnetou (03/20/04)
- Re: Is a query with a field subquery updatable? John Viescas (03/21/04)
- Re: Is a query with a field subquery updatable? Ken Snell (03/21/04)
- Re: Is a query with a field subquery updatable? Ken Snell (03/21/04)
- Re: Is a query with a field subquery updatable? Ken Snell (03/21/04)
- Re: Is a query with a field subquery updatable? Winnetou (03/20/04)
- Re: Is a query with a field subquery updatable? John Viescas (03/19/04)
- XQuery capabilities in Access Mike C. (03/19/04)
- Dcount Records Jean (03/19/04)
- Update Query DEI (03/19/04)
- Value of an Query PARAM in VBA Fred (03/19/04)
- Excluding multiple criteria in a field fred w (03/19/04)
- Counter in a Query Dale Brown (03/19/04)
- Overlapping Time Intervals sj (03/19/04)
- Access 2003 delete query Cassie (03/19/04)
- Get column names from Access crosstab query via ADO? Michael Edwards (03/19/04)
- query with date restrictions Rawley (03/19/04)
- shuffle answers RS (03/19/04)
- Delete a Parent record if NO CHILD is found ? YM (03/19/04)
- Comparing similar text fields? Brian Cleary (03/19/04)
- calculate age on specific date Ezekiël (03/19/04)
- Mass query execution Anthony Viscomi (03/19/04)
- Creating an Indexed Field in a Make Table query Michael D. McGill (03/19/04)
- new access need helps with run sum query anonymous (03/19/04)
- running sum in query anonymous_at_discussions.microsoft.com (03/19/04)
- run sum new access user (03/19/04)
- Uneditable Query Karlos (03/19/04)
- DELETE query - Could Not Delete From Specified Tables Aaron (03/19/04)
- Select the last memo Tarek (03/19/04)
- query help anonymous_at_discussions.microsoft.com (03/19/04)
- Running Sum Total in Query question Winston Abernathy (03/19/04)
- (+) and @variable in SQL query? Seeker (03/19/04)
- Database Queries Using DATE Nathan Sokalski (03/19/04)
- qry help requested Bri (03/19/04)
- Queries in a Listbox SeRene (03/19/04)
- Mail Merge from a Query where it looks for values in a form. Craig (03/19/04)
- Append query that parses data Grace (03/19/04)
- Combining crosstab Queries Gregstock (03/18/04)
- microsoft jet sql reference... where is it?? andrea (03/18/04)
- Adding a carriage return in a query ANDY PHILLEY (03/18/04)
- Re: sql command syntax rocco (03/18/04)
- Query skips input for Where clause if second table or query added or if prompt contains blanks in the prompt string Hunter (03/18/04)
- "Bottom" SQL Bob Barnes (03/18/04)
- Switch() Hank from Oregon (03/18/04)
- union query to limit dates sue (03/18/04)
- "Or" option using INSTR() Function? Lou (03/18/04)
- Need Quarter Report Linda (03/18/04)
- Updating table1 with table2 Ellen (03/18/04)
- minute giorgio (03/18/04)
- Query that also includes records with NULL values Chuck (03/18/04)
- SQL question shaggles (03/18/04)
- Validation Rule Question Dermot Hayes (03/18/04)
- Crosstab query? Hanksor (03/18/04)
- Function and AS Chuck (03/18/04)
- I Need a Chart Expert Alex (03/18/04)
- Updating calculated fields RedForeman ©® (03/18/04)
- query with null values MSD (03/18/04)
- Inner join Warrio (03/18/04)
- Using query for mail merge dan willars (03/18/04)
- Adding a new row Yung (03/18/04)
- How To Open File Jacky Ooi (03/18/04)
- dBase III export from Query wolverine_rulez (03/18/04)
- dBase III export from Query wolverine_rulez (03/18/04)
- dBase III export from Query wolverine_rulez (03/18/04)
- dBase III export from Query wolverine_rulez (03/18/04)
- Modify table with one to many to table with one to one Murray (03/18/04)
- Show If Alex (03/18/04)
- Parsing data Lori (03/18/04)
- Lookup a definition/field in a query or a report Mark Corigliano (03/18/04)
- iif statement not working bigturnip (03/18/04)
- iif statement not working bigturnip (03/18/04)
- iif statement not working bigturnip (03/18/04)
- iif statement not working bigturnip (03/18/04)
- % of Total Edgar (03/18/04)
- Send an email based on a query... Jacqueline (03/18/04)
- Cummulative Function Daniel P (03/18/04)
- HELP! Access Subsheet Problems Shaundra (03/18/04)
- Queries filter? Hjettis (03/18/04)
- Create query Derick (03/18/04)
- Q: Probably simple but.. Jim (03/18/04)
- Bad crash on non-SQL-valid query andrew.lyagusski (03/18/04)
- Grouping Within A Query Xcelsoft (03/18/04)
- Quarterly Reports TRB_NV (03/18/04)
- Alter Table trouble luca (03/18/04)
- Page Totals in Report Dennis (03/18/04)
- Splitting Full Names into two fields Kevin O (03/18/04)
- calculating age in a query Buell (03/18/04)
- CrossTab Query Trey (03/18/04)
- Stumped by query results Richardson (03/18/04)
- SQL Date/Time Question Clive Minnican (03/17/04)
- Need to populate a field in a record based on criteria Robert (03/17/04)
- Prevent Deleting Records ChuckL (03/17/04)
- SQL - UPDATE query Derek Wittman (03/17/04)
- Formatting of Query Results Roger (03/17/04)
- Dumb but Urgent Question about Most Recent Date Susy (03/17/04)
- Simple query not working ctdak (03/17/04)
- Join multiple columns ? Don (03/17/04)
- Nested IIf statements and size limitations Baldy (03/17/04)
- INSERT...INTO Nico (03/17/04)
- Rounding in Pivot Table View Jenny (03/17/04)
- update query Dsikirica (03/17/04)
- Syntax error in FROM clause antonette (03/17/04)
- Date Range conversions Bryan (03/17/04)
- updating new field fatuheeva (03/17/04)
- Query with no results Don (03/17/04)
- Concatenate two fields into one Lori (03/17/04)
- Selecting records with most recent date... Jason Lambertus (03/17/04)
- Create count query mktrebesch (03/17/04)
- list the updates enteries sirron (03/17/04)
- I appreciate the help William Gates (03/17/04)
- displaying records between tables when one table doesn't have a corresponding... dan (03/17/04)
- Non updatable recordset help Matt Williamson (03/17/04)
- Access subsheet issues... Shaundra (03/17/04)
- Aggregate problem MrBitsy (03/17/04)
- You People Are Awesome William Gates (03/17/04)
- Formating of query George Schneider (03/17/04)
- inserting a default value Daniel P (03/17/04)
- SQL Subquery Mike Klein (03/17/04)
- crosstab Date parameter JT (03/17/04)
- How do I do this query? William Gates (03/17/04)
- Totals Query Lr (03/17/04)
- Expression handling Daniel P (03/17/04)
- Displaying different fields based on condition Djoezz (03/17/04)
- Search a word in whole database Nik (03/17/04)
- Smart Deleting Dom (03/17/04)
- Making a query Peter (03/17/04)
- Dynamic field in a query Ricardo (03/17/04)
- ignore Overflow error Greg Nelson (03/17/04)
- Overflow error Greg Nelson (03/17/04)
- Dynamic date in my query Fred (03/17/04)
- How to select values in a column n put it in new column Cindy (03/17/04)
- Totals Query? James (03/17/04)
- Re: Totals Query? John Viescas (03/17/04)
- Re: Totals Query? James (03/17/04)
- Re: Totals Query?? James (03/17/04)
- Re: Totals Query? John Viescas (03/17/04)
- Re: Totals Query? James (03/17/04)
- Re: Totals Query? John Viescas (03/17/04)
- Re: Totals Query? james (03/17/04)
- Re: Totals Query? John Viescas (03/17/04)
- Re: Totals Query? James (03/17/04)
- Re: Totals Query? John Viescas (03/18/04)
- Re: Totals Query? Duane Hookom (03/18/04)
- Re: Totals Query? James (03/18/04)
- Re: Totals Query? John Viescas (03/18/04)
- Re: Totals Query? James (03/18/04)
- Re: Totals Query? John Viescas (03/18/04)
- Re: Totals Query? James (03/19/04)
- Re: Totals Query? John Viescas (03/19/04)
- Re: Totals Query? James (03/19/04)
- Re: Totals Query? John Viescas (03/19/04)
- Re: Totals Query? James (03/22/04)
- Re: Totals Query? John Viescas (03/22/04)
- Re: Totals Query? Duane Hookom (03/19/04)
- Re: Totals Query? James (03/19/04)
- Re: Totals Query? James (03/18/04)
- Re: Totals Query? James (03/17/04)
- Re: Totals Query? John Viescas (03/17/04)
- Separating Addresses Mike DeNuccio (03/17/04)
- Querying Dates Serene (03/17/04)
- search on anniversary date Rod (03/17/04)
- Automated Field entry based on another field Brendan Mather (03/17/04)
- update query and phone/fax format marilyn (03/17/04)
- Parsing Memo field Laurie (03/16/04)
- sum of groups dan (03/16/04)
- Delete query but want to keep 2 fields Michelle.Watson_at_cls.ab.ca (03/16/04)
- Group Records by Cumulative Value JNew (03/16/04)
- Input Parameter/Data Type conflict Boyd G (03/16/04)
- Format and Format$ Functions Not Recognized E. L. Wimett (03/16/04)
- SORT QUESTION Bert (03/16/04)
- RE: SORT QUESTION Jim Richards (03/16/04)
- Re: SORT QUESTION Chris2 (03/17/04)
- Re: SORT QUESTION John Vinson (03/22/04)
- Re: SORT QUESTION Bert (03/23/04)
- Re: SORT QUESTION John Vinson (03/23/04)
- Re: SORT QUESTION Bert (03/24/04)
- Re: SORT QUESTION Jim Richards (03/24/04)
- Re: SORT QUESTION John Vinson (03/24/04)
- Re: SORT QUESTION Bert (03/24/04)
- Re: SORT QUESTION John Vinson (03/25/04)
- Re: SORT QUESTION Bert (03/26/04)
- Re: SORT QUESTION John Vinson (03/26/04)
- Re: SORT QUESTION Jim Richards (03/26/04)
- Re: SORT QUESTION Bert (03/28/04)
- Re: SORT QUESTION Bert (03/23/04)
- Query sometimes returns incomplete results TK (03/16/04)
- SQL If statement Brendan MAther (03/16/04)
- criteria anonymous_at_discussions.microsoft.com (03/16/04)
- Time series query, WSJevons (03/16/04)
- Concatenate rows Persh (03/16/04)
- Find near duplicates stuart (03/16/04)
- SQL anonymous_at_discussions.microsoft.com (03/16/04)
- Parameter query with null entry... MarkV (03/16/04)
- Combo Box George Schneider (03/16/04)
- How prevent Access messages when INSERTing ?? David (03/16/04)
- Accumulative Totals Ruffy (03/16/04)
- A query to return the range of a sum of values Jim (03/16/04)
- Field Name with Leading Zero in a Query JP (03/16/04)
- iif statement in the query Mahonek (03/16/04)
- Group by date and time with configurable blocking Kevin Laughridge (03/16/04)
- Can't view any SQL help topics in Office 2000 Pro smithb_at_scra.org (03/16/04)
- Duplicate query juan (03/16/04)
- Using Between in criteria T. (03/16/04)
- Make Table Query Dave Ruhl (03/16/04)
- Using linked Oracle tables Pam (03/16/04)
- Null Columns Dan M (03/16/04)
- Lookup queries Martyn King (03/16/04)
- merge tables Saul (03/16/04)
- Sort Error Daniel P (03/16/04)
- Hopefully simple query question Steve (03/16/04)
- duplicated values rocco (03/16/04)
- Data Read in VBA Joe Bowen (03/16/04)
- Access Query Mike Harris (03/16/04)
- group by question Daniel P (03/16/04)
- ADOX stored procedures ? David (03/16/04)
- Parameter query with a variable "IN" clause solex (03/16/04)
- Concantenate vertical information Di (03/16/04)
- Elapsed Time Jan (03/16/04)
- How do I compare 2 tables? messenger69 (03/16/04)
- Parameter Query Error George Schneider (03/16/04)
- Parameter from Form?? Peter Allanach (03/16/04)
- Turn this query into a parameter query Peter Allanach (03/16/04)
- Renumbering a duplicate ID field... Grim Reaper (03/16/04)
- "vlookup" function in access Kelesh Roopram (03/16/04)
- Help - Sorting djoezz (03/16/04)
- Barcoding - Query Single Record MBoozer (03/16/04)
- Statistics via a subreport? B Nieds (03/16/04)
- Crosstab Query error message Larry Miller (03/16/04)
- Logic problem Claire (03/16/04)
- Extracting Month From Date Anthony Viscomi (03/16/04)
- function is not available larry (03/15/04)
- Trying to get the last 12mths sum of sales Roger (03/15/04)
- Re: Trying to get the last 12mths sum of sales John Viescas (03/15/04)
- Re: Trying to get the last 12mths sum of sales anonymous_at_discussions.microsoft.com (03/16/04)
- Re: Trying to get the last 12mths sum of sales John Viescas (03/16/04)
- Re: Trying to get the last 12mths sum of sales anonymous_at_discussions.microsoft.com (03/16/04)
- Re: Trying to get the last 12mths sum of sales John Viescas (03/16/04)
- Re: Trying to get the last 12mths sum of sales Roger (03/16/04)
- Re: Trying to get the last 12mths sum of sales John Spencer (MVP) (03/16/04)
- Re: Trying to get the last 12mths sum of sales anonymous_at_discussions.microsoft.com (03/16/04)
- Re: Trying to get the last 12mths sum of sales anonymous_at_discussions.microsoft.com (03/16/04)
- Re: Trying to get the last 12mths sum of sales MGFoster (03/15/04)
- Re: Trying to get the last 12mths sum of sales Duane Hookom (03/16/04)
- Re: Trying to get the last 12mths sum of sales John Viescas (03/15/04)
- Trying to use Year as a variable Anthony Viscomi (03/15/04)
- Case sensitive replace query and international sorting Zork \(the\) Hun (03/15/04)
- Totals in Crosstab Query Ed (03/15/04)
- convert "text.00" to "text" Andrew (03/15/04)
- Comparing records in two tables Gail (03/15/04)
- INCREASING FIELD VALUE WITH A FIXED NUMBER anonymous_at_discussions.microsoft.com (03/15/04)
- SQL prompt for input Kenneth H. Young (03/15/04)
- Query question Bill Gates (03/15/04)
- Using TransterText Dale (03/15/04)
- How to extract part of a field? Howard (03/15/04)
- Why does my parameter query repeat? gsmith4000_at_yahoo.com (03/15/04)
- Run Access Queries at a specified time each week systematically Andy_Zim (03/15/04)
- Read-only? JC (03/15/04)
- sorting records Nick (03/15/04)
- How to make a message Lee (03/15/04)
- Query by Form Output Nadia (03/15/04)
- Query Jan (03/15/04)
- Update or Append Help with Criteria Lou (03/15/04)
- Crosstab problem todd_taylor_at_yorkshireamericas.com (03/15/04)
- Ascending/Descending NickH (03/15/04)
- Cross Tab Query George Schneider (03/15/04)
- Median & Mode Calculation mfoley.foley_at_fairfaxcounty.gov (03/15/04)
- Query to find the first date a customer purcahsed an item yuri greene (03/15/04)
- Query the database about itself Bo Fjeldbonde (03/15/04)
- Append Query Edgar (03/15/04)
- calculating age Nancy (03/15/04)
- Remove a space in the middle of a String? Lee (03/15/04)
- featch all data from tables into one table Himanshu Mistry (03/15/04)
- Date parameter query Eugene (03/15/04)
- Calculations in queries Flic (03/15/04)
- Refering to a query using a combo box Flic (03/15/04)
- Type NickH (03/15/04)
- More Select in a query miyomo (03/15/04)
- Current Month and Previous Month John Doe (03/15/04)
- Create a query that leaves out blank fields Kirsty (03/15/04)
- I have *** strings, how to replace them Georgee (03/15/04)
- Complex query Marina (03/15/04)
- Another cross-tab query DebbieG (03/14/04)
- Counting Records Rick (03/14/04)
- Date problem in query Teresa (03/14/04)
- Removing duplicate records based on certain criteria Joe (03/14/04)
- Selecting numbers from text string and placing in new fields Joe (03/14/04)
- Combo Box in Query Skymgr (03/14/04)
- join question Gary B (03/14/04)
- Distributing access on computers that do not have office installed thevenin (03/14/04)
- Query: Which employee had the most orders... for each day Bill (03/14/04)
- SQL calculate percent group by db:southcongress (03/14/04)
- multiple reports - same parameters sandie (03/14/04)
- FAO Steve Clarke (Query Creation) James (03/14/04)
- access problem L.Jordan (03/14/04)
- Trying to join month, day and year fields ed (03/14/04)
- Queries with date/time format prob andrea kampa (03/14/04)
- Student Project Problems Keith Williams (03/14/04)
- Can I get the answer with a query Robert Gillard (03/14/04)
- Still need technique to analyze data A. T. (03/14/04)
- IIF condition RickK (03/14/04)
- (Desperate) How to Qry on the Fields that an Image is there????? Ron Cordoba (03/14/04)
- Nested Queries BRich (03/13/04)
- ms access stored procedures again Diavolo (03/13/04)
- Re: Comparison Query? Robin Proctor (03/13/04)
- Specifying number of each records returned kk (03/13/04)
- reverse query?? Pommy_g (03/13/04)
- Selecting the most recent record Bakema (03/13/04)
- Parameter query Kam Nguyen (03/13/04)
- trying to extract a date within a text field Ed (03/13/04)
- Backwards database... C. Homey (03/12/04)
- Calculate in and out time jale (03/12/04)
- :MS Access Query / IB6 ODBC Problem Christophe.Martin (03/12/04)
- Running Total - Query Jeremy (03/12/04)
- Running Totals in a query Microsoft article 290136 jale (03/12/04)
- Select 1st value info repeated in table Vigilstar (03/12/04)
- Select 1st value info repeated in table Vigilstar (03/12/04)
- Dynamic Query Form Patrick Graham (03/12/04)
- A pretty easy one for the experts Dave (03/12/04)
- cleaning data johnduran (03/12/04)
- Help with query on a Date field for UK date style dd/mm/yyyy ??? Bill (03/12/04)
- group_concat RB (03/12/04)
- group_concat RB (03/12/04)
- Still need help with multiplying records Alan_Nicoll (03/12/04)
- IIF THEN Rick G (03/12/04)
- Parameter Query and wild card character SMatthew (03/12/04)
- Generating a numbered column in a query Chris (03/12/04)
- Need to Calculate ThruPut Time Parker (03/12/04)
- Nested If in Access Query or Report taylorew_at_umdnj.edu (03/12/04)
- crosstab converts Zeros to Nulls workaround? Tom Green (03/12/04)
- QUERY RK Anthony (03/12/04)
- Access SQL dialect documentation?" Kevin Davidson (03/12/04)
- removing characters in a text string Frustrated (03/12/04)
- Querry can't figure out JUAN (03/12/04)
- CONCATENATE Tony (03/12/04)
- Error when creating an index Jason (03/12/04)
- Selecting current school and grade Bakema (03/12/04)
- percentages in quries Phil (03/12/04)
- split field into two wohtohai (03/12/04)
- formatting a Field in an update Query April (03/12/04)
- query weirdness Sean (03/12/04)
- Date Format Problem Mikel (03/12/04)
- Date Format Problem Mikel (03/12/04)
- Help! Checkboxes Lori (03/12/04)
- Crosstab query question DebbieG (03/12/04)
- looking for the first character in a text string that is a number Tom Hanley (03/12/04)
- BOF Revisited Bob Barnes (03/12/04)
- Applicable Filter Window Empty Curious George (03/12/04)
- Queries using parameter queries, assigning values to for params in called query, is it possible? Frank M. (03/12/04)
- add a query in a texte field in a form... Fred (03/12/04)
- Avoiding Null Values using nz() won't work with Access ODBC driver Rob (03/12/04)
- Query based on continously new created tables Lina (03/12/04)
- stored procedures and dates Diavolo (03/12/04)
- RE: Query Creation James (03/12/04)
- HELP!!! skc (03/12/04)
- Select a day in a month Shaheed (03/12/04)
- Find unmatched records Beginner (03/12/04)
- Excluding records based on dates Murray (03/12/04)
- Group Ranking Problem... NorrinRadd (03/12/04)
- Small Project Need Help Rick Cass (03/12/04)
- Calculate the age Reg Vaz (03/12/04)
- Special Characters in SQL stmt Sid (03/12/04)
- Help writting simple query Rick Cass (03/12/04)
- Need technique to analyze data A. T. (03/12/04)
- Parameter from a function Bruce M (03/12/04)
- Removing message boxes associated with append queries BDP (03/11/04)
- Re: What query works in place of LEAST and GREATEST John Vinson (03/11/04)
- Concatenation BradleyJ (03/11/04)
- change start value for auto number Joeandtel (03/11/04)
- Pulling one mailing label per person Law (03/11/04)
- convert access qry to ansi 92 equivalent drew (03/11/04)
- order totals pete (03/11/04)
- Is it possible to use "all" in a paramater query Jgarcia2k3 (03/11/04)
- Is it possible to use "all" in a paramater query Jgarcia2k3 (03/11/04)
- Current date matt (03/11/04)
- Problem with IN clause Steven (03/11/04)
- query returning multiple copies of same record Rosa (03/11/04)
- Change report sort order Ed Sch (03/11/04)
- Sort Order Ed Sch (03/11/04)
- Query to remove mult. lines in table BB Sue (03/11/04)
- Select that is not in a table Vina (03/11/04)
- Duplicate Records Edgar (03/11/04)
- Invalid argument Chris (03/11/04)
- Default printin gin Access Andy K (03/11/04)
- Union data from two databases Steven (03/11/04)
- Strip field of AutoNumber Ed Kopta (03/11/04)
- Very complex crosstab query question Julia Boswell (03/11/04)
- autonumber selection in access Tony (03/11/04)
- Screen "freezes" Scott (03/11/04)
- Selecting data with CHOOSE Tor Inge Rislaa (03/11/04)
- wildcards in query from form John k. (03/11/04)
- Crosstab ?uestion none_at_none.com (03/11/04)
- Multiple criteria through a form Shiner452 (03/11/04)
- Multiple criteria through a form Shiner452 (03/11/04)
- Move records between linked tables mhoac (03/11/04)
- Multiple Criteria Query using a form Nick (03/11/04)
- Re: Multiple Criteria Query using a form JulieD (03/11/04)
- Re: Multiple Criteria Query using a form Nick (03/11/04)
- Re: Multiple Criteria Query using a form JulieD (03/11/04)
- Re: Multiple Criteria Query using a form Nick (03/12/04)
- Re: Multiple Criteria Query using a form JulieD (03/12/04)
- Re: Multiple Criteria Query using a form anonymous_at_discussions.microsoft.com (03/15/04)
- Re: Multiple Criteria Query using a form JulieD (03/15/04)
- Re: Multiple Criteria Query using a form Nick (03/11/04)
- Re: Multiple Criteria Query using a form JulieD (03/11/04)
- Showing properties of a QueryDef Ian Millward (03/11/04)
- Linked Table Layout George Schneider (03/11/04)
- Monthly Report George Schneider (03/11/04)
- How to add a remark in access query Tom (03/11/04)
- Caculate Text JT (03/11/04)
- unique record based on date query mark (03/11/04)
- Creation Of A Query James (03/11/04)
- Icon Tom Sims (03/11/04)
- Query result is wrong?! Cosmin (03/11/04)
- Access Query - Case Sensitive Anthony (03/11/04)
- Adding multiple records linked by a primary key Lee Jones (03/11/04)
- Simple query Robert Chapman (03/11/04)
- Problem with Aggregating functions in update queries Frank M. (03/11/04)
- Quote Marks ( AGHHH!) APH (03/11/04)
- Blank Forms James W. (03/11/04)
- Test for and group consecutive numbered records John (03/11/04)
- Query is too complex (run-time error) Sotiris (03/11/04)
- Partial Text String Manipulation Gdub (03/11/04)
- Counting Hal Pratt (03/11/04)
- Criteria RickK (03/11/04)
- Searching for partial records Roger Lante (03/11/04)
- Count or Sum consecutives values hectorleo_at_yahoo.com (03/10/04)
- Count unique values in a field Jim (03/10/04)
- Nested Queries with a Parameter WonderingWhy (03/10/04)
- Need parameter query results to populate form and subform fields dlel (03/10/04)
- a little confused mate (03/10/04)
- Date vs DateTime selection in Query eacollie (03/10/04)
- Multiplying Records Alan Nicoll (03/10/04)
- Multiplying Records Alan Nicoll (03/10/04)
- Multiplying Records anonymous_at_discussions.microsoft.com (03/10/04)
- Re: Multiplying Records John Vinson (03/11/04)
- Re: Multiplying Records anonymous_at_discussions.microsoft.com (03/11/04)
- Re: Multiplying Records anonymous_at_discussions.microsoft.com (03/11/04)
- Re: Multiplying Records John Vinson (03/11/04)
- Re: Multiplying Records anonymous_at_discussions.microsoft.com (03/11/04)
- Re: Multiplying Records anonymous_at_discussions.microsoft.com (03/11/04)
- Re: Multiplying Records John Vinson (03/11/04)
- Re: Multiplying Records anonymous_at_discussions.microsoft.com (03/11/04)
- Re: Multiplying Records John Vinson (03/11/04)
- Re: Multiplying Records anonymous_at_discussions.microsoft.com (03/11/04)
- Re: Multiplying Records John Vinson (03/13/04)
- Multiplying Records anonymous_at_discussions.microsoft.com (03/10/04)
- Multiplying Records Alan Nicoll (03/10/04)
- Need Criteria syntax for query "run" by a Form Paul D. Simon (03/10/04)
- Parameter query doesn't work with my format dlel (03/10/04)
- Most recent entry for each item finster26 (03/10/04)
- lookup query question Lanee (03/10/04)
- change search criteria in a query geepeetee (03/10/04)
- Formatting a query calculated field Kass (03/10/04)
- Counting # of Rows by Age SkyMgr (03/10/04)
- list columns Tony (03/10/04)
- Form Query Ben (03/10/04)
- Copy Data Definition Query to another database Lesley Regan (03/10/04)
- Populating a report from the results of a query run by a form Mountainman (03/10/04)
- Populating a report from the results of a query run by a form Mountainman (03/10/04)
- Populating a report from the results of a query run by a form Mountainman (03/10/04)
- Populating a report from the results of a query run by a form Mountainman (03/10/04)
- Populating a report from the results of a query run by a form Mountainman (03/10/04)
- Question about server filter Jonathan Blitz (03/10/04)
- SQL call to VBA, named or omitted parameters syntax? Larry Brown (03/10/04)
- Crosstab Query JT (03/10/04)
- multiple criteria Shiner452 (03/10/04)
- multiple criteria Shiner452 (03/10/04)
- multiple criteria Shiner452 (03/10/04)
- multiple criteria Shiner452 (03/10/04)
- multiple criteria Shiner452 (03/10/04)
- IIF function error JJ (03/10/04)
- SQL Syntax Help Edward (03/10/04)
- Between 2 Dates Query julianp (03/10/04)
- Between 2 Dates Query julianp (03/10/04)
- Between 2 Dates Query julianp (03/10/04)
- Between 2 Dates Query julianp (03/10/04)
- Between 2 Dates Query julianp (03/10/04)
- Null value for query criteria. Terry (03/10/04)
- Append Query jenni (03/10/04)
- sort union query tim johnson (03/10/04)
- Evaluating the data in SELECT statement Tor Inge Rislaa (03/10/04)
- IIF statement problem Harris (03/10/04)
- Search Query Ben Williams (03/10/04)
- Need some query design help.... T. (03/10/04)
- db size question ben (03/10/04)
- Help with a Max Query Jay (03/10/04)
- Getting a cummulative total from a one-to-many Lee Jones (03/10/04)
- Append Query to Split Table jenni (03/10/04)
- Extract numeric values from string jp (03/10/04)
- Split Function in Query Charles D Clayton Jr (03/10/04)
- Append query in code Becky (03/10/04)
- Displaying Latest Date Only Laurie (03/10/04)
- Dcount Heather (03/10/04)
- Parameters using 'Between Date 1 & Date 2' - Need to use 'Like' too! Kahuna (03/10/04)
- Re: Show check box missing Robert 53 (03/10/04)
- Zero value in query hermie (03/10/04)
- SUM(TIME FIELD) Fred (03/10/04)
- Date Splitting for Other calculations Roger (03/10/04)
- Changing the datasheet View on Query James (03/10/04)
- Overflow error from select query Barry (03/10/04)
- Date & Time Calculations in Queries Brian (03/10/04)
- Date parameter Eugene (03/10/04)
- Vanishing Posts Chris2 (03/10/04)
- Auto input Viv (03/10/04)
- Finding matching records SeRene (03/10/04)
- Re: Finding matching records Chris2 (03/10/04)
- Re: Finding matching records Chris2 (03/10/04)
- Re: Finding matching records fofa (03/10/04)
- Re: Finding matching records fofa (03/10/04)
- Re: Finding matching records fofa (03/10/04)
- Re: Finding matching records fofa (03/10/04)
- Re: Finding matching records fofa (03/10/04)
- Display Last Record Sahil (03/10/04)
- Counting the number of rows by month SkyMgr (03/10/04)
- Counting records Peter (03/10/04)
- Counting: Query by Scale an Project. Jazzman Dazzman (03/10/04)
- Time Required to run Create Table Query eacollie (03/09/04)
- Query by Scale and Project Jazzman Dazzman (03/09/04)
- ISError JJ (03/09/04)
- How to concatenate several entries to same table Ann (03/09/04)
- Querying Multple Tables in Access with different fields Peter Knight (03/09/04)
- calculated fields sophie (03/09/04)
- Query & calculated field Steve (03/09/04)
- Update Query Ross (03/09/04)
- [chat]to John W. Vinson meisaka (03/09/04)
- Q: multiple inserts in Access query David Boyer (03/09/04)
- Query criteria from open form or if field is null Steve (03/09/04)
- Re: Access function Mark R (03/09/04)
- Create query to return data by week for graph Mike Collard (03/09/04)
- Referencing a Query in Excel Ryan Huth (03/09/04)
- Date Funtions Ryan Huth (03/09/04)
- Parameter Query Issue Nick M (03/09/04)
- Logic Question Zane (03/09/04)
- Count in Query Alex (03/09/04)
- Drop down box in a Parameter Query Frank (03/09/04)
- Join changing mysteriously Grace (03/09/04)
- How to report combined lookup fields as text? Eric (03/09/04)
- Networkdays Function in Access? Lauren (03/09/04)
- Copy a field to another - same table Darren (03/09/04)
- Ask for weekdays only Beth (03/09/04)
- multiple tables in one query Carrie (03/09/04)
- Inserting null values into access datetime field JC (03/09/04)
- SQL query Jonathan (03/09/04)
- Sorting queries Lee (03/09/04)
- Using input parameter query for creating charts Michelle (03/09/04)
- Manual Entry of Criteria Dan (03/09/04)
- Looking back several days fred w (03/09/04)
- Help with searching for a substring Jonathan (03/09/04)
- converting date format from dd-mm-yyyy to yyyy-mm-dd Paul (03/09/04)
- random help paw (03/09/04)
- Can I use a Public Variable as Criteria in QueryDesign View? WSF (03/09/04)
- text automatically changes Ginger (03/09/04)
- Choose Fields from a FORM (table from combo) for excel export doran_doran (03/09/04)
- Choose Fields from a FORM (table from combo) for excel export doran_doran (03/09/04)
- Lookup to unrelated table Peter Marshall (03/09/04)
- Query Help Alex (03/09/04)
- How to code query with text column Sun Jr. (03/09/04)
- Operators Hy (03/09/04)
- Null Values in a Make Table Qry Anthony Viscomi (03/09/04)
- QueryProblem Tony (03/09/04)
- Filtering Selections SeanInternet (03/09/04)
- Filtering Selections SeanInternet (03/09/04)
- SELECT * INTO doesn't work Ganesh Nayak (03/09/04)
- SELECT * INTO Doesn't work Ganesh Nayak (03/09/04)
- Need help with Criteria for Queries Pls Matt (03/08/04)
- Query Returns No Results, I need to see a 0 Lisa Schwaegerl (03/08/04)
- Convert ss# text to number rayjr (03/08/04)
- Text file format conversion JimmyJ (03/08/04)
- Get rid of auto message when about to update query Emily V (03/08/04)
- Unique Record rayjr (03/08/04)
- CLEAN expression for Access to remove nonprinting characters? Rhea (03/08/04)
- Append Mailing Info to records in a table?? Mimi (03/08/04)
- Finding Missing data John Nelson (03/08/04)
- Help with DateDiff and Count Expression Dave (03/08/04)
- display sequential list of numbers Brian Kaplan (03/08/04)
- Query Results - Data Type Discrepancy Carol (03/08/04)
- deleting only certain records billz (03/08/04)
- Adding a calculated column to a query Chris (03/08/04)
- Queries Martin (03/08/04)
- Query against - ODBC Connect Oracle Table Ross (03/08/04)
- comparing similar tables rayjr (03/08/04)
- Unmatched Query Wizard kim (03/08/04)
- Access 2002 Data Validation Rules/Text Help. Dermot Hayes (03/08/04)
- BOF ?? Bob Barnes (03/08/04)
- 100 records x10records query J. Shrimps Jr. (03/08/04)
- Last 8 Weeks.... Sylvain (03/08/04)
- DATEDIFF function Wayne (03/08/04)
- Current Month Al V (03/08/04)
- random sample JD (03/08/04)
- crosstab query total column D Vera (03/08/04)
- Can I use an Or statement in five fields? ab (03/08/04)
- Multiselection in List box.. I need a little "push" D Vera (03/08/04)
- Q. I need to base a query on 2 different fields. Jim Jones (03/08/04)
- Query for NAMES first/last SDIrby (03/08/04)
- Query for NAMES first/last SDIrby (03/08/04)
- Saving an edited query Stan (03/08/04)
- split records Pommy_g (03/08/04)
- Networkdays anonymous_at_discussions.microsoft.com (03/08/04)
- Filter Weekdays and Intervals Sylvain (03/08/04)
- How to get the list of ACCESS tables ? christine.dessus_at_bayercropscience.com (03/08/04)
- Custom functions in queries Brian Taylor (03/08/04)
- Changing data type in make table queries Martin (03/08/04)
- Shifts over two days L. Khaiki (03/08/04)
- Easy question david (03/08/04)
- Searching by month from more than one table Flic (03/08/04)
- Between Date()-#07:00:00# And Date()+#17:00:00# anonymous_at_discussions.microsoft.com (03/08/04)
- Formula Debbie (03/08/04)
- Sum Query sarah (03/08/04)
- access anonymous_at_discussions.microsoft.com (03/08/04)
- Updateting Tables From Previous Database IC_Clearly (03/08/04)
- Can somebody please help me? Melody (03/08/04)
- Weird Behavior of UNION Herbert Chan (03/08/04)
- Syntax problem - can someone help me please APH (03/08/04)
- Form filter Jeroen Verdrengh (03/08/04)
- query based on text box value eb1mom (03/08/04)
- Subtract minutes from times Lee Jones (03/08/04)
- Changing the Datasheet View of a Query James (03/08/04)
- Query problem... vispute pramod (03/08/04)
- current date minus a day! Mark (03/08/04)
- outside joins (many-to-many) marcus (03/08/04)
- The date of the start of the financial year Lisa (03/08/04)
- Complicated...I think Angi (03/08/04)
- Birthday Lists in MS Access Paul (03/08/04)
- Parameter Queries - Add a lookup Rhonda (03/08/04)
- Append Query question Erik (03/08/04)
- Convert() Problem Grace (03/08/04)
- AR Aging Melody (03/08/04)
- Re: Can I query where the table name will change? B Nieds (03/08/04)
- Re: Can I query where the table name will change? Tom Ellison (03/08/04)
- Re: Can I query where the table name will change? B Nieds (03/09/04)
- Re: Can I query where the table name will change? Tom Ellison (03/09/04)
- Re: Can I query where the table name will change? B Nieds (03/10/04)
- Re: Can I query where the table name will change? Tom Ellison (03/10/04)
- Re: Can I query where the table name will change? B Nieds (03/10/04)
- Re: Can I query where the table name will change? Tom Ellison (03/12/04)
- Re: Can I query where the table name will change? B Nieds (03/13/04)
- Re: Can I query where the table name will change? Tom Ellison (03/13/04)
- Re: Can I query where the table name will change? B Nieds (03/14/04)
- Re: Can I query where the table name will change? Tom Ellison (03/14/04)
- Re: Can I query where the table name will change? B Nieds (03/15/04)
- Re: Can I query where the table name will change? B Nieds (03/09/04)
- Re: Can I query where the table name will change? Tom Ellison (03/08/04)
- ACCESS 2000 and Visual Basic SakuraSakura (03/08/04)
- Query check Seeker (03/07/04)
- Delay Kevin Rickey (03/07/04)
- Random # of records based on user input CDConnelly (03/07/04)
- Updating Field tass (03/07/04)
- Flush buffer or simular in form. Espen K (03/07/04)
- applying DISTINCT to only one field aa (03/07/04)
- Advance feature of Query rena (03/07/04)
- Week of Year rena (03/07/04)
- number field JIM.H. (03/07/04)
- Creating a query column to calculate End Time & Properly format SCTVoice (03/07/04)
- Criteria for Query Bill Hartnelll (03/07/04)
- Using "replace" in update query Susan (03/06/04)
- week numbers vivian (03/06/04)
- Button to copy and paste a record anonymous_at_discussions.microsoft.com (03/06/04)
- Select a control using text manipulation Espen K (03/06/04)
- Query speed affected by sorting Randal (03/06/04)
- Calculate 6 months out René (03/06/04)
- Re: Calculate 6 months out Randal (03/06/04)
- Re: Calculate 6 months out John Spencer (MVP) (03/06/04)
- Re: Calculate 6 months out René (03/06/04)
- Re: Calculate 6 months out John Vinson (03/07/04)
- Re: Calculate 6 months out Rene (03/07/04)
- Re: Calculate 6 months out John Vinson (03/07/04)
- Re: Calculate 6 months out John Spencer (MVP) (03/07/04)
- Re: Calculate 6 months out John Vinson (03/07/04)
- Re: Calculate 6 months out René (03/09/04)
- Re: Calculate 6 months out René (03/11/04)
- Re: Calculate 6 months out John Vinson (03/11/04)
- Re: Calculate 6 months out Rene (03/11/04)
- Re: Calculate 6 months out John Vinson (03/11/04)
- Re: Calculate 6 months out René (03/11/04)
- Re: Calculate 6 months out John Vinson (03/11/04)
- Re: Calculate 6 months out Tom Ellison (03/11/04)
- Re: Calculate 6 months out John Vinson (03/11/04)
- Re: Calculate 6 months out René (03/06/04)
- Function that returns an Array with a Query Greg Kaufman (03/06/04)
- queries for deleting data kingtutt (03/06/04)
- Date -7 Criteria Stuart Evans (03/06/04)
- Use of variables in a query? ACE Connection (03/06/04)
- count instances of a name(s) Daren (03/06/04)
- Format([Hours] * -1,"Fixed") ERROR Andre Uys (03/06/04)
- union query. toby (03/06/04)
- dump fields into a memo field shank (03/06/04)
- carry value from SQL to Query David (03/05/04)
- Print only the last date Susy (03/05/04)
- How do I stop Access from asking confirmation to delete a table in a Make-Table Query? Mike Webb (03/05/04)
- Compiler Error mrsultancs_at_hotmail.com (03/05/04)
- Access Query Bob (03/05/04)
- How to select records by month by using a pop up? meisaka (03/05/04)
- Extracting an Area Code from a 10 digit numger in a query Mark (03/05/04)
- Sequential Numbering John (03/05/04)
- Unwanted Dialog Box Tom (03/05/04)
- Update query to update more than one table? Emily V (03/05/04)
- finding specific time values in where statement ed (03/05/04)
- Sort on partial field ctdak (03/05/04)
- Editing records in a query Jim (03/05/04)
- "REPLACE IN FIELD" T.Korner (03/05/04)
- Criteria- Help Please Ray (03/05/04)
- Interesting Question Zane (03/05/04)
- picking first or last row Eric Nelson (03/05/04)
- create query to select only 1 member of a household based on address Janet (03/05/04)
- Union Query failing on Order By clause Corri Atkinson (03/05/04)
- DATE() issue wwaiter (03/05/04)
- Re: Parameter for query which compares against other records in same query David Cleave (03/05/04)
- reading counting results web_time (03/05/04)
- Data Type mismath errors after months of no problems scott Wilson (03/05/04)
- Q. query for space in several fields doesn't work ( =" " ) Jim Jones (03/05/04)
- Simple Sum Calculation but I can't work it out...... Chris (03/05/04)
- Re: Simple Sum Calculation but I can't work it out...... Kevin (03/05/04)
- Simple Sum Calculation but I can't work it out...... Marcelle (03/05/04)
- Simple Sum Calculation but I can't work it out...... Kevin (03/05/04)
- Simple Sum Calculation but I can't work it out...... Anthony (03/05/04)
- complex queries harami (03/05/04)
- Comparing field values Tim (03/05/04)
- Sum Time miyomo (03/05/04)
- Cycle Through two Tables Dominic (03/05/04)
- I have one too... Kevin (03/05/04)
- Another crosstab question... 666 (03/05/04)
- Crosstab parameter help 2 (03/05/04)
- Combining different values in the same field in a query Alp Bekisoglu (03/05/04)
- Records Discrepancy SlowLearner (03/05/04)
- Rounding? Dennis (03/05/04)
- Re: Rounding? John Viescas (03/05/04)
- Re: Rounding? anonymous_at_discussions.microsoft.com (03/05/04)
- Re: Rounding? John Viescas (03/05/04)
- Re: Rounding? anonymous_at_discussions.microsoft.com (03/06/04)
- Re: Rounding? Dennis (03/06/04)
- Re: Rounding? John Viescas (03/06/04)
- Re: Rounding? Dennis (03/06/04)
- Re: Rounding? anonymous_at_discussions.microsoft.com (03/06/04)
- Re: Rounding? John Viescas (03/06/04)
- Re: Rounding? Dennis (03/07/04)
- Re: Rounding? Dennis (03/07/04)
- Re: Rounding? Dennis (03/07/04)
- Re: Rounding? John Viescas (03/07/04)
- Re: Rounding? John Viescas (03/07/04)
- Re: Rounding? anonymous_at_discussions.microsoft.com (03/05/04)
- Re: Rounding? John Viescas (03/05/04)
- a character specific query Errol Kemp (03/05/04)
- Average Problem Frank (03/05/04)
- cannot go back 6 months Joeandtel (03/04/04)
- Re: Query an external database... DIOS (03/04/04)
- Deleting records from find duplicates query Toan Chau (03/04/04)
- Builing a query from selection criteria on a Form Craig Ferrier (03/04/04)
- help with a Query Expression (Builder) jaberwocky (03/04/04)
- help with a Query Expression (Builder) jaberwocky (03/04/04)
- Week ending Friday Inventorys Tom (03/04/04)
- Please help got access query but can't get it to work on sql-server - what's the access specific part ? Kim (03/04/04)
- Top 3 values tie breaker Manuel (03/04/04)
- Sum Query Greg Ripper (03/04/04)
- Query using max Mary (03/04/04)
- tuff query djc (03/04/04)
- Trouble in writing a result from a calculation back to a field. ACE Connection (03/04/04)
- Top 5 values by grouping Jessica (03/04/04)
- Using wildcards in queries Rob NYS (03/04/04)
- Aggregate Function query Lee (03/04/04)
- INSERT INTO using WHERE?? Norm (03/04/04)
- Inventory Update Query Michael Fenton (03/04/04)
- populating combo box Kreplech (03/04/04)
- user input min/max error JOHN (03/04/04)
- Delete Query Question Keith Johnson (03/04/04)
- DCOUNT function in query? Jim Franklin (03/04/04)
- two columns into one Susan Grand (03/04/04)
- Re: start time / end time calculation Clyde (03/04/04)
- Two tables where one value is not like the other.` Tbride00 (03/04/04)
- Crosstabs and Parameters !!?? Mark Burns (03/04/04)
- Distinct Records Darrick (03/04/04)
- Printing one address label from 2 lists Clare Fell (03/04/04)
- user input min/max error JOHN (03/04/04)
- Optimize Select insert and update User (03/04/04)
- A query that returns the record counter adamc (03/04/04)
- Pad field in query MDW (03/04/04)
- Calc values from a form viewed back in a query table Cindy (03/04/04)
- Query from Form when "Not Like" Paul Simon (03/04/04)
- bar charts displaying negative values Wally (03/04/04)
- invalid argument on linking tables Thomas Apostolou (03/04/04)
- Prompt Beginner (03/04/04)
- Export / Query Problem edi (03/04/04)
- yes/no koklico (03/04/04)
- Entering a null value in a field Vincent (03/04/04)
- adding totals across JA (03/04/04)
- Multiple queries based on the same table? ZBC (03/04/04)
- Copying text portion of a field to a seperate field Steve (03/04/04)
- Ranking Within A Totals Query Alan Balthrop (03/04/04)
- queries, sort by 2nd choice viv (03/04/04)
- Formula for pulling certain data anonymous_at_discussions.microsoft.com (03/04/04)
- Comments anonymous (03/04/04)
- List Pulldown Box in Query TM (03/04/04)
- Calculating accumalative fields Anthony (03/04/04)
- Crosstab Query Mathew (03/03/04)
- User Intervention required Chris (03/03/04)
- How do I search for a name using just the first letter of the last name? Mike Webb (03/03/04)
- Access97 Sum function dropping decimals walker (03/03/04)
- New queries are saving automatically Sam Weissman (03/03/04)
- Referencing Crosstab Query Values Tony (03/03/04)
- List Boxes not linking Heather (03/03/04)
- Problems with Count query Lee (03/03/04)
- Queries blank??? Don (03/03/04)
- How can i add a counter for duplicate records in a query? Counter for Duplicate records (03/03/04)
- Count/Quantity field Pommy_g (03/03/04)
- Need help updating records...PLZ HELP ASAP Nadia (03/03/04)
- Merge to Word DSmith (03/03/04)
- Need to update/edit text within a field...HELP Nadia (03/03/04)
- Re: IN function in query tenbob (03/03/04)
- Re: "Make Query by Form" Rob (03/03/04)
- Displaying the most recent date only David (03/03/04)
- Need help using "Like" in a programmatic SQL statement Vic (03/03/04)
- Finding calculated values FROM a form to a query Cindy (03/03/04)
- A foolproof way to use dates in queries ? Alex T (03/03/04)
- conditional INSERT Andrew Sinning (03/03/04)
- How do I structure the where clause to select rows whose data contains spaces? Ken (03/03/04)
- "Undefined function 'Date' in Expression" eric (03/03/04)
- Parsing out leading Zeros Jonathan (03/03/04)
- Installation Error.... Please Help Nicole (03/03/04)
- Summarising by 1st 3 Characters sue (03/03/04)
- Using Access Forms with SQL stored procs JOE (03/03/04)
- Re: Combining Data that is not the same date Jerry (03/03/04)
- Update with incrementing values Razor (03/03/04)
- Find Unmatched Query Wizard Problem hcbph (03/03/04)
- Difficult rowsource Basil (03/03/04)
- Date Issue Qaspec (03/03/04)
- Limiting Query Results Mike Klein (03/03/04)
- Pass thru query help Joe (03/03/04)
- change data type David (03/03/04)
- layout of output Koklico (03/03/04)
- Custom Function Mike (03/03/04)
- Multiple Tables and Record Counting Paul Denham (03/03/04)
- What's wrong with this syntax please APH (03/03/04)
- Error when running qry! gr (03/03/04)
- 300 nokia games coma (03/03/04)
- Can access read values from the registry? Brandon M (03/03/04)
- Referring to an external database Brandon M (03/03/04)
- allot more help Duftopia (03/03/04)
- Datetime Parameter problem Phill (03/03/04)
- Joined on two fields Peggy (03/03/04)
- Concant a date field and a time field paul (03/03/04)
- query help Gary B (03/03/04)
- Calculating percentages in access for survey information Nathalie (03/03/04)
- Counting? Dave Q (03/03/04)
- counting Dave Q (03/03/04)
- update query help PCH (03/03/04)
- Query for foreign language D2 (03/03/04)
- adding to two tables in one query aa (03/02/04)
- Make table query Razor (03/02/04)
- Running totals in a query Chip (03/02/04)
- Displaying an Error dialog box when #Error results George Lob (03/02/04)
- Re: Is this the right way Ian Baker (03/02/04)
- Re: Ms-Access XP report problem Michel Walsh (03/02/04)
- Balance Queries HawkeyePierce (03/02/04)
- Excel DateValue Function in Access BL (03/02/04)
- I need the calendar to show 7 days forward. Frank Martin (03/02/04)
- compare records Chieko Kuroda (03/02/04)
- Date calculation help needed Lee (03/02/04)
- Date Calander for Query/Report C.R. Houk (03/02/04)
- Now() > DD HH MM query?? Peter Allanach (03/02/04)
- Wild Cards in Queries? Grog (03/02/04)
- Query Help James McDonald (03/02/04)
- Query with Function for criteria Larry (03/02/04)
- Re: Help.... Adding/ Sorting Mojo (03/02/04)
- changing blanks to null William Kossack (03/02/04)
- Recent date query smptoolie_at_discussions.microsoft.com (03/02/04)
- Impossible query? Gordon Currie (03/02/04)
- including two? SlimJim (03/02/04)
- Re: Past 12 Months ShrekUT (03/02/04)
- Making dynamic data static at a given period David Kinsley (03/02/04)
- Only show weekly dates Alex (03/02/04)
- Delete Query gr (03/02/04)
- keyword lookup system guidance needed djc (03/02/04)
- Re: keyword lookup system guidance needed John Viescas (03/02/04)
- Re: keyword lookup system guidance needed djc (03/02/04)
- Re: keyword lookup system guidance needed djc (03/04/04)
- Re: keyword lookup system guidance needed John Viescas (03/04/04)
- Re: keyword lookup system guidance needed djc (03/05/04)
- Re: keyword lookup system guidance needed djc (03/05/04)
- Re: keyword lookup system guidance needed John Viescas (03/05/04)
- Re: keyword lookup system guidance needed djc (03/05/04)
- Re: keyword lookup system guidance needed John Viescas (03/05/04)
- Re: keyword lookup system guidance needed djc (03/05/04)
- Re: keyword lookup system guidance needed John Viescas (03/02/04)
- Re: Create a table anonymous_at_discussions.microsoft.com (03/02/04)
- Error Messages Bell (03/02/04)
- Supress Spaces Bill J. (03/02/04)
- ALTER COLUMN Darren (03/02/04)
- Finding Lasts months records Jeffrey Wade (03/02/04)
- Query Problems gr (03/02/04)
- Is this Correct? AndreMello (03/02/04)
- Is this Correct? AndreMello (03/02/04)
- Display all records or from a Combo Box QC (03/02/04)
- UDF in RecordSource: How to promp for parameters? Christine (03/02/04)
- Sub count??? **Danny Johnson** (03/02/04)
- using form input query toby (03/02/04)
- Multiple queries to one table toby (03/02/04)
- how can I do a sumif array type function? marcus (03/02/04)
- Re: how can I do a sumif array type function? Tom Ellison (03/02/04)
- Re: how can I do a sumif array type function? marcus (03/02/04)
- Re: how can I do a sumif array type function? Tom Ellison (03/02/04)
- Re: how can I do a sumif array type function? marcus (03/03/04)
- Re: how can I do a sumif array type function? Tom Ellison (03/03/04)
- Re: how can I do a sumif array type function? marcus (03/03/04)
- Re: how can I do a sumif array type function? Tom Ellison (03/03/04)
- Thanks marcus (03/03/04)
- Re: how can I do a sumif array type function? marcus (03/02/04)
- Re: how can I do a sumif array type function? marcus (03/02/04)
- Re: how can I do a sumif array type function? Tom Ellison (03/02/04)
- Why sometime dup rows? Sara (03/02/04)
- Run queries made by code Ari A (03/02/04)
- Invalid password when using IN clause Francisco R (03/01/04)
- A querry would not run in server but would run in local machine mario (03/01/04)
- Updating a Paradox table jennyw (03/01/04)
- How do I add or subtract John (03/01/04)
- Do a calculation on a series of dates linked to a case Pat (03/01/04)
- Well this is infuriating...bad totals on query bugman (03/01/04)
- Appending Memo Field DBarker (03/01/04)
- Re: Appending Memo Field Tom Ellison (03/01/04)
- Re: Appending Memo Field DBarker (03/02/04)
- Re: Appending Memo Field Tom Ellison (03/02/04)
- Re: Appending Memo Field DBarker (03/02/04)
- Re: Appending Memo Field Tom Ellison (03/02/04)
- Re: Appending Memo Field DBarker (03/02/04)
- Re: Appending Memo Field Tom Ellison (03/02/04)
- Re: Appending Memo Field DBarker (03/02/04)
- Re: Appending Memo Field Tom Ellison (03/02/04)
- Re: Appending Memo Field DBarker (03/02/04)
- Re: Appending Memo Field DBarker (03/02/04)
- Re: Appending Memo Field Tom Ellison (03/01/04)
- query for field a based on contens field b Dale Craig (03/01/04)
- Group by molly (03/01/04)
- Query for Date Markus (03/01/04)
- Display All Records Greg Ripper (03/01/04)
- Simple Access SQL Query? ihatecomputers (03/01/04)
- Simple Access SQL Query? ihatecomputers (03/01/04)
- problems with multiple criteria Michael Bentfeld (03/01/04)
- UNION query returns as datatype mismatch error Daniel Saïd (03/01/04)
- Re: UNION query returns as datatype mismatch error John Vinson (03/02/04)
- Re: UNION query returns as datatype mismatch error John Viescas (03/02/04)
- Re: UNION query returns as datatype mismatch error Daniel Saïd (03/02/04)
- Re: UNION query returns as datatype mismatch error John Viescas (03/02/04)
- Re: UNION query returns as datatype mismatch error Daniel Saïd (03/02/04)
- Re: UNION query returns as datatype mismatch error John Viescas (03/02/04)
- Re: UNION query returns as datatype mismatch error Daniel Saïd (03/03/04)
- Re: UNION query returns as datatype mismatch error John Viescas (03/03/04)
- Re: UNION query returns as datatype mismatch error John Viescas (03/03/04)
- Re: UNION query returns as datatype mismatch error Daniel Saïd (03/04/04)
- Re: UNION query returns as datatype mismatch error John Viescas (03/04/04)
- Re: UNION query returns as datatype mismatch error Daniel Saïd (03/03/04)
- Re: UNION query returns as datatype mismatch error Daniel Saïd (03/02/04)
- Re: UNION query returns as datatype mismatch error Chris2 (03/02/04)
- Cannot Update Data in Query Chaplain Doug (03/01/04)
- Outer Join Issues - Please Help grrr223 (03/01/04)
- Outer Join Issues - Please Help grrr223 (03/01/04)
- How to refer to a query from VBA? Richard Black (03/01/04)
- Add result from previous record Jenn Englehardt (03/01/04)
- "Optimize for N rows" command MK (03/01/04)
- Insert carriage return in query Clyde (03/01/04)
- Need help to construct this query... Alex T (03/01/04)
- Sloooow Queries Bob (03/01/04)
- Pull letters of a text string Ezra (03/01/04)
- Re: Drop Down List in Query Gee (03/01/04)
- Delete query - Linked by CLNG won't work - But why not?! steve lord (03/01/04)
- Duplicate Values in a Query Ron (03/01/04)
- Calculating Remaining Days Simon Dowse (03/01/04)
- could not delete from specified tables Nick (03/01/04)
- Multiple queries to one table toby (03/01/04)
- Create a numeric colum in a query using a string bugman (03/01/04)
- Re: Wild Card Concatenation With User Input [MVP] S.Clark (03/01/04)
- Re: Help me please before I go insane [MVP] S.Clark (03/01/04)
- Re: Data Tyep Mismatch - Run Time Error [MVP] S.Clark (03/01/04)
- Re: Pages [MVP] S.Clark (03/01/04)
- Re: Duplicate Update Problem [MVP] S.Clark (03/01/04)
- Adding an Item to a Query Result Chaplain Doug (03/01/04)
- Export query to Excel JudyB (03/01/04)
- Missing Data bill_macdermott_at_verizon.net (03/01/04)
- simple calculation? Mimi (03/01/04)
- Adding the count total of several fields Tom (03/01/04)
- Friday inventory report Molly (03/01/04)
- one simple criteria input box - google style djc (03/01/04)
- Inefficient Query - Please HELP Ian Eldred (03/01/04)
- Re: Query expression needed to edit data Alp Bekisoglu (03/01/04)
- converting string to date dana livni (03/01/04)
- Re: Sequential Numbering Daniel P (03/01/04)
- Re: Simple Update Query Michel Walsh (03/01/04)
- Re: export table Nikos Yannacopoulos (03/01/04)
- Re: How to get data in a form from different records out of a query ? Nikos Yannacopoulos (03/01/04)
- MS Access query failing in ODBC Ash (03/01/04)
- Multiple queries to one table Duftopia (03/01/04)
- Group and Sum Friday-Sunday Orders But Not Other Days mike (03/01/04)
- Problem with Many to One Query mj (03/01/04)
- 0(Zero) in query Zab (03/01/04)
- Re: Inherited problem joining tables on more than one field. Tom Ellison (02/29/04)
- subtract from all previous records greg (02/29/04)
- Problems correcting Circular Reference! eric (02/29/04)
- Re: Iif statement again RAB (02/29/04)
- Query Truncates Field Data Tom (02/29/04)
Last message date: 03/31/04
Archived on: 03/31/04 GMT
4046 messages sorted by: [ date ]