microsoft.public.access.queries
By Thread
3163 messages sorted by: [ date ]
Starting: 04/29/04
Ending: 05/31/04
- Query DateTime Field Tausif (05/31/04)
- Re: Query DateTime Field Ken Snell (05/31/04)
- Re: Query DateTime Field Tausif (05/31/04)
- Re: Query DateTime Field Tausif (05/31/04)
- Re: Query DateTime Field Tausif (05/31/04)
- Re: Query DateTime Field Tausif (05/31/04)
- Re: Query DateTime Field Tausif (05/31/04)
- Re: Query DateTime Field John Vinson (05/31/04)
- Help! Write Selection Criteria news.insightbb.com (05/31/04)
- Expr: Left([dob],4) = omitted an operator? Jan (05/30/04)
- Obtaning results per Quarters Mary (05/30/04)
- criteria in query part of field text only MemphiDoug (05/30/04)
- criteria in query part of field text only MemphiDoug (05/30/04)
- DLookup Chris (05/30/04)
- Quering 2 IDs from a single table Paul (05/30/04)
- Format Date Tiffany (05/30/04)
- highlighting field in query or report Tony (05/30/04)
- Substracting two adjacent rows Yakimo (05/30/04)
- HELP! Hannah Jackson (05/30/04)
- Copying a column/field zirkerc (05/30/04)
- Using a query with a replaceable parameter as the source of a control Hoo (05/30/04)
- Sorting a query is bringing up a parameter request for some fields Donna (05/30/04)
- Displaying Results Sub-Query Result in Another Query Alan Balthrop (05/29/04)
- how do you work with time? Annelie (05/29/04)
- More dates issues Mike (05/29/04)
- Saving Query & Report Ady (05/29/04)
- Current Date, MTD, YTD, Last Year's MTD Gina (05/29/04)
- Expression (Checkbook) Tom (05/29/04)
- Undefined function 'Date' in expression Doug (05/29/04)
- E_FAIL 0x80004005 Oscar Thornell (05/29/04)
- qry-SalesAnalysysCollectData? Maureen (05/29/04)
- sql view charles osborne (05/29/04)
- Compare multiple fields in record Can (05/29/04)
- What is wrong with this WHERE clause ? David (05/28/04)
- current date less 28 days marion (05/28/04)
- Query with multiple fields and one form Evan McCutchen (05/28/04)
- ADO Parameter Query Tony_VBACoder (05/28/04)
- Query criteria doesnt use year input Donna Brooks (05/28/04)
- comparing multiple fields Fish (05/28/04)
- HELP with updateable query Jacqueline (05/28/04)
- Open Hyperlink Peter (05/28/04)
- Log10 function Andy (05/28/04)
- Exclude weekends Dan (05/28/04)
- Using IIF to return a zero value for a null Muraii (05/28/04)
- RWOP make table Query Gwen (05/28/04)
- Date Search Shawn (05/28/04)
- Option group selection as query criteria Tara (05/28/04)
- Need help with Append query CS (05/28/04)
- Query By Form Craig (05/28/04)
- Union Select sorting JR (05/28/04)
- Help! -Match problem Chengfu (05/28/04)
- Select vs update Query Joyce (05/28/04)
- field manipulation Steve (05/28/04)
- query to select one record using report name Nasos (05/28/04)
- comparing two tables ADAK (05/28/04)
- Date Disaster Pat P (05/28/04)
- Select Query Pago (05/28/04)
- Insert contents of Col in one table into another table Sandy (05/28/04)
- Taking the Top Three Frank (05/27/04)
- Working with Dates JeffS (05/27/04)
- Last functions in Total Row Jordan (05/27/04)
- Passing Query Parameters in Sub-Queries coder23 (05/27/04)
- max value Nicole (05/27/04)
- creating relations with sql Jonas (05/27/04)
- Return top record Bren (05/27/04)
- Absolute value of a checkbox in a query MarkD (05/27/04)
- Query in datasheet view yields different results than opening it as a recordset Jason Seaver (05/27/04)
- Query design - select fields always default to "group by" Tripp Knightly (05/27/04)
- Query help Steve (05/27/04)
- Between Dates Grant (05/27/04)
- IsLoaded Maureen (05/27/04)
- Re: "append query" issues BJMLaJolla (05/27/04)
- Format for phone number Sandy (05/27/04)
- Most Recent Date Michael Noblet (05/27/04)
- Activation on a New Computer anonymous_at_discussions.microsoft.com (05/27/04)
- Query is too complex Mike (05/27/04)
- Problem with pass-through insert query Karen (05/27/04)
- Importing Query results to Excel ChuckW (05/27/04)
- Adding Up Hours Jackie (05/27/04)
- REALTIME UPDATES BobHt (05/27/04)
- pass through parameter query into Oracle teri (05/27/04)
- Find a date in many columns and put that date in another column Sandy (05/27/04)
- Query List Doesn't Display gstdenis_at_uspis.gov (05/27/04)
- IIF Limitation JA (05/27/04)
- How to calculate a period of time AmandaP (05/27/04)
- Joining Queries: Problem Tom (05/27/04)
- CrossTab Query with Dates GNTK (05/27/04)
- Adding new record to query Roy Goldhammer (05/27/04)
- crosstab query: incorrect values Michel Peeters (05/27/04)
- Re: crosstab query: incorrect values Michel Walsh (05/27/04)
- Re: crosstab query: incorrect values Gary Walter (05/27/04)
- Re: crosstab query: incorrect values Michel Peeters (05/27/04)
- Re: crosstab query: incorrect values Michel Walsh (05/27/04)
- Re: crosstab query: incorrect values Michel Peeters (05/27/04)
- Re: crosstab query: incorrect values Michel Walsh (05/27/04)
- Re: crosstab query: incorrect values Gary Walter (05/28/04)
- Re: crosstab query: incorrect values Michel Walsh (05/28/04)
- Re: crosstab query: incorrect values Michel Peeters (05/27/04)
- SQL UPDATE with binary data Nigel Findlater (05/27/04)
- Subtract in the same field Jenna (05/27/04)
- What's wrong with this query? Craig (05/27/04)
- Text field causing trouble in query (continued) KaiRich (05/27/04)
- Newbie: Using Left in query for report? Ed (05/26/04)
- Using Several Queries in a Calculated Field Muraii (05/26/04)
- Update Query James Stephens (05/26/04)
- Filter by Form query will not populate fields Brigitte P (05/26/04)
- Count Group By Patrick (05/26/04)
- Update Query Question Edward (05/26/04)
- Parameter query question Gina (05/26/04)
- crosstab query not showing all values Michel Peeters (05/26/04)
- Can't use memo field when using unique Peter-Dave (05/26/04)
- Convert grouped records into a string mmattson (05/26/04)
- GROUP BY/ORDER BY Question BobRoyAce (05/26/04)
- Crosstab Query Help Newbie (05/26/04)
- Please help me!!! Ann (05/26/04)
- Can Access make a transaction query? Christina (05/26/04)
- need to delete the first 4 numbers of each record Jimmy (05/26/04)
- Update Query Leif (05/26/04)
- Creating a wildcard search for a form. Peter Knight (05/26/04)
- Updating 2 tables with 1 form - Access 2003 Linger1974 (05/26/04)
- Query to List Reports and their recordsource Dave F (05/26/04)
- Help with query. Must have D and have either E>=2000 OR etc. Sandy (05/26/04)
- Access query is renaming output fields - dreadfully inconvenient JonR (05/26/04)
- string Allouche Patrick (05/26/04)
- Unmatched Query anonymous_at_discussions.microsoft.com (05/26/04)
- Adding selected data (using code atached to cmd button from a form) to a table Chris (05/26/04)
- Using a custom function in a query BobRoyAce (05/26/04)
- Help!! withdrawing materials from a stock. Chris (05/26/04)
- I am getting incorrect responses to complicated Count() Query... Gary B (05/26/04)
- Re: I am getting incorrect responses to complicated Count() Query... Michel Walsh (05/26/04)
- Re: I am getting incorrect responses to complicated Count() Query... Michel Walsh (05/26/04)
- Re: I am getting incorrect responses to complicated Count() Query... Gary B (05/26/04)
- Re: I am getting incorrect responses to complicated Count() Query... Michel Walsh (05/26/04)
- Re: I am getting incorrect responses to complicated Count() Query... Gary B (05/26/04)
- Re: I am getting incorrect responses to complicated Count() Query... Michel Walsh (05/26/04)
- Re: I am getting incorrect responses to complicated Count() Query... Gary B (05/27/04)
- Re: I am getting incorrect responses to complicated Count() Query... Michel Walsh (05/27/04)
- Re: I am getting incorrect responses to complicated Count() Query... Michel Walsh (05/26/04)
- Re: I am getting incorrect responses to complicated Count() Query... Michel Walsh (05/26/04)
- Multiple Drop Down Dennis (05/26/04)
- Identity_Insert Steve Jensen (05/26/04)
- Return String from Boolean Field Dragon (05/25/04)
- Limiting a query Fay Yocum (05/25/04)
- Showing all subrows in crosstab query Ragnar Midtskogen (05/25/04)
- query field reference help -dch (05/25/04)
- Autolookup Query Ernie (05/25/04)
- Calling append query from form CS (05/25/04)
- query help Jennifer (05/25/04)
- Multiple Append Queries to One Table wpshop (05/25/04)
- three leters abbr for Day of week gal (05/25/04)
- Delete Record Based on Text Box James Stephens (05/25/04)
- Separate First Middle Last names galin (05/25/04)
- Re: Separate First Middle Last names Andrew L. (05/26/04)
- Re: Separate First Middle Last names Julie Puchalski (05/28/04)
- Re: Separate First Middle Last names Julie Puchalski (05/28/04)
- Re: Separate First Middle Last names Julie Puchalski (05/28/04)
- Re: Separate First Middle Last names Julie Puchalski (05/28/04)
- Multiple ranks per record based on different fields. Looney (05/25/04)
- Can a Design be saved to use again without re-keying it? Juls (05/25/04)
- ODBC CALL FAILED bikermike (05/25/04)
- Using IIF statement in Memo Field J Cunningham (05/25/04)
- Function recognized once; now I'm getting error message Sandy (05/25/04)
- Appending Weekly Sales to a table ChuckW (05/25/04)
- help with not so simple query v_roma (05/25/04)
- Convert data. Robert (05/25/04)
- Urgent - Problems with grouping Unique values FJP (05/25/04)
- Reminders Tara (05/25/04)
- Excel vs Acess hermie (05/25/04)
- Reports from Cross-Tab Queries Jack (05/25/04)
- rounding making result of calculations look incorrect Helen (05/25/04)
- Re: rounding making result of calculations look incorrect Wayne Morgan (05/25/04)
- Re: rounding making result of calculations look incorrect Helen (05/27/04)
- Re: rounding making result of calculations look incorrect Wayne Morgan (05/27/04)
- Re: rounding making result of calculations look incorrect Helen (05/27/04)
- Re: rounding making result of calculations look incorrect Helen (05/29/04)
- Re: rounding making result of calculations look incorrect Wayne Morgan (05/29/04)
- Re: rounding making result of calculations look incorrect Helen (05/27/04)
- Re: rounding making result of calculations look incorrect Wayne Morgan (05/25/04)
- Getting and setting information Jonas (05/25/04)
- Access 2000 command buttons JKA (05/25/04)
- can save the follwing queries Jonas (05/25/04)
- Access 2000 SP3 Issues Paul Lockwood (05/25/04)
- Count of contents in field hermie (05/25/04)
- # error in calculation hermie (05/25/04)
- Help with simple query! v_roma (05/25/04)
- Help copying an array into an ADO recordset rotor (05/25/04)
- add column Dan (05/25/04)
- Multiple records Steve (05/25/04)
- Month query / View sotiris_s (05/25/04)
- Reserved error (-3011) BobRoyAce (05/25/04)
- Find Records that ovelap John H (05/25/04)
- Text in IIf(,,) expression in query KaiRich (05/25/04)
- Better Example of Count() Query Gary B (05/25/04)
- Help to create databse GabrielG (05/25/04)
- trouble with query Gary B (05/25/04)
- Japanese query Dale Walker (05/25/04)
- Create a Report/Query for Operating Permit Michael DiCostanzo (05/25/04)
- Re: Month number output instead of month text Miquel Korah (05/24/04)
- flagging changed values Tony (05/24/04)
- Make Table Query takes long time anonymous_at_discussions.microsoft.com (05/24/04)
- Re: Update, Append, and ID field John Vinson (05/24/04)
- Query two fields into one combo box JohnLute (05/24/04)
- Count Unique Values AHopper (05/24/04)
- slow delete query Michel Peeters (05/24/04)
- several report fields from one table field Steve (05/24/04)
- Count records within a range of values Steve (05/24/04)
- Crosstab Report and query Newbie (05/24/04)
- Change size of pop-up for parameter query Rose (05/24/04)
- To: Allen Browne re: changing date format in query anonymous_at_discussions.microsoft.com (05/24/04)
- Query Quandries Frank (05/24/04)
- changing date format in a query Elisa (05/24/04)
- Crosstab Help Newbie (05/24/04)
- 'Not in' Query John (05/24/04)
- How to update a field with value from 2 calculated fields (dates)? Chris1 (05/24/04)
- Object Names contains tidle (~) Roddy (05/24/04)
- show all invoice totals Cheri (05/24/04)
- Consolidating Records EB (05/24/04)
- PARAMETER CRITERIA angie (05/24/04)
- Query question Hamoud (05/24/04)
- Urgently need help with a database file!!!!!! Shane (05/24/04)
- Display record based on current date John H (05/24/04)
- Access Modules Tausif Alam (05/24/04)
- Random Query? Jenn (05/24/04)
- Requery Combobox MJ (05/24/04)
- COMPARE THE TWO TABLES Rick (05/24/04)
- Union Query Not Working Properly JohnAFT (05/23/04)
- HOW CAN I VERIFY WHEN WITHDRAWING AN ITEM FROM A STORAGE IF IT EXISTS IN THE STORAGE? Chris (05/23/04)
- calculate time clanmccreery (05/23/04)
- Date criteria syntax Ginger (05/23/04)
- Date criteria syntax Ginger (05/24/04)
- Date criteria syntax - Still need help Ginger (05/24/04)
- Date criteria syntax - Still need help Van T. Dinh (05/24/04)
- Date criteria syntax - Still need help Ginger (05/24/04)
- Date criteria syntax - Still need help Ginger (05/24/04)
- Re: Date criteria syntax - Still need help John Vinson (05/24/04)
- Re: Date criteria syntax - Still need help Ginger (05/24/04)
- Date criteria syntax - Still need help Van T. Dinh (05/24/04)
- Date criteria syntax - Still need help Ginger (05/24/04)
- Date criteria syntax Ginger (05/24/04)
- Date syntax in query Ginger (05/23/04)
- Using criteria Dave (05/23/04)
- Adding records to a query? Mike J (05/23/04)
- How to run an update query without cacheing ? Todd Heiks (05/23/04)
- Can't Post Clarification Al Voss (05/23/04)
- I Can't Post Al Voss (05/23/04)
- Dates In Queries Roland Hanson (05/23/04)
- Duplicates Always Learning (05/23/04)
- HELP: Update 1 table with calculated fields from another table Samora (05/23/04)
- From one table -> update the fields from other table Samora (05/23/04)
- Crosstab Query Al Mackay (05/23/04)
- outlook express access to attachment cathy (05/23/04)
- IIF statement error ?? petrovlis (05/23/04)
- Re: complex duplicate queries Gary Walter (05/23/04)
- editing data in a query Mike J (05/22/04)
- Between dates? C & J Jones (05/22/04)
- combo box has repeating options Jennifer (05/22/04)
- Re: combo box has repeating options Jeff Boyce (05/22/04)
- Re: combo box has repeating options Jennifer (05/23/04)
- Re: combo box has repeating options tina (05/23/04)
- Re: combo box has repeating options anonymous_at_discussions.microsoft.com (05/24/04)
- Re: combo box has repeating options tina (05/24/04)
- Re: combo box has repeating options Jennifer (05/24/04)
- Re: combo box has repeating options tina (05/25/04)
- Re: combo box has repeating options anonymous_at_discussions.microsoft.com (05/25/04)
- Re: combo box has repeating options Jennifer (05/23/04)
- Re: combo box has repeating options Jeff Boyce (05/22/04)
- Re: 8571 RE SEU CARRO 85716 Gary Walter (05/22/04)
- rounding off in query patrick (05/22/04)
- "NOT EQUAL" query Chuck (05/21/04)
- 3 subquery criteria question Perico (05/21/04)
- Query Incremenal count Craig (05/21/04)
- RE: How to Write a Simple Query Brad (05/21/04)
- DSum - cumulative calculation Birger (05/21/04)
- Criteria Loi (05/21/04)
- Calculate Age From Birthdate Sandy (05/21/04)
- Validation Rule Errors Giovanne Stallone (05/21/04)
- Most efficient method of exporting a table or recordset to Excel quartz (05/21/04)
- Invalid procedure call, help! Serge (05/21/04)
- Second from the LAST Query Scott Duncan (05/21/04)
- Comments on Access SQL queries Rey (05/21/04)
- Showing blanks in a query Rich (05/21/04)
- Selecting from a list for Query criteria Mike G (05/21/04)
- Query Incremental counter Craig (05/21/04)
- Combining Records Nik (05/21/04)
- How to make a query to dispay a patial matching values Le Tran (05/21/04)
- Criteria for make table Query Allison (05/21/04)
- Wildcards (?) an (05/21/04)
- Query - between and Hanne (05/21/04)
- more dates!!! brigid (05/21/04)
- Formatting Fields in a Query Tom (05/21/04)
- Using not in a query RickM (05/21/04)
- Parameters are not allowing totals by product Rose (05/21/04)
- "Fill-in data when there's no data" Bob Barnes (05/21/04)
- Query and Mail List Database Vince (05/21/04)
- Ranking in query ChuckW (05/21/04)
- Returning the first character of each word in a field Kristina (05/21/04)
- Calendar Linda (05/21/04)
- Re: How to change "United States American" to "USA" in Access Jeff Boyce (05/21/04)
- Aggregate query smk2 (05/21/04)
- Help With 3 Queries Please... David Heath (05/21/04)
- ROUNDING OFF IN QUERIES PATRICK (05/21/04)
- Creating a stored procedure (query) in access Tor Inge Rislaa (05/21/04)
- Help with Make table Query Vijay (05/21/04)
- Select Min value and its date from Table John (05/21/04)
- Dynamic Field Name in Query By Date Sakuraki (05/21/04)
- Dynamic Field Name in Query By Date Sakuraki (05/21/04)
- Trying to add autonumber field to table Perico (05/21/04)
- IN Criteria built from a List Box Chuck (05/21/04)
- ACCESS ARBITRARILY CHANGES RELATIONSHIPS SAVED QUERRY VINCE (05/21/04)
- How to Select every 51st record tj (05/20/04)
- Crosstab query based on another query Nellie (05/20/04)
- Pivot table from Survey Results Diana Bowe (05/20/04)
- Family Listing Taso (05/20/04)
- Help editing SQL string to import a text file into Access quartz (05/20/04)
- Select Distinct Records Type Mismatch Steve (05/20/04)
- select query gal (05/20/04)
- Create autonumber field in make table query Randal (05/20/04)
- Query by form of linked tables return "#Name?" Rich (05/20/04)
- min function Rick G (05/20/04)
- min function Rick G (05/20/04)
- 2ndPost Help with qry criteria PLEASE!! Nydia (05/20/04)
- Number Increment Field in a Query coder23 (05/20/04)
- Number Increment Field in a Query Ted Allen (05/20/04)
- RE: Number Increment Field in a Query coder23 (05/20/04)
- RE: Number Increment Field in a Query Ted Allen (05/20/04)
- RE: Number Increment Field in a Query coder23 (05/20/04)
- RE: Number Increment Field in a Query Ted Allen (05/21/04)
- RE: Number Increment Field in a Query coder23 (05/21/04)
- RE: Number Increment Field in a Query coder23 (05/21/04)
- Re: Number Increment Field in a Query Michel Walsh (05/21/04)
- RE: Number Increment Field in a Query coder23 (05/20/04)
- Number Increment Field in a Query Ted Allen (05/20/04)
- Is is possible to return a list of table names in an external Access DB using SQL? quartz (05/20/04)
- Number Increment Field in a Query coder23 (05/20/04)
- Delete Query Question Patrick Brazelle (05/20/04)
- Extract data Tony (05/20/04)
- DAO query connects and runs, but returns no records rotor (05/20/04)
- Text String Manipulation Kirk P. (05/20/04)
- drop down prompt brigid (05/20/04)
- Error: Operation must use an updateable query Max Moor (05/20/04)
- query to compare columns from two different rows Lis B. (05/20/04)
- Truncate Dan (05/20/04)
- Reserved error (-1517); there is no message for this error shank (05/20/04)
- Un matched query on more than one field nath (05/20/04)
- Separating First and Last names in one field Rachel (05/20/04)
- creating a query mandi (05/20/04)
- One table automatically updates another table based on criteria entered. Rod (05/20/04)
- Exporting Query in XML format rjt (05/20/04)
- missing records in Union Query Jeff (05/20/04)
- One SELECT statement fl (05/20/04)
- How to sort data by parameter Le tran (05/20/04)
- Creating a blank date field with a make-table query tt (05/20/04)
- Saving Query Criteria For Use Later Neil Warwick (05/20/04)
- Creating empty date field with make-table query TT (05/20/04)
- calculation of # of days from quarter end date Sherrie (05/20/04)
- INSERT INTO Fab (05/20/04)
- Problem running queries George (05/20/04)
- # of people served qry nydia (05/20/04)
- date parameters from forms Stephen (05/20/04)
- Compare contents of 2 fields. Dave Phillabaum (05/20/04)