microsoft.public.access.queries
By Thread
3085 messages sorted by: [ date ]
Starting: 01/30/05
Ending: 02/27/05
- Error -> Multi-level GROUP BY clause is not allowed in a subquery. Don (02/27/05)
- Coudnt save Philip Jones (02/27/05)
- Access SUMs Full Column When Using Subquery Chris2 (02/27/05)
- Selecting data to run a query by using a drop down list ATanker62 (02/27/05)
- Missing Data in Query Results RNUSZ_at_OKDPS (02/27/05)
- Retrive informations fro two lists Nils Magne (02/27/05)
- Filters and query records Stefan (02/27/05)
- Help! About function AndreasM (02/27/05)
- Using "Iif" in field row of calculated query Mandorallin (02/27/05)
- Creating a query where a field not in table needed Mandorallin (02/27/05)
- Identify who is sending e-mail ALERTS requesting msn.private info. librantrek (02/27/05)
- Separate number from column Nathan (02/27/05)
- SQL SELECT to order Text in a numerical fashion Morticia Addams (02/27/05)
- Update Query Dale Brown (02/27/05)
- simple query problem Jonathan Wells (02/26/05)
- Query question Ken Schisler (02/26/05)
- Where has the content gone? Phanto (02/26/05)
- Updating information in a table Jonathan Wells (02/26/05)
- Update query mac_see (02/26/05)
- calculation in a form Garry (02/26/05)
- Problem With Nested Joins Don (02/26/05)
- Re: Problem With Nested Joins Ken Snell [MVP] (02/26/05)
- Re: Problem With Nested Joins Don (02/26/05)
- Re: Problem With Nested Joins Ken Snell [MVP] (02/26/05)
- AAHHHHHH! -> Re: Problem With Nested Joins Don (02/26/05)
- Re: AAHHHHHH! -> Re: Problem With Nested Joins Ken Snell [MVP] (02/26/05)
- Re: AAHHHHHH! -> Re: Problem With Nested Joins Ken Snell [MVP] (02/26/05)
- Re: AAHHHHHH! -> Re: Problem With Nested Joins Ken Snell [MVP] (02/26/05)
- THANKS! -> Re: AAHHHHHH! -> Re: Problem With Nested Joins Don (02/26/05)
- Re: Problem With Nested Joins Don (02/26/05)
- Re: Problem With Nested Joins Ken Snell [MVP] (02/26/05)
- Access Stored Procedure Problem Savas Ates (02/26/05)
- computer freeze when making calculated total field in pivottable . Ko Zaw (02/26/05)
- Conditional update field in sql Stukmeister (02/26/05)
- search between two dates shah firdaous via AccessMonster.com (02/26/05)
- Query Greg Jesky (02/26/05)
- Days between calculation MarkW (02/26/05)
- Extract numeric data from column Nathan (02/26/05)
- sample sql for access Stukmeister (02/26/05)
- distinct count Stukmeister (02/26/05)
- How to expand query T. Burr (02/25/05)
- Problem with query expression Martin Watts (02/25/05)
- Can somebody help me with this cross tab query? K. L. Collins (02/25/05)
- SQL append query with A2K Ted (02/25/05)
- Delete Query Problem iholder (02/25/05)
- Add hyphens Ellen (02/25/05)
- strange behavior on query result Sunny (02/25/05)
- Query Count Conditions Chris Monner via AccessMonster.com (02/25/05)
- DatePart Isca Comps (02/25/05)
- Calculate to 2 places Garry Fitzgerald (02/25/05)
- Expression Robin Gilbert via AccessMonster.com (02/25/05)
- Update Query expression Robin Gilbert (02/25/05)
- How code this tricky query? mscertified (02/25/05)
- Get Latest Entry with Query James Stephens (02/25/05)
- Extracting Characters Alex (02/25/05)
- Hours btw two dates? Arul (02/25/05)
- True/False Parameter query AlCamp (02/25/05)
- search queries Alfred FPC (02/25/05)
- Suddenly, I can't download clip art selections! Am I stupid? (02/25/05)
- CrossTab Query Prem (02/25/05)
- append query rounds when it shouldn't dkingston (02/25/05)
- crosstab problem Roy (02/25/05)
- odd numbers jimtodd (02/25/05)
- How do i find all items that have a certain word in using quiery Edwardo (02/25/05)
- Update query to resequence MSROOKIE (02/25/05)
- Problem with grouping on the last date. Frank Martin (02/25/05)
- I'm trying to set a primary key in the queries tab of Access. The parawon (02/25/05)
- I'm trying to set a primary key in a query The parawon (02/25/05)
- urgent ! outer join not picking all records questy (02/25/05)
- Sorting A Crosstab Query Diggsy (02/24/05)
- Extracting characters Alex (02/24/05)
- Count Blank Fields Bill Sturdevant (02/24/05)
- Two Criteria Sam (02/24/05)
- Deselect Field Sam (02/24/05)
- Left/Right Join not working for ODBC Linked Table? Jinshui (02/24/05)
- Query to find missing records BIll Mills (02/24/05)
- Advice needed B_Lyles (02/24/05)
- Getting #Num! in my ACCESS query Jan Buckley (02/24/05)
- Append query - only want to append new records Mandi (02/24/05)
- Using DCount and/or DSum in Update Query Abe W (02/24/05)
- Re: Using DCount and/or DSum in Update Query Duane Hookom (02/24/05)
- Re: Using DCount and/or DSum in Update Query Abe W (02/24/05)
- Re: Using DCount and/or DSum in Update Query Duane Hookom (02/24/05)
- Re: Using DCount and/or DSum in Update Query Abe W (02/24/05)
- Re: Using DCount and/or DSum in Update Query Duane Hookom (02/25/05)
- Re: Using DCount and/or DSum in Update Query Abe W (02/25/05)
- Re: Using DCount and/or DSum in Update Query Duane Hookom (02/25/05)
- Re: Using DCount and/or DSum in Update Query Abe W (02/24/05)
- Re: Using DCount and/or DSum in Update Query Duane Hookom (02/24/05)
- Group By or Sum - run time error 3146 Andre (02/24/05)
- Unmatched query news (02/24/05)
- Select top three and not responding error Brittany :) (02/24/05)
- Union Queries on ODBC (V FoxPro) linked tables generate error from .mdb front end. Michael Edwards (02/24/05)
- Re: Union Queries on ODBC (V FoxPro) linked tables generate error from .mdb front end. [MVP] S.Clark (02/24/05)
- Re: Union Queries on ODBC (V FoxPro) linked tables generate error from .mdb front end. Cindy Winegarden (02/25/05)
- Re: Union Queries on ODBC (V FoxPro) linked tables generate error from .mdb front end. Michael Edwards (02/25/05)
- Help! combine results of two queries into one query? terry (02/24/05)
- Pulling pictures inot a form ? al9315 (02/24/05)
- Missing Query Results BobbyZ (02/24/05)
- How do I calculate percentile in acccess? chibby racer (02/24/05)
- Macro to remove ";" JA (02/24/05)
- Zeros in a crosstab query Jim Jones (02/24/05)
- Query Question PW11111 (02/24/05)
- Right and Left Join at the same time mscone2000 (02/24/05)
- Adding columns in a cross tab query Toldoriath (02/24/05)
- How do I run a query between two dates? Matt (02/24/05)
- criteria from combo box Jiayou Liu (02/24/05)
- Remove ";" JA (02/24/05)
- In Access can I update records from a totals query? MarionT (02/24/05)
- How to make a quary to get report for specific time period? J.A.Pandya - Mechanical Maint. Engineer (02/24/05)
- crazy inner join jjrmy1_at_earthlink.net (02/24/05)
- Basic Question About Queries Tab The parawon (02/24/05)
- Beginner Query Help The parawon (02/24/05)
- How to check for completed records? chetNeedsSomeHelp (02/24/05)
- Start of Month pjd (02/24/05)
- Can Not Open Any More Databases Dave (02/24/05)
- Re: Can Not Open Any More Databases Allen Browne (02/24/05)
- Re: Can Not Open Any More Databases Tim Marshall (02/24/05)
- Re: Can Not Open Any More Databases deko (02/24/05)
- Re: Can Not Open Any More Databases Allen Browne (02/24/05)
- Re: Can Not Open Any More Databases deko (02/24/05)
- Re: Can Not Open Any More Databases Allen Browne (02/24/05)
- Re: Can Not Open Any More Databases deko (02/24/05)
- Re: Can Not Open Any More Databases Allen Browne (02/24/05)
- Re: Can Not Open Any More Databases deko (02/24/05)
- Re: Can Not Open Any More Databases deko (02/24/05)
- Re: Can Not Open Any More Databases Tony Toews (02/24/05)
- Re: Can Not Open Any More Databases Allen Browne (02/24/05)
- Simple Query/Date issue (I Hope) Randy (02/24/05)
- I need to only print out one occurence of a name CES (02/23/05)
- create table query & numeric field overflow granada75067 (02/23/05)
- I'm running a create table query - "numeric field overflow" error granada75067 (02/23/05)
- Enter Parameter Value keeps appearing Haji (02/23/05)
- First field populated... Rachel (02/23/05)
- dlookup based off of mutliple text box values Dave (02/23/05)
- What is a check sheet in Access? Allison (02/23/05)
- Creating an Index on Two fields ChuckW (02/23/05)
- Mutiple Field Crosstab Kevin Labore (02/23/05)
- get rid of confirmation boxes Chris (02/23/05)
- auto size small table windows in top half of QBE query window andrew (02/23/05)
- Query expression to add data Tony Williams (02/23/05)
- RE: Uing the UPDATE or THEN command with a WHERE clause in a query? sharp (02/23/05)
- How can I do a "best match" association between text strings? DataGuy0722 (02/23/05)
- Making queries "Invisible" Tara (02/23/05)
- Views - Access 2000 S Schneid (02/23/05)
- Unstable Queries RandyInMass (02/23/05)
- Return Query values based on calculated field Ayse via AccessMonster.com (02/23/05)
- Convert time to date? Leslie Isaacs (02/23/05)
- Another Northwind Query question ? TonyB (02/23/05)
- Query with parameter ? TonyB (02/23/05)
- Northwind Question ? TonyB (02/23/05)
- Query must filter out records beginning with "192" Rene Wennekes (02/23/05)
- Which sorting does ms access use for strings? CSI member (02/23/05)
- The right person for the job Don (02/23/05)
- Re: The right person for the job Ken Snell [MVP] (02/23/05)
- Re: The right person for the job Don (02/23/05)
- Re: The right person for the job Ken Snell [MVP] (02/23/05)
- Re: The right person for the job Don (02/24/05)
- Re: The right person for the job John Viescas (02/23/05)
- Re: The right person for the job Don (02/24/05)
- Re: The right person for the job John Viescas (02/24/05)
- Re: The right person for the job DonMoody (02/25/05)
- Re: The right person for the job John Viescas (02/25/05)
- Re: The right person for the job Don (02/23/05)
- Re: The right person for the job Ken Snell [MVP] (02/23/05)
- Date criteria Dado (02/23/05)
- how do i join tables with mismatched data Char13y (02/23/05)
- Criteria rule with verifying 1st 3 characters of a text Rene Wennekes (02/23/05)
- how can i walk backwards thru a hierarchy? James (02/23/05)
- Hey, take a look here L.A. Confidential (02/23/05)
- Take a look here L.A. Confidential (02/23/05)
- Simple Access Query Question The parawon (02/23/05)
- subtract records from different rows akfish (02/23/05)
- Re: subtract records from different rows Duane Hookom (02/23/05)
- Re: subtract records from different rows akfish (02/23/05)
- Re: subtract records from different rows Duane Hookom (02/23/05)
- Re: subtract records from different rows akfish (02/23/05)
- Re: subtract records from different rows Michel Walsh (02/23/05)
- Re: subtract records from different rows akfish (02/23/05)
- Re: subtract records from different rows Duane Hookom (02/24/05)
- Re: subtract records from different rows akfish (02/23/05)
- Re: subtract records from different rows Duane Hookom (02/23/05)
- Select field based on variables Christopher King (02/22/05)
- Can I use SQL trim function for this? Stuart E. Wugalter (02/22/05)
- union query and eliminate duplicates Jake (02/22/05)
- null js (02/22/05)
- Any way to run (not open) an append query from VBA? mscertified (02/22/05)
- queries and criteria blueskyecat (02/22/05)
- Saving and then Applying a filter on a form BunnyMom (02/22/05)
- update one table based on another ljubo lecic via AccessMonster.com (02/22/05)
- In a query, how do I get two Items off of a table of 13? heatherhm (02/22/05)
- Starting a query using a drop down list box ATanker62 (02/22/05)
- Date range query? Dennis (02/22/05)
- Query help! one is dreadfully slow, the other doesn't work obfruscated (02/22/05)
- creating a calculated field kieran (02/22/05)
- rll jerseygirl (02/22/05)
- Query help! one is dreadfully slow, the other doesn't work obfruscated (02/22/05)
- Strange symbols for a column LMB (02/22/05)
- Strange symbols for a column LMB (02/22/05)
- Expression from table? RahimA53 (02/22/05)
- query bound to combo box doesn't sort correctly epigram (02/22/05)
- Conditional Formatting in a query LMB (02/22/05)
- Grouping Question Paul Murphy via AccessMonster.com (02/22/05)
- Archive and delete Kaylay (02/22/05)
- Employee Availblility Don (02/22/05)
- comparing data in two tables Jake (02/22/05)
- Query to delete duplicate records - but NOT original SusanV (02/22/05)
- Re: Query to delete duplicate records - but NOT original Roger Carlson (02/22/05)
- Re: Query to delete duplicate records - but NOT original SusanV (02/22/05)
- Re: Query to delete duplicate records - but NOT original Roger Carlson (02/22/05)
- Re: Query to delete duplicate records - but NOT original SusanV (02/22/05)
- Re: Query to delete duplicate records - but NOT original Roger Carlson (02/22/05)
- Re: Query to delete duplicate records - but NOT original SusanV (02/22/05)
- Re: Query to delete duplicate records - but NOT original SusanV (02/23/05)
- Re: Query to delete duplicate records - but NOT original Roger Carlson (02/24/05)
- Re: Query to delete duplicate records - but NOT original SusanV (02/24/05)
- Re: Query to delete duplicate records - but NOT original SusanV (02/22/05)
- Re: Query to delete duplicate records - but NOT original Roger Carlson (02/22/05)
- Set Up Query To Look Like A Pivot Table FrankTimJr (02/22/05)
- Enablle and Disable Associated Fields Butch Dingle (02/22/05)
- show 0 in crosstabquery hermie (02/22/05)
- ODBC Timeout default Randal (02/22/05)
- Top 3 results in each group required ancient_hilly (02/22/05)
- Querying fields in a tabbed form. Richard Horne (02/22/05)
- ambiguous outer joins renwick (02/22/05)
- ODBC Call failed ljg (02/22/05)
- Re: ODBC Call failed Jeff Boyce (02/22/05)
- Re: ODBC Call failed ljg (02/22/05)
- Re: ODBC Call failed Jeff Boyce (02/22/05)
- Re: ODBC Call failed ljg (02/22/05)
- Re: ODBC Call failed Jeff Boyce (02/22/05)
- Re: ODBC Call failed ljg (02/22/05)
- Re: ODBC Call failed Jeff Boyce (02/23/05)
- Re: ODBC Call failed ljg (02/23/05)
- Re: ODBC Call failed Van T. Dinh (02/23/05)
- Re: ODBC Call failed Van T. Dinh (02/23/05)
- Re: ODBC Call failed Jeff Boyce (02/23/05)
- Re: ODBC Call failed ljg (02/22/05)
- Re: ODBC Call failed Jeff Boyce (02/22/05)
- Invalid Argument error... Vaughan (02/22/05)
- Pbl with DateAdd with Format in query Frankie via AccessMonster.com (02/22/05)
- DLookUp-Am Lost John (02/22/05)
- At Your Survey: import data from existing Excel table? butbi_at_mailinator.com (02/22/05)
- Re: At Your Survey: import data from existing Excel table? Duane Hookom (02/22/05)
- Re: At Your Survey: import data from existing Excel table? butbi_at_mailinator.com (02/22/05)
- Re: At Your Survey: import data from existing Excel table? butbi_at_mailinator.com (02/22/05)
- Re: At Your Survey: import data from existing Excel table? Duane Hookom (02/23/05)
- Re: At Your Survey: import data from existing Excel table? butbi_at_mailinator.com (02/23/05)
- Re: At Your Survey: import data from existing Excel table? Duane Hookom (02/24/05)
- Re: At Your Survey: import data from existing Excel table? butbi_at_mailinator.com (02/24/05)
- Re: At Your Survey: import data from existing Excel table? butbi_at_mailinator.com (02/24/05)
- Re: At Your Survey: import data from existing Excel table? Duane Hookom (02/24/05)
- Re: At Your Survey: import data from existing Excel table? butbi_at_mailinator.com (02/22/05)
- Re: At Your Survey: import data from existing Excel table? Duane Hookom (02/22/05)
- Weird Not In Query Peter Carlson (02/22/05)
- How I get a MsgBox to appear for a query that doesn't produce data Charles (02/22/05)
- Specified field ... could refer to more than one table... Brian (02/22/05)
- query = > today ? Glenn (02/22/05)
- values of each product and your suppliers? Frank Dulk (02/22/05)
- null fields part 2 bbdobuddy (02/22/05)
- sorting date in crosstab query binnie pillai (02/22/05)
- Expression using RIGHT and LEN functions Marlene (02/22/05)
- How do I find a tutorial on simple and complex Crosstab queries? Catholic Mike (02/21/05)
- Function Left/Right does work correctly in Access 2000. dwcalhoun (02/21/05)
- Function Left/Right does work correctly in Access 2000. Denny Calhoun (02/21/05)
- String data, right truncation (#0) error! BG (02/21/05)
- Re: How do I get dummy values from a UNION statement? _ (02/21/05)
- fit a field with text files in a query Thomas (02/21/05)
- Finding last occurence of a record Steve_s (02/21/05)
- query all controls on a form G (02/21/05)
- Re: query all controls on a form Jeff Boyce (02/21/05)
- Re: query all controls on a form G (02/21/05)
- Re: query all controls on a form Duane Hookom (02/21/05)
- Re: query all controls on a form G (02/21/05)
- Re: query all controls on a form Duane Hookom (02/22/05)
- Re: query all controls on a form G (02/25/05)
- Re: query all controls on a form Duane Hookom (02/26/05)
- Re: query all controls on a form G (02/26/05)
- Re: query all controls on a form G (02/21/05)
- Re: query all controls on a form Jeff Boyce (02/21/05)
- query problems Mike (02/21/05)
- complex query Dean (02/21/05)
- Deleting particular records based on other parameters rgrantz (02/21/05)
- Error in query ?? Alex (02/21/05)
- I want to change the way a cross-tab query will summarize by date. Dan Connors (02/21/05)
- Format Query ANDY (02/21/05)
- Query help! one is dreadfully slow, the other doesn't work obfruscated (02/21/05)
- Merging Access to Word Patti-CUSD#5 (02/21/05)
- selecting data in a field between two points mccloud (02/21/05)
- Is there an Access or VB expression comparable to the NetworkDays. DarrelS (02/21/05)
- Date query parameters entered from form not working kraymond (02/21/05)
- How do I add a password? Ed (02/21/05)
- Re: How do I add a password? Rick B (02/21/05)
- Re: How do I add a password? Ed (02/21/05)
- Re: How do I add a password? Rick B (02/21/05)
- Re: How do I add a password? Ed (02/21/05)
- Re: How do I add a password? Ed (02/21/05)
- Re: How do I add a password? MGFoster (02/21/05)
- Re: How do I add a password? Ed (02/21/05)
- Re: How do I add a password? Douglas J. Steele (02/21/05)
- Re: How do I add a password? Gary Walter (02/22/05)
- Re: How do I add a password? Ed (02/22/05)
- Re: How do I add a password? Ed (02/21/05)
- Re: How do I add a password? Rick B (02/21/05)
- Combine Results from 2 Queries Parker (02/21/05)
- I can't create new records in my Query Victor Torres (02/21/05)
- Returning a dynamic date range Ali (02/21/05)
- HELP: SQL query using LIKE and % wildcard chilly_schrimp (02/21/05)
- Update Query: Stock Control Dave19862005 (02/21/05)
- Wedding query blues! Lee (02/21/05)
- Modules kaylay (02/21/05)
- Re: Displaying row no/Record Counting NorthernMonkey (02/21/05)
- Payment check sebross (02/21/05)
- How to search record based on Month Suzie (02/21/05)
- IF STATEMENT IN SQL BorisTheRussian (02/21/05)
- null fields bbdobuddy (02/21/05)
- Link To Outlook Express Steve (02/21/05)
- How to make a query to compare values in different columns? Murph (02/20/05)
- Using a . in the column name Me (02/20/05)
- Total words in a field Darren (02/20/05)
- number parameterized query, "blank = all"? HB (02/20/05)
- Need help with a query HB (02/20/05)
- Cross Tab Query Days of the week Joe H (02/20/05)
- testing for null fields bbdobuddy (02/20/05)
- "All" in query criteria Alan B. Densky (02/20/05)
- Sub script out of range Simonglencross (02/19/05)
- Invoice/Payment query diana2ke (02/19/05)
- add charactor if required in query Alec Green (02/19/05)
- Queries/Forms not working David Carter (02/19/05)
- Re: Update 1 column to many column Tez H (02/19/05)
- Multiple entries in query just want one displayed ATanker62 (02/19/05)
- Weeknumber with leading zero and year OrdrupAB (02/19/05)
- i empted the recycle bin can i undo it gts1970monaro (02/19/05)
- is this numeric conversion possible? Brook (02/19/05)
- Re: is this numeric conversion possible? Jeff Boyce (02/19/05)
- Re: is this numeric conversion possible? Brook (02/19/05)
- Re: is this numeric conversion possible? Jeff Boyce (02/19/05)
- Re: is this numeric conversion possible? Duane Hookom (02/19/05)
- Re: is this numeric conversion possible? Brook (02/19/05)
- Re: is this numeric conversion possible? Brook (02/19/05)
- Re: is this numeric conversion possible? Duane Hookom (02/19/05)
- Re: is this numeric conversion possible? Brook (02/20/05)
- Re: is this numeric conversion possible? Duane Hookom (02/20/05)
- Re: is this numeric conversion possible? MGFoster (02/20/05)
- Re: is this numeric conversion possible? Brook (02/19/05)
- Re: is this numeric conversion possible? Jeff Boyce (02/19/05)
- Northwind Question ? TonyB (02/19/05)
- Query Results Restrictive DLM (02/19/05)
- alternate data viewing manohar (02/19/05)
- between date and date Jason (02/19/05)
- iif statement Joel Allen (02/19/05)
- Prevent showing duplicate records in Access and half of the field. endofanalley (02/19/05)
- Help with running sum Alex (02/19/05)
- How do I get Christian Name and Surname separated? John O'Gorman (02/19/05)
- infinite shape clause? James (02/19/05)
- Formatting question Wylie C (02/18/05)
- Why won't my query save more than 475 records? GenMcD (02/18/05)
- subform results to be used for word mail merge InACCESS_Able (02/18/05)
- How do you group and count ID's with decimals Gabe Portillo via AccessMonster.com (02/18/05)
- how create append query with all columns in both tables? mscertified (02/18/05)
- Cannot port OUTER join code from SQL Server to Access 2000 ChrisG \(UK\) (02/18/05)
- nz Annnie (02/18/05)
- Access 97 Bruce (02/18/05)
- less-than criteria not working Becky Lazar (02/18/05)
- Find the First time operation happened Brent Sweet (02/18/05)
- How do I append only new records while also updating old ones? baltimore31 (02/18/05)
- Access Merging to Word Patti-CUSD#5 (02/18/05)
- Queries and Dates pepenacho (02/18/05)
- Run module function in query? Jessica (02/18/05)
- Append Query ? Again Jason Rhymes (02/18/05)
- Random Select Hackman Chan (02/18/05)
- selecting last record that matches two tables Hackman Chan (02/18/05)
- searching fields Alfred FPC (02/18/05)
- Merging information into a word document from a parameter query. lisacycle (02/18/05)
- Problem with query and table joins Chuck Mueller (02/18/05)
- Text String Garry Fitzgerald (02/18/05)
- Append Query to Insert Table Name Jason Rhymes (02/18/05)
- Calculation in Query Erika (02/18/05)
- Union Query Jason Rhymes (02/18/05)
- Query finds wrong data. dbl (02/18/05)
- Deleting a Paragraph Formating sign