microsoft.public.access.queries
By Thread
3257 messages sorted by: [ date ]
Starting: 12/30/04
Ending: 01/30/05
- Parameters in Queries Paul Murphy via AccessMonster.com (01/30/05)
- Business Day Calculator Karen Hart (01/30/05)
- Find Path between relationships BAS (01/30/05)
- Comparing Queries? Frustrated with VBA (01/30/05)
- Trouble comparing dates SemperFi 1967 (01/30/05)
- Combo box values Olivier Japson (01/30/05)
- How do I make an "Option" Query Jamie Longmire (01/30/05)
- Problem with Unique Records magmike (01/30/05)
- Limiting Report Results Sheri Emery (01/30/05)
- How do I find the smallest of 4 field values in the same record o. TehraniCHS (01/29/05)
- Limit the query output Palia Weel (01/29/05)
- Simple Query Wizard PinkNeckWoman07_at_aol.com (01/29/05)
- Changing CAPS to Lowercase Sky Warren (01/29/05)
- Identify max date for a sell price SHIPP (01/29/05)
- Odd Files !? al9315 (01/29/05)
- Time passed in Hrs and Min KAnoe (01/29/05)
- Query appends duplicate records, 2 times, 3 times, 4 times etc Randy (01/29/05)
- Using an IIF statement in an Access Query, how can I check if a c. SemperFi 1967 (01/29/05)
- Parsing Data Rob (01/29/05)
- parameter query al9315 (01/29/05)
- parameter al9315 (01/29/05)
- Problem wiht Access runtime on W2003 server hpkrekt (01/29/05)
- Querying data from two fields Steve Hart via AccessMonster.com (01/29/05)
- how to nclude a auto number field in the query. Nagalakshmi.V (01/29/05)
- how to nclude a auto number field in the query. Nagalakshmi.V (01/29/05)
- How to show Name and ID number John K (01/29/05)
- Prior Values owilson (01/29/05)
- Getting the most recent value Anthony Viscomi (01/29/05)
- Wildcard and Not Like Sunryzz (01/28/05)
- Right Join (?)... Jesterhoz (01/28/05)
- AactiveX error with query wizard j (01/28/05)
- Performing Calculations In A Query Kevin (01/28/05)
- RoundUp in a Query? Eric (01/28/05)
- Update remote table from local table chris.ciotti_at_gmail.com (01/28/05)
- Conditional Query Steve Freeman, SuperRealtor (01/28/05)
- Re: Conditional Query Ken Snell [MVP] (01/28/05)
- Re: Conditional Query Steve Freeman, SuperRealtor (01/29/05)
- Re: Conditional Query John Vinson (01/29/05)
- Re: Conditional Query Ken Snell [MVP] (01/29/05)
- Re: Conditional Query Steve Freeman, SuperRealtor (01/29/05)
- Re: Conditional Query Ken Snell [MVP] (01/29/05)
- Re: Conditional Query Steve Freeman, SuperRealtor (01/30/05)
- Re: Conditional Query Ken Snell [MVP] (01/30/05)
- Re: Conditional Query Steve Freeman, SuperRealtor (01/30/05)
- Re: Conditional Query Steve Freeman, SuperRealtor (01/29/05)
- Re: Conditional Query Ken Snell [MVP] (01/28/05)
- Count occurances of specific character in string T Kirtley (01/28/05)
- Re: Count occurances of specific character in string Brendan Reynolds (01/28/05)
- Re: Count occurances of specific character in string T Kirtley (01/28/05)
- Re: Count occurances of specific character in string Brendan Reynolds (01/28/05)
- Re: Count occurances of specific character in string Marshall Barton (01/28/05)
- Re: Count occurances of specific character in string T Kirtley (01/28/05)
- Re: Count occurances of specific character in string Brendan Reynolds (01/30/05)
- Re: Count occurances of specific character in string T Kirtley (01/28/05)
- Re: Count occurances of specific character in string Brendan Reynolds (01/28/05)
- Pivot Charts Donna (01/28/05)
- Custom Field in Query Slows Query Drastically Larry R Harrison Jr (01/28/05)
- Help with WHERE clause in query selecting from queries... Adam Clauss (01/28/05)
- Help with getting average in a query? jacqueline (01/28/05)
- how do I GET ACCESS TO COMPUTER EMPLOYEES ABENCES AFTER EACH INCI. Miss Ann (01/28/05)
- Append fields to another table in same database using a Query and Harrison (01/28/05)
- Don't want duplicate names ClaireView (01/28/05)
- Re: How can I keep an Access append query from chopping off decimal p. [MVP] S.Clark (01/28/05)
- Query help Donna (01/28/05)
- Trincated query field ianc (01/28/05)
- Dups Dan _at_BCBS (01/28/05)
- HELP !!! - export query tool?? MSSQLServerDeveloper (01/28/05)
- Creating Drop Down Menus in a query Jayman (01/28/05)
- How do I filter fields based on date ranges Bryan (01/28/05)
- Pass Thru Qry G (01/28/05)
- "Query is too complex" - limit to number of parameters in query? Scott (01/28/05)
- Week of Year Angus Crossley (01/28/05)
- SQL Time Query GLT (01/28/05)
- How to Insert Records with Incrementing Nos. in a field Michael Miller (01/28/05)
- query data from mixed format field Susan M (01/28/05)
- Exclude characters Ellen (01/28/05)
- Simple Query Paul Murphy via AccessMonster.com (01/28/05)
- converting numbers LJG (01/28/05)
- Update query dk3173 (01/28/05)
- Find days of mixed content Luke (01/28/05)
- Query Criteria Keith Yong via AccessMonster.com (01/28/05)
- Rolling dates. Floyd Forbes (01/28/05)
- remove suppress msaccess internal error messages Patrick Stubbin (01/28/05)
- Complex Querie Gregw (01/28/05)
- Total up different values within same field Seventh (01/27/05)
- Pass thru query to SQL server with parameters MSSQLServerDeveloper (01/27/05)
- Calculating ETA +3 days not to fall on weekends Andi Lee Davis (01/27/05)
- Summing Text fields using NZ function causing error bschuler (01/27/05)
- Query Results Steven Phillips via AccessMonster.com (01/27/05)
- Date between date1 and current date Luke (01/27/05)
- RE: I keep getting a "#Error" Ryan W (01/27/05)
- Sequentially number records in a query, dynamically code (01/27/05)
- Nested IIF Cathy (01/27/05)
- Up to 10 vendors on a trasaction - create a field that indicates . Kerney (01/27/05)
- Re: Up to 10 vendors on a trasaction - create a field that indicates . Chris2 (01/27/05)
- Re: Up to 10 vendors on a trasaction - create a field that indicates . Chris2 (01/27/05)
- Re: Up to 10 vendors on a trasaction - create a field that indicat Kerney (01/27/05)
- Re: Up to 10 vendors on a trasaction - create a field that indicat Chris2 (01/27/05)
- Re: Up to 10 vendors on a trasaction - create a field that indicat Chris2 (01/27/05)
- Re: Up to 10 vendors on a trasaction - create a field that indicat John Vinson (01/27/05)
- Re: Up to 10 vendors on a trasaction - create a field that indicat YYZ (01/28/05)
- Re: Up to 10 vendors on a trasaction - create a field that indicat Chris2 (01/29/05)
- Re: Up to 10 vendors on a trasaction - create a field that indicat YYZ (01/29/05)
- Re: Up to 10 vendors on a trasaction - create a field that indicat Chris2 (01/30/05)
- Re: Up to 10 vendors on a trasaction - create a field that indicat YYZ (01/30/05)
- Re: Up to 10 vendors on a trasaction - create a field that indicates . Chris2 (01/27/05)
- Re: Up to 10 vendors on a trasaction - create a field that indicat Kerney (01/27/05)
- Re: Up to 10 vendors on a trasaction - create a field that indicates . John Vinson (01/27/05)
- Monthly Reports Gregw (01/27/05)
- Monthly Reports GregW (01/27/05)
- Conditional Format? Jim (01/27/05)
- Query returning inaccurate results... Access rookie (01/27/05)
- Re: I want to Retrieve all records for 1st quarter of current year Kevin (01/27/05)
- line numbers and sums david white (01/27/05)
- IF Condition for WEEKDAY AngelMdc3 (01/27/05)
- Re: Convert a number charactor to number, Oracle has to_number, does . Rick B (01/27/05)
- IIF statement Chris (01/27/05)
- Update field from sum(anothertable.anotherfield) YYZ (01/27/05)
- how to convert a text(255) filed to text(100) Convert_Cast (01/27/05)
- Crosstab Query, Group & Sort by Hour in the day MikeZz (01/27/05)
- In Access, How can I set criteria to only choose records NOT cont. schwdm (01/27/05)
- MS Access criteria HELP!! dawnovan71 (01/27/05)
- Caculated field question Sanj (01/27/05)
- Need to merge 3 mdb`s DJJohn (01/27/05)
- Sum Function Inconsistency HWY909 (01/27/05)
- Create New Query using OLE Darren (01/27/05)
- Query to return data if whole months are selected based on week Tim Smith (01/27/05)
- A question about parameter queries Matthew (01/27/05)
- Summaries with zeros Vanessa (01/27/05)
- Update query dk3173 (01/27/05)
- Filtering with < owen wilson (01/27/05)
- Need to say which year to pull Bonnie (01/27/05)
- Like operator refering to fields pezza88 (01/27/05)
- Calculating number of days left ot my birthday Keith Yong via AccessMonster.com (01/27/05)
- pass-through-query and stored procedure Jason (01/27/05)
- Group by query with count of each group under a condition ifiaz (01/27/05)
- On time and how much has elapsed: how do I Calculate elapsed time. Fgrizz (01/27/05)
- Query for No Value in Field David S. Calef (01/27/05)
- Days Between date1 and current date Luke (01/27/05)
- date language error rak2421 (01/27/05)
- Union query is displaying Chinese characters for one of the fields Seth Schwarm (01/27/05)
- Convert Coordinates Frustrated with VBA (01/27/05)
- RE: Convert Coordinates Seth Schwarm (01/27/05)
- RE: Convert Coordinates Frustrated with VBA (01/27/05)
- RE: Convert Coordinates Seth Schwarm (01/27/05)
- RE: Convert Coordinates Frustrated with VBA (01/27/05)
- RE: Convert Coordinates Seth Schwarm (01/27/05)
- RE: Convert Coordinates Frustrated with VBA (01/27/05)
- RE: Convert Coordinates Seth Schwarm (01/27/05)
- RE: Convert Coordinates Frustrated with VBA (01/27/05)
- RE: Convert Coordinates Seth Schwarm (01/27/05)
- RE: Convert Coordinates Frustrated with VBA (01/27/05)
- Re: Convert Coordinates John Vinson (01/27/05)
- RE: Convert Coordinates Seth Schwarm (01/27/05)
- How do I detect #NUM! in a Query? Woodie (01/27/05)
- query column headings Patrick Stubbin (01/27/05)
- datediff question Rob S (01/27/05)
- Extract part of existing text Bernice (01/26/05)
- Simple Date Query Joe Spenceley (01/26/05)
- Delete Query Error Luke Bailey (01/26/05)
- Truncation of memo fields in SELECT queries - Access 2002 datawizzard (01/26/05)
- Help in solving queries....... Patrick (01/26/05)
- Crosstab query and formatted date SMac (01/26/05)
- query to split fields into multiple rows? bu (01/26/05)
- I have a new Dell. I installed Picture it Platinum v2002. When I o john (01/26/05)
- ADding a record in the subform Sansanee (01/26/05)
- help with query, syntax error in my join helpmeplease (01/26/05)
- Auto Calculate StartDate from EndDate in Access Queries using Bet. Mike Walker (01/26/05)
- Blank field don't "act" like they are blank Kris (01/26/05)
- My Access query doesn't pull all required records Nolzgirl (01/26/05)
- Passing Text Box Values to a Stored Procedure Johnny98 (01/26/05)
- Date Sorting c (01/26/05)
- SQL statement smk23 (01/26/05)
- Entering Criteria to get desired results Crystal (01/26/05)
- how do I create query that receives user input from a form? Vincent Summers (01/26/05)
- Need this year and last year records Bonnie (01/26/05)
- Syntax ARRRGH!!! cansoft (01/26/05)
- Append query appends twice. Why? Kerman (01/26/05)
- Re: Append query appends twice. Why? Sylvain Lafontaine (01/26/05)
- Another comment Appends twice, three, four times etc. Kerman (01/26/05)
- Re: Another comment Appends twice, three, four times etc. JohnFol (01/27/05)
- Re: Another comment Appends twice, three, four times etc. Randy (01/27/05)
- Re: Another comment Appends twice, three, four times etc. JohnFol (01/27/05)
- Re: Another comment Appends twice, three, four times etc. Randy (01/27/05)
- Re: Another comment Appends twice, three, four times etc. Sylvain Lafontaine (01/27/05)
- Another comment Appends twice, three, four times etc. Kerman (01/26/05)
- Re: Append query appends twice. Why? Sylvain Lafontaine (01/26/05)
- Display Last 4 Digits Error JBL (01/26/05)
- Query Report finster26 (01/26/05)
- Crosstab - Sort by Aggregate c (01/26/05)
- Parameter Queries tinab (01/26/05)
- Week number in a year Pele (01/26/05)
- Change seconds to hhh:nn:ss F Jones (01/26/05)
- Create records based on Field Value Dirtbike (01/26/05)
- Count events in several time frames Kevin (01/26/05)
- Insert Character 1 character from right P Brainard via AccessMonster.com (01/26/05)
- Query asking for date paramter query twice for no apparent reason Dkline (01/26/05)
- Re: Query asking for date paramter query twice for no apparent reason Allen Browne (01/27/05)
- Re: Query asking for date paramter query twice for no apparent reason Dkline (01/27/05)
- Re: Query asking for date paramter query twice for no apparent reason Allen Browne (01/27/05)
- Re: Query asking for date paramter query twice for no apparent reason Dkline (01/27/05)
- Re: Query asking for date paramter query twice for no apparent reason Allen Browne (01/27/05)
- Re: FOLLOWUP Question Dkline (01/28/05)
- Re: FOLLOWUP Question Allen Browne (01/28/05)
- Re: Query asking for date paramter query twice for no apparent reason Dkline (01/27/05)
- Re: Query asking for date paramter query twice for no apparent reason Allen Browne (01/27/05)
- ODBC & DISTINCT Terry (01/26/05)
- Need Query to return record even if Count=0 Dkline (01/26/05)
- Top X Values Per Quarter FrankTimJr (01/26/05)
- Crosstab - ORDER BY c (01/26/05)
- Delete Duplicates in a table Steve Welman (01/26/05)
- The Microsoft Jet engine does not recognise 'Red' as a valid field name or expre Paul kelly via AccessMonster.com (01/26/05)
- How to pass date parameter to query via VBA ? Kalle via AccessMonster.com (01/26/05)
- Perfomring calculations on rows in a query! Phil (01/26/05)
- Can't drag tables in relationships view WC (01/26/05)
- table update JRS (01/26/05)
- Updating field in access 2000. dk3173 (01/26/05)
- adding to union query rudwan (01/26/05)
- Distributing Figures rudwan (01/26/05)
- Problem with Query By Form Scott (01/26/05)
- Parameter Queries tinab (01/26/05)
- Setting the Control source of a textbox to a query based on the value of another textbox on the same form Joey (01/26/05)
- week of the month binnie pillai (01/26/05)
- Optimizing multiple rows storing into Access 2003. Need Help! yachea2002_at_hotmail.com (01/25/05)
- Complicated Query DavidS (01/25/05)
- Like keyword Patrick (01/25/05)
- Memo Truncation in Query Larry (01/25/05)
- Multiple Parameters Melinda (01/25/05)
- Message error: 3051? Gina (01/25/05)
- How do I total up a column? Gina (01/25/05)
- Re: sql minus tyme4help (01/25/05)
- Trim Statement James C. (01/25/05)
- outer join syntax agenda9533 (01/25/05)
- reverse a string Mark (01/25/05)
- Just one week. KAnoe (01/25/05)
- unmatched data hobart (01/25/05)
- How to create checkbox in make table query sharper (01/25/05)
- merging two fields in a table JRS (01/25/05)
- Automatically Move Records Sheri Emery (01/25/05)
- Run Query from date to date, Print the from date to date in the header of the report? Dustin Swartz (01/25/05)
- need help..(WHERE.....OR (Right(original_missing.field2,6) = Righ. helpmeplease (01/25/05)
- Date Grouping Query Kenny Holden (01/25/05)
- Error Linking Or Importing Data from Excel Rocky (01/25/05)
- Add a character within text field P Brainard via AccessMonster.com (01/25/05)
- how do you count instances within a field tgl (01/25/05)
- Cross tab query for chart Zegrath (01/25/05)
- Function In Column Header Jason Silva (01/25/05)
- Problem with Embedded Procedure and Windows XP/Access David Wilson (01/25/05)
- Operation must use an updateable query NZC (01/25/05)
- Query based on a Date Range mccloud (01/25/05)
- Crosstab Query Excluding Data Greg (01/25/05)
- How do I use expressions (like "Or") in parameter prompts? Ricky Rock (01/25/05)
- Complex search on a relationship Gonzalo Moreno via AccessMonster.com (01/25/05)
- Forms and Queries Sean (01/25/05)
- Wildcard in append query Mary Fran (01/25/05)
- Query performance on external data emerb (01/25/05)
- Opening Link from textbox Rudi Groenewald (01/25/05)
- DLookup Problem Steve Voorhees (01/25/05)
- aggregate functions Sayanta (01/25/05)
- Iif statement in SQL append query? Randy (01/25/05)
- Query criteria from form incorrect Jim T. (01/25/05)
- Select record 101 to 200 ??? Joe M (01/25/05)
- Queries fail for certain users on certain machines Jeff Vandervoort (01/25/05)
- How do I update specific records in a Access table with data from. Kerney (01/25/05)
- Re: How do I update specific records in a Access table with data from. The Goulds (01/25/05)
- Re: How do I update specific records in a Access table with data from. John Vinson (01/25/05)
- Re: How do I update specific records in a Access table with data f Kerney (01/25/05)
- Re: How do I update specific records in a Access table with data f John Vinson (01/25/05)
- Re: How do I update specific records in a Access table with data f Kerney (01/25/05)
- Re: How do I update specific records in a Access table with data f Kerney (01/25/05)
- Re: How do I update specific records in a Access table with data f John Vinson (01/25/05)
- Re: How do I update specific records in a Access table with data f Kerney (01/26/05)
- Re: How do I update specific records in a Access table with data f John Vinson (01/26/05)
- Re: How do I update specific records in a Access table with data f Kerney (01/26/05)
- Re: How do I update specific records in a Access table with data f John Vinson (01/27/05)
- Re: How do I update specific records in a Access table with data f Kerney (01/25/05)
- Re: How do I update specific records in a Access table with data f Kerney (01/25/05)
- Parameter Queries Francis Cunningham, Jr. (01/25/05)
- Combining records with same identifier AGB (01/24/05)
- Field names Patrick Stubbin (01/24/05)
- Follow Up Question to MVP Reynolds on Splitting Fields KCAtkins (01/24/05)
- Re: Follow Up Question to MVP Reynolds on Splitting Fields Ken Snell [MVP] (01/24/05)
- Re: Follow Up Question to MVP Reynolds on Splitting Fields Brendan Reynolds (01/24/05)
- RE: Follow Up Question to MVP Reynolds on Splitting Fields KCAtkins (01/25/05)
- sending email through stored procedure Patrick (01/24/05)
- Re: What am I doing wrong here? zladnaj (01/24/05)
- RE: limit output of query to the last 7 days MarySue (01/24/05)
- Parameter queries Frank (01/24/05)
- Passing Criteria to a Query LisaB (01/24/05)
- Column Totals in Query PawleysGrits (01/24/05)
- Date calculations Catcdcla (01/24/05)
- Last Service Date Curt Wedbush (01/24/05)
- NZ([value],0) query export & Calculations Dan (01/24/05)
- Best way to filter/query many fields G (01/24/05)
- Make Table Query neenmarie (01/24/05)
- Query to look at other rows Alex (01/24/05)
- Calculations from two different Records? Brad (01/24/05)
- Renumbering AUTONUMBER fields-existing data Dennis (01/24/05)
- Delete Query v Could not Delete from Specified tables Foxman (01/24/05)
- Working with Calendar Days GLT (01/24/05)
- Start & End Date Columns - Need to extract anything that is Date() GLT (01/24/05)
- printing JANE Gunton via AccessMonster.com (01/24/05)
- Find an account peroid johnb (01/24/05)
- Access Queries David Oakey (01/24/05)
- Compare two table fields for EXACT match Quan (01/24/05)
- weird query situation, need help! Jerome (01/24/05)
- MakeTable decimal places Lindak (01/24/05)
- primary key programatically New TO Access (01/24/05)
- Update field based on aggregate fn on another field Anna S (01/24/05)
- How to create a query based on an existing value in a form field Anthony (01/24/05)
- Delete Query based on the results of another query DBsolutions (01/24/05)
- Lost e-mails ... Ken (01/24/05)
- Filter a query by date in another table? Noozer (01/23/05)
- DBASE IV Account Number Problem G (01/23/05)
- Yes,Yes,Yes,Yes,Yes,Yes! in a query paul.hoyle (01/23/05)
- join issue with query JRS (01/23/05)
- how to get more than 512 characters in a memo type field from a fo frank tries access (01/23/05)
- SQL criteria for deleting one table from another Quan (01/23/05)
- Using GUID in a query sharper (01/23/05)
- null to zero access 2.0 melanie (01/23/05)
- customer survey summary jnj (01/23/05)
- Copy a query in Access tmason (01/23/05)
- Using IIF to set Lunch or Dinner Lee E. Johnson (01/23/05)
- Query Wizard not linking tables Stranger (01/23/05)
- How to do intersect and except sql operators in access? Steve (01/22/05)
- How do I use a list for a parameter in a query rather than typing. scoz (01/22/05)
- Office 97 Bruce (01/22/05)
- Simple Concatonated Primary Key Question The parawon (01/22/05)
- "Screen Scrape" PC Datasheet (01/22/05)