microsoft.public.access.queries
By Thread
3063 messages sorted by: [ date ]
Starting: 03/31/04
Ending: 04/30/04
- logic and < Greg (04/30/04)
- SQL in Report Dennis (04/30/04)
- Re: I'm struggling with my limited knowledge of code tina (04/30/04)
- Help!! Problem with query gene (04/30/04)
- Query criteria referencing field name no longer works Matt (04/30/04)
- Urgent Update Query Bill (04/30/04)
- adding records in a query dola (04/30/04)
- Test for no records returned Brian C (04/29/04)
- Printing Queries Properties B. W. (04/29/04)
- Data from previous record Alan Nicoll (04/29/04)
- hidden queries Jeanne (04/29/04)
- Using If/When type expressions in a report Linda Wampach (04/29/04)
- Help with code to run query and test a field in the record Kate (04/29/04)
- rounding a number in a query Saskatoon (04/29/04)
- Record Ranking Rachel (04/29/04)
- Appending two tables DSmith (04/29/04)
- Linked DBIII Table Maureen (04/29/04)
- Help with hiding/showing forms Katie (04/29/04)
- Splitting a record in two Alan Nicoll (04/29/04)
- Access Query with MS Driver crashing Oracle DB??? Rebecca (04/29/04)
- Field properties in a Query Alan Nicoll (04/29/04)
- Q: Appending crosstab query having dynamic variables MarkD (04/29/04)
- forum input field bob (04/29/04)
- forum input field crazyITguy (04/29/04)
- DoCmd.RunSQL error Help Kate (04/29/04)
- Queries and reports run slow zooeyhall (04/29/04)
- Switch is overloaded! Bonnie (04/29/04)
- Please help with a query Al (04/29/04)
- Convert ROW data to COLUMN JackP (04/29/04)
- 'Query does not exist' message but it does !?! David (04/29/04)
- Help with SQL Syntax CJ (04/29/04)
- Problem with Function Date() in query Rafa³ (04/29/04)
- Compare 2 table & show detail both table Mal (04/29/04)
- DECODE equivalent patricia (04/29/04)
- reports Dave B (04/29/04)
- Need help to remove tbas, carriage retrun, and other!!! Will (04/29/04)
- Help, Sorting Query bug mike (04/29/04)
- outer join paul (04/29/04)
- dec2hex Donna (04/29/04)
- Bin Laden Captured - photos and video jamiewalker_at_wp.shawcable.net (04/29/04)
- Query won't list more than 25 records Scott (04/29/04)
- Crosstab error George Schneider (04/29/04)
- Pass-Through, Default DSN? Gerard (04/29/04)
- Save a filter (from table) as a query Sandy (04/29/04)
- Self Join query question Convoy (04/29/04)
- Please help me with when I can use my key field Kate (04/29/04)
- Difference in days from multiple records Fredrick Smith (04/29/04)
- Date Range Tina (04/29/04)
- How do I test for no records returned in code? Kate (04/29/04)
- Between...And Operator Randal (04/29/04)
- SQL Statement anonymous_at_discussions.microsoft.com (04/29/04)
- Query ti list records that have been modified Daniel P (04/29/04)
- Can you make my SQL do what I want? Please! Kate (04/29/04)
- Make-Table query - Adding table description DK (04/29/04)
- date range query Greg (04/29/04)
- Search between two dates query Greg (04/29/04)
- help with delete query Allen Clark (04/29/04)
- Count Based on Date Frolickin (04/29/04)
- Link table alternative B Nieds (04/29/04)
- Saving a CSV file in a memo field CaribSoft (04/29/04)
- Functions in Access queries Need Help Please! (04/29/04)
- Formula Works but not as Criteria fred (04/28/04)
- changing query parameter with an on-click event nergdergler (04/28/04)
- Error when copying record (Access 97 on W2K or XP) Judy Rudek (04/28/04)
- What does this error mean? Kate (04/28/04)
- Sub Queries Hotfirewire (04/28/04)
- appending records without creating duplicates in a non-indexed table Applebaum (04/28/04)
- Combine Excel into Access (1 Record) WDP (04/28/04)
- Autonumber Brian (04/28/04)
- data type Randal (04/28/04)
- Current Effective date Chris (04/28/04)
- Page break by groups of data Teresa (04/28/04)
- Changing Query Selection criteria Andy (04/28/04)
- Query Months "January to September" etc. Randy (04/28/04)
- searching by month/quarter Calvin (04/28/04)
- Query Help!!!!!!!!!!! msandy (04/28/04)
- SQL Insert Brian C (04/28/04)
- Append verses Update Query George Schneider (04/28/04)
- Query Question George Schneider (04/28/04)
- Web-Based Query Kathy (04/28/04)
- Using special Character Such as * Jim (04/28/04)
- Crosstab query result question +Andrew (04/28/04)
- Managing queries based on other queries Fred Boer (04/28/04)
- Parameters in a Crosstab Querie Jack Stoudt (04/28/04)
- how to check if the result of a query =0 records? A.J.M. van Rijthoven (04/28/04)
- DefaultValue on a Query Filipe Taborda (04/28/04)
- ambiguous outer joins Doug (04/28/04)
- Displaying 1 / All records Steve (04/28/04)
- Help! Sue (04/28/04)
- Add new field in query Cowdog Gal (04/28/04)
- Update Queries Cora Mc (04/28/04)
- inventory project Amanda (04/28/04)
- Implicit Type Conversion For Queries MDW (04/28/04)
- Nothing happens when I press datasheet view MK (04/28/04)
- Joining two fields into one Novice (04/28/04)
- Need help desperately, Problem Generating Errors for currentdb.execute zippy (04/28/04)
- Question on querie for a sum Les (04/28/04)
- Please need help with interesting Cross Join query Max (04/28/04)
- IIf statement Stan (04/28/04)
- Update Stewart Walker (04/28/04)
- Queries not recognizing field names??? Jennifer (04/28/04)
- Group by Weeks - Year Wrap Charles D Clayton Jr (04/28/04)
- access97 query icon is greyed out dk (04/28/04)
- Access XP Font size Michael Burkhardt (04/28/04)
- Re: query variable Vsn (04/28/04)
- Building a string Bob H (04/28/04)
- Multiple table query Gwynn (04/28/04)
- Re: "Expression too Complex" kbath (04/28/04)
- Newby help! Creating user-input defined search queries... Ed G (04/28/04)
- Using Access97!! John Harrop (04/28/04)
- system resource exceeded ody (04/28/04)
- Combining Separate Tables into single Query for Report sctvoice (04/28/04)
- Finance Query for a Newby (2nd time) Vic (04/28/04)
- Print report Page Header on 2nd page and onward Eric (04/28/04)
- Passing same parameter value from 3 different forms Eric (04/28/04)
- Append Query SQL Eric G (04/28/04)
- ADO returns EOF Tausif Alam (04/28/04)
- How to use WORKSPACES? greatmacoy (04/28/04)
- How to use WORKSPACES? greatmacoy (04/28/04)
- How to use WORKSPACES? greatmacoy (04/28/04)
- How to use WORKSPACES? greatmacoy (04/28/04)
- Syntax to Average a time duration (hh:mm:ss). Sid (04/28/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Duane Hookom (04/28/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Sid (04/28/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Sid (04/28/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Duane Hookom (04/28/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Sid (04/28/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Duane Hookom (04/29/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Sid (04/29/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Duane Hookom (04/29/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Sid (04/29/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Duane Hookom (04/29/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Duane Hookom (04/28/04)
- Report based on two tables (first posted in reports) eb1mom (04/27/04)
- Wildcard not happening for me ... help Dale (04/27/04)
- Query to find multiple records for Customer_ID anonymous_at_discussions.microsoft.com (04/27/04)
- qrytoCalculateincome riz (04/27/04)
- Really struggling with SQL Brian C (04/27/04)
- Custom Data Set Paola (04/27/04)
- Problem Genetating Errors zippy (04/27/04)
- Calling an Access query containing function from VB Ray (04/27/04)
- Random Selects in Access Brian (04/27/04)
- MAJOR Dillema anonymous_at_discussions.microsoft.com (04/27/04)
- query Darren Spooner (04/27/04)
- strip dashs in query LOIS (04/27/04)
- Parse a string of text from a linked .txt file Steven M. Britton (04/27/04)
- Change data within a query Al Mackay (04/27/04)
- Print out Query Multiple Times Christine (04/27/04)
- Can this be done? uma1919 (04/27/04)
- Use make table query and changed linked field property Lurch (04/27/04)
- Sorting by Month problems with Combobox Elizabeth (04/27/04)
- Sorting by Month problems with Combobox anonymous_at_discussions.microsoft.com (04/27/04)
- Re: Sorting by Month problems with Combobox MGFoster (04/27/04)
- Re: Sorting by Month problems with Combobox John Vinson (04/27/04)
- Re: Sorting by Month problems with Combobox Elizabeth (04/27/04)
- Re: Sorting by Month problems with Combobox John Vinson (04/28/04)
- Re: Sorting by Month problems with Combobox Elizabeth (04/28/04)
- Re: Sorting by Month problems with Combobox ELizabeth (04/28/04)
- Re: Sorting by Month problems with Combobox John Vinson (04/28/04)
- Re: Sorting by Month problems with Combobox Elizabeth (04/28/04)
- Re: Sorting by Month problems with Combobox John Vinson (04/29/04)
- Re: Sorting by Month problems with Combobox Elizabeth (04/29/04)
- Re: Sorting by Month problems with Combobox Elizabeth (04/27/04)
- Query on table with a lookup Jen (04/27/04)
- Timestamp Tara (04/27/04)
- Outer Join problem Somayaji (04/27/04)
- Current Date AntRig (04/27/04)
- Reurning to a form after a query. Tim Holmgren (04/27/04)
- Can't join on memo or ole object MK (04/27/04)
- Query Based On User Selection Chuck (04/27/04)
- Querie from table. Krefty (04/27/04)
- Blank records LJ (04/27/04)
- Saving design changes in Access 2000 locks out ADO, why? Michael Edwards (04/27/04)
- Re: Sort Order -- Random? Allen Browne (04/27/04)
- 3 columns with different dates Jenn (04/27/04)
- Query SQL keeps getting erased Jeremy Ames (04/27/04)
- SELECT FROM function in Access 2000 Paolo Bormida (04/27/04)
- Filter by form values in a Crosstab Query Becca (04/27/04)
- Printing a Query Mike Kaendera (04/27/04)
- Using one query multiple times w/different parameters in a report David G. (04/27/04)
- Query Criteria - Substring Jim Miller (04/27/04)
- Using multiple criteria in Like Operator Luqman (04/27/04)
- creating a query based on a yes/no field nergdergler (04/27/04)
- Checking values in returned records Brian C (04/27/04)
- Repost updating records with data from multiple forms Brian C (04/27/04)
- UNION order MK (04/27/04)
- missing fields Erik p (04/27/04)
- house numbers Tom McD (04/27/04)
- How to group data and display some of the details in a column? Shirley (04/27/04)
- Query Problems James (04/27/04)
- SQL Recordset MK (04/27/04)
- What's wrong with this query?? muenchr_at_ozemail.com.au (04/27/04)
- Finance Query for a Newbie Vic (04/27/04)
- Create a primary key in a make table query Nigel (04/27/04)
- Help converting rows to columns Cowdog Gal (04/27/04)
- Update and Create statements Brian C (04/27/04)
- Process multiple records Brian C (04/27/04)
- new at queries-can I do this one? zirkerc (04/27/04)
- Books Peter (04/27/04)
- Update a given number juliambuchholz (04/27/04)
- Query Parameters from a List Box JoeCL (04/26/04)
- I Need Help Building A Query JCrowe (04/26/04)
- group by errors Sean (04/26/04)
- Running balance from record to record Randy (04/26/04)
- posting to multiple forums Brian C (04/26/04)
- Help with queries Brian C (04/26/04)
- Challenging Query Diana (04/26/04)
- Adding fields to tables Alan Nicoll (04/26/04)
- Querying Dates Andrew Thorpe (04/26/04)
- Tough Challenge...Alias, Nested Query? mj (04/26/04)
- Nesting IIf statements ron b (04/26/04)
- How do I create a query that will only select a single record? Jimtno (04/26/04)
- Re: splitting text fild BDP (04/26/04)
- Re: Splitting Full Names into two fields BDP (04/26/04)
- switch cared ian.uk (04/26/04)
- DCount problem Alan Nicoll (04/26/04)
- Current On-Hand-Quantity Dale Fye (04/26/04)
- Please help with coding Sheela (04/26/04)
- First day of current year Tara (04/26/04)
- Syntax error BrianC (04/26/04)
- query criteria msandy (04/26/04)
- wild search sheela (04/26/04)
- Multiple Name Query Kelly (04/26/04)
- Access pass through queries bhorwitz_at_zachys (04/26/04)
- Complicated Query George Schneider (04/26/04)
- error with query expression Janey Baker (04/26/04)
- working with combo boxes Calvin (04/26/04)
- updates across forms Brian C (04/26/04)
- Query keeps returning blank records Josh S (04/26/04)
- Running a query using data from a form Brian C (04/26/04)
- Extracting month from date field anonymous_at_discussions.microsoft.com (04/26/04)
- UGH! Next month Quary? Justin (04/26/04)
- Re: Counter in a Query Vern (04/26/04)
- access 97 out of mem error Antz (04/26/04)
- Count function returns nothing Sandra (04/26/04)
- Date Query Issue Shaji (04/26/04)
- Query Help George Schneider (04/26/04)
- Help with Query James (04/26/04)
- parameter query not working ... Grace (04/26/04)
- The Find Unmatched Query doesn't run Shilps (04/26/04)
- Username? Rickard Sjöberg (04/26/04)
- MS Access run-time error 3610 on XP machine KK (04/26/04)
- using result of REPLACE function as the criteria for query anonymous_at_discussions.microsoft.com (04/26/04)
- using result of REPLACE function as the criteria for query chaosunplugged (04/26/04)
- Re: using result of REPLACE function as the criteria for query Gary Walter (04/26/04)
- Re: using result of REPLACE function as the criteria for query anonymous_at_discussions.microsoft.com (04/27/04)
- Re: using result of REPLACE function as the criteria for query Gary Walter (04/27/04)
- Re: using result of REPLACE function as the criteria for query anonymous_at_discussions.microsoft.com (04/28/04)
- Re: using result of REPLACE function as the criteria for query anonymous_at_discussions.microsoft.com (04/28/04)
- Re: using result of REPLACE function as the criteria for query anonymous_at_discussions.microsoft.com (04/28/04)
- Re: using result of REPLACE function as the criteria for query anonymous_at_discussions.microsoft.com (04/28/04)
- Re: using result of REPLACE function as the criteria for query Gary Walter (04/29/04)
- Re: using result of REPLACE function as the criteria for query Gary Walter (04/26/04)
- using result of REPLACE function as the criteria for query chaosunplugged (04/26/04)
- update query adding 2 records WWV (04/26/04)
- Can I create a query (or any nifty easy way) to do this? jj (04/26/04)
- Start\End Date Query Rohit Thomas (04/25/04)
- Norton Antivirus Admin (04/25/04)
- combining several records into one Jenny (04/25/04)
- Update Query Michael Cooper (04/25/04)
- Query returns blank gary (04/25/04)
- Query the most recent transaction for each customer Fred (04/25/04)
- can't find tables used in query Buboy (04/25/04)
- Syntax Error in String in Expression...? James (04/24/04)
- Run Saved Query from ASP Page Ryan Barnes (04/24/04)
- record number in a query Finn Jensen (04/24/04)
- Open word document Dennis (04/24/04)
- SQL restructured incorrectly by MS Access Daniel S (04/24/04)
- How do I use data from other fields in a found record A.J.M. van Rijthoven (04/24/04)
- Default Datasheet Layout SANJAY SHAH \(MICROBRAIN Computers Pvt. Ltd.\) (04/24/04)
- New Column in Make Table Query Cowdog Gal (04/24/04)
- Returning query results to form Tim (04/23/04)
- Count Function Joel (04/23/04)
- Excluding related records and a subquery NOT IN clause Scott Millhisler (04/23/04)
- Help With SQL Zane (04/23/04)
- Work Hours w/o Weekend ty (04/23/04)
- Prompt User for Input to Query Dijait (04/23/04)
- Querying the two most recent entries benb (04/23/04)
- XXX Action Query XXX bladelock (04/23/04)
- using auto date and Date() jennifer (04/23/04)
- Ltrim function error marv (04/23/04)
- Deleting records where two fields match... Trevor (04/23/04)
- Frustrated! Field to join 2 queries Mary (04/23/04)
- Query SQL Michele Zenna (04/23/04)
- Manipulate data in a field Alan Gordon (04/23/04)
- Count Function JoeL (04/23/04)
- Update Products Cyp (04/23/04)
- Update Products Cyp (04/23/04)
- Update Products Cyp (04/23/04)
- Update Products Cyp (04/23/04)
- One parameter entry needed Mike Z (04/23/04)
- Week Day Functions Tim Legg (04/23/04)
- XXX SQL Query XXX bladelock (04/23/04)
- Unexpected results in a query Mike (04/23/04)
- Dynamic Table Reference Sam (04/23/04)
- incorrect data to data adapter carl morahan (04/23/04)
- Automate make table query Allison (04/23/04)
- SQL Time Syntax referring to a form control Sid (04/23/04)
- xxx SQL Queries xxx bladelock (04/23/04)
- Re: SQL Date/Time Question Sid (04/23/04)
- Beastialit Gone Wrong Home Pics dereksimpson_at_vs.shawcable.net (04/23/04)
- query Jan Newton (04/23/04)
- Parameter query where the parameter is the value of a TextBox Richard (04/23/04)
- cutting last digits Pjero Nizeteo (04/23/04)
- Subtotal in a Query Gus (04/23/04)
- combine normal query vs crosstab query Ezekiël (04/23/04)
- Re: Feeding a top records query marcusjb (04/23/04)
- Accessing hierarchies Sajid (04/23/04)
- Date Format complications Tej S. (04/23/04)
- weekday Name Function Clyde Lomax (04/23/04)
- Refering to a detail section on a form Spammastergrand (04/22/04)
- Help on an expression Amanda (04/22/04)
- Counting Records in Query Alan Nicoll (04/22/04)
- For Next Loop Sean (04/22/04)
- Combining Columns in one query Carol M (04/22/04)
- "Optional feature not implenented" dwa (04/22/04)
- Update Query Follow-up Luther (04/22/04)
- Microsoft Query GenoP (04/22/04)
- Use ombo box to select parameter Jim (04/22/04)
- How do I count Uses rather than Dates Kathy (04/22/04)
- How can I put the value of a previous record field in a query? Jayes (04/22/04)
- Need help with Date Query Daniel Brown (04/22/04)
- Parameter Dan (04/22/04)
- Multiple Filters anonymous_at_discussions.microsoft.com (04/22/04)
- DateDiff David (04/22/04)
- "Find Highest and Lowest" Query Jason W. (04/22/04)
- complicated query Bob Brannon (04/22/04)
- I simple issue. Please advise! nest (04/22/04)
- SQL help !!! Walter (04/22/04)
- Crosstab Form reference Steve (04/22/04)
- Simple Filter Question Zane (04/22/04)
- Multiple Numbers Or'd as criteria from Form JoeWM (04/22/04)
- Make Table Dropping Records M (04/22/04)
- sum function opeyemi1 (04/22/04)
- sum function opeyemi1 (04/22/04)
- sum function opeyemi1 (04/22/04)
- sum function opeyemi1 (04/22/04)
- Zane Simple Filter Question (04/22/04)
- Queries Marie (04/22/04)
- ms-dos file handles Rhonda (04/22/04)
- Passing Parameters Erna Henderson (04/22/04)
- IS null Jean (04/22/04)
- SELECT QUERY to REPORT / DATA VIEW within ACCESS SUB (04/22/04)
- select distinct doesn;t work Nikos (04/22/04)
- Comparing to prior record anonymous_at_discussions.microsoft.com (04/22/04)
- Combining Three Queries into one Daniel P (04/22/04)
- Date format in queries Derick Reinecke (04/22/04)
- Date format in Access Derick Reinecke (04/22/04)
- Criteria, Between two times... Sid (04/22/04)
- Odd Behavior with a URL Frolickin (04/22/04)
- Problems with tables and updating Kentucky5 (04/22/04)