microsoft.public.access.queries
By Thread
3349 messages sorted by: [ date ]
Starting: 01/31/04
Ending: 02/29/04
- Date in query Michael Hanlon (02/29/04)
- Writing a Query based on Day of Week Alan Balthrop (02/29/04)
- query not working Bhavna (02/29/04)
- Passing variables to Query Criteria, Can anyone help with this? Eric (02/29/04)
- Mail merging multiple fields from single lookup table into word via query Simon Bloor (02/29/04)
- select 2nd - 5th records? jim (02/29/04)
- time calulations Kenneth John Howie (02/29/04)
- Day count calculation? JayKay (02/29/04)
- Report Overflow Error Brandon M (02/29/04)
- search query by date flic (02/29/04)
- URGENT Microsoft Access Inquiry Kathy Areshenko (02/28/04)
- Iif statement again RAB (02/28/04)
- Using Variables in an INSERT INTO query Lee (02/28/04)
- FORMAT and TRIM not working on one lap top Pam (02/28/04)
- Alot to ask but can you explain? Leroy (02/28/04)
- Query - Filter Duplicates Problem (Easy?) Nitrogen666 (02/28/04)
- "Make Query by Form" Rob (02/28/04)
- Parameter Query Mudassir Iqbal (02/28/04)
- Object variable or With block variable not set (??) Lee (02/28/04)
- Query's returning values that are double HWylie (02/28/04)
- date() Harmannus (02/28/04)
- Query expression needed to edit data BobV (02/28/04)
- Sum Martin (02/28/04)
- product key mikey (02/28/04)
- Update field on form after one field is chosen DJ UDX (02/28/04)
- Drop Down List in Query Gee (02/27/04)
- INSERT: Text field with single- and double-quotes RSGinCA (02/27/04)
- Multiple records Martin (02/27/04)
- Joins... Urgent Mudassir Iqbal (02/27/04)
- export table JIM.H. (02/27/04)
- Join a concatenated field Aaron (02/27/04)
- SQL to Calculate Balances Kirk P. (02/27/04)
- Converting number data to mm:ss format cb (02/27/04)
- Expression works in one part of report not another Jonathan Stratford (02/27/04)
- Help.... Adding/ Sorting Mojo (02/27/04)
- Full Outer Joins Mike Olson (02/27/04)
- Testing to see if a query is open Philippe (02/27/04)
- Calculating pace for a query deckard (02/27/04)
- Re: Calculating pace for a query John Vinson (02/28/04)
- Re: Calculating pace for a query Deckard (02/28/04)
- Re: Calculating pace for a query John Vinson (02/28/04)
- Re: Calculating pace for a query deckard (02/28/04)
- Re: Calculating pace for a query John Vinson (02/28/04)
- Re: Calculating pace for a query deckard (02/28/04)
- Re: Calculating pace for a query John Vinson (02/29/04)
- Re: Calculating pace for a query anonymous_at_discussions.microsoft.com (02/29/04)
- Re: Calculating pace for a query Deckard (02/28/04)
- Re: Calculating pace for a query John Vinson (02/28/04)
- leading zero's were lost anonymous_at_discussions.microsoft.com (02/27/04)
- Rounding Down Louis (02/27/04)
- Automated Import dwa (02/27/04)
- Error Emailing query in Macro KLang (02/27/04)
- Find Unmatched Query Wizard Problem hcbph (02/27/04)
- Removing carriage returns James (02/27/04)
- Query for quotes, is this possible? Julia S. (02/27/04)
- Missing in sequence query Daniel P (02/27/04)
- How to get data in a form from different records out of a query ? Pandora (02/27/04)
- Enter parameter once for multiple queries in a Macro Randal (02/27/04)
- Access Query Rich (02/27/04)
- Run queries made by code Ari A (02/27/04)
- Finding duplicate memo fields? Daniel P (02/27/04)
- LIKE help Mike C (02/27/04)
- Dates Without Years Michael (02/27/04)
- Maximum number of "or" statements in a select query Ricardo (02/27/04)
- Oracle connection dropped Pam (02/27/04)
- Query using module variable finster26 (02/27/04)
- Wild Card Concatenation With User Input Roy (02/27/04)
- DSum Alan (02/27/04)
- Crosstab query with date problem Some Guy (02/27/04)
- Help me please before I go insane MissKirin (02/27/04)
- Thanks Troy (02/27/04)
- Crazy Join Statement xcube (02/27/04)
- Qry-data format issue Betrock52 (02/27/04)
- Products not on master file Brian (02/27/04)
- Inherited problem joining tables on more than one field. DS (02/27/04)
- problems with 'group by' result in select query warbler (02/27/04)
- Crosstab Column Sum - Impossible?? Carrie (02/27/04)
- Very strange Update query needed Richardson (02/26/04)
- Data Tyep Mismatch - Run Time Error DG (02/26/04)
- What query works in place of LEAST and GREATEST Cross-eyed (02/26/04)
- What query works in place of LEAST and GREATEST Cross-eyed (02/26/04)
- Multiple data Update James (02/26/04)
- Export date field w/out time data Sming (02/26/04)
- Saving Querys Beth (02/26/04)
- Pages George Schneider (02/26/04)
- Quarter/Year Tracy (02/26/04)
- Access 2000 problem Gregg (02/26/04)
- > 0 Gee (02/26/04)
- Wild Card Concatenated with User Input Roy (02/26/04)
- Can an update query do this? Gary (02/26/04)
- 5 last entries Lars Rønning (02/26/04)
- Query for lowercase characters Al K (02/26/04)
- update query for postal code Chris (02/26/04)
- Create a table Alex (02/26/04)
- APPEND QUERY EXCLUDE NULLS BDP (02/26/04)
- Duplicate field values in 2 tables Ed (02/26/04)
- query(static ??) macamarr (02/26/04)
- Date Diff in a query or form Reesey (02/26/04)
- Display Rows as Columns in Query Result Charles Law (02/26/04)
- Function is not available in expressions Allan (02/26/04)
- Duplicate Update Problem Kevin C. (02/26/04)
- Pass Thru Query Ross (02/26/04)
- Converting Select Query to Make Table in Code Kitty (02/26/04)
- Integer Query Fred W (02/26/04)
- Query same field from multiple records Bruce Pyett (02/26/04)
- Simple Search? (Oxymoron) Troy (02/26/04)
- Query Help Beth (02/26/04)
- At most one record can be returned by this subquery... ScottA (02/26/04)
- Rounding numbers to thousands Mike (02/26/04)
- sort problem in a report!!!! urgent geo (02/26/04)
- Past 12 Months ShrekUT (02/26/04)
- Past 12 Months ShrekUT (02/26/04)
- Semi-Duplicate Records LeightonS (02/26/04)
- Change entry query Daniel P (02/26/04)
- Query Across Two Databases GrahamC (02/26/04)
- latest record query Barnaby (02/26/04)
- Find bookings for a date SimonDeLikeable (02/26/04)
- Re: Find bookings for a date Maciek Paras (02/26/04)
- Re: Find bookings for a date SimonDeLikeable (02/26/04)
- Re: Find bookings for a date Maciek Paras (02/26/04)
- Re: Find bookings for a date SimonDeLikeable (02/26/04)
- Re: Find bookings for a date Maciek Paras (02/26/04)
- Re: Find bookings for a date diarmuidq (02/27/04)
- Re: Find bookings for a date JasonS (02/27/04)
- Re: Find bookings for a date SimonDeLikeable (02/27/04)
- Re: Find bookings for a date SimonDeLikeable (02/26/04)
- Re: Find bookings for a date Maciek Paras (02/26/04)
- About to give up..... on coding a query Alp Bekisoglu (02/26/04)
- Events for navigation buttons Comet Developer (02/26/04)
- Error 3061 (Too few parameters, Expected 1) ??? Alp Bekisoglu (02/26/04)
- Multiple criteria searches Neil (02/26/04)
- Mutiple table query Lance (02/26/04)
- Crosstab query Jim Jones (02/26/04)
- Simple Update Query Azad (02/26/04)
- Is this the right way Ian Baker (02/26/04)
- help with sub select -urgent - please sean (02/26/04)
- Can I query where the table name will change? B Nieds (02/26/04)
- Repost: Query Return Criteria Bryan Hughes (02/26/04)
- query problem toby (02/26/04)
- Query Problem Bryan Hughes (02/26/04)
- SQL Type conversion in MSAccess 2002 Pierre (02/26/04)
- .runsql works / .execute fails? help appreciated ms (02/26/04)
- Select Update and Export Unique Values Craig Ferrier (02/25/04)
- Append and make table concatenates memo fields John (02/25/04)
- Test SQL Statements Jack (02/25/04)
- Queries? Dave (02/25/04)
- Why is DAO.QueryDef is so slow Richard (02/25/04)
- Access 2.0 Terry Blakley (02/25/04)
- Need help with query Attila Fust (02/25/04)
- Date plus 30 days TToy (02/25/04)
- ADO use to show Query Results chrisstrachan_at_msn.com (02/25/04)
- query, subquery, ODBC to DB2 mainframe; all in one! Works, but why so SLOW! Barbara Grace (02/25/04)
- Update query strips leading zero from text Todd Lemen (02/25/04)
- Combining a field in multiple records into a single memo field Jim T. (02/25/04)
- Combine multiple rows into single row with sql Rajesh B. Patel (02/25/04)
- Most recent date Stephanie (02/25/04)
- refresh a query Tsevy (02/25/04)
- Query statement syntax Josh W (02/25/04)
- Query Logic Problem! alwayshouston (02/25/04)
- Formatting dates Malche (02/25/04)
- Function to look for similiar text TammyG (02/25/04)
- Function to look for similiar text TammyG (02/25/04)
- Runtime Version of Access 2002? Where? Tom Burton (02/25/04)
- Sort by Month Alex (02/25/04)
- PHP Scripting Tommy Addison (02/25/04)
- How do I define field types Cherie (02/25/04)
- create new records from udate query HeatherBee (02/25/04)
- Query too complex JPM (02/25/04)
- Function is not available in query expressions WBDavis (02/25/04)
- "Constant" value in SELECT query? jwkratz (02/25/04)
- CREATE VIEW? dwa (02/25/04)
- Using SUM in query Tor Inge Rislaa (02/25/04)
- Combining Data that is not the same date Jerry (02/25/04)
- DateDiff Sam (02/25/04)
- Month Range George Schneider (02/25/04)
- Combining fields from multiple records into a single memo field Jim T. (02/25/04)
- "External table not in expected format" amber (02/25/04)
- Avoid duplicate entry dawn (02/25/04)
- Clear contents ofg a field after ticking a check box David Sullivan (02/25/04)
- SUM 15+ fields based on Date & Location Vince (02/25/04)
- Query to Access : does'nt see tables Vuillermet Jacques (02/25/04)
- Querying changes over time GPO (02/25/04)
- Help plz..........? KRISH (02/25/04)
- Sub Select Help sean (02/25/04)
- ADDING Amount to get ONE TOTAL~! Vince (02/25/04)
- number of digits anonymous (02/25/04)
- blank date Colleen (02/24/04)
- Calculate short time Bob (02/24/04)
- conditional formatting of date in query amanda redmond-neal (02/24/04)
- linking tables where data-type is not equal dd (02/24/04)
- Access is incorrectly rounding numbers that end w/ .50 down Tim (02/24/04)
- Rounding Numbers UP Damian Raine (02/24/04)
- access query David Carolla (02/24/04)
- "Constant" value placed in all records? jwkratz (02/24/04)
- "Constant" value placed in all records? jwkratz (02/24/04)
- "Constant" value placed in all records? jwkratz (02/24/04)
- Overflow Error Message CC (02/24/04)
- Query Newbie (02/24/04)
- Union Query issue DBarker (02/24/04)
- preserving the sql format mario (02/24/04)
- Expression Builder Cyd (02/24/04)
- update query error Bob Hughes (02/24/04)
- AbsSum Won't Work With Null Values mike (02/24/04)
- Re: AbsSum Won't Work With Null Values Roger Carlson (02/24/04)
- Re: AbsSum Won't Work With Null Values mike (02/24/04)
- Re: AbsSum Won't Work With Null Values John Spencer (MVP) (02/25/04)
- Re: AbsSum Won't Work With Null Values mike (02/25/04)
- Re: AbsSum Won't Work With Null Values John Spencer (MVP) (02/25/04)
- Re: AbsSum Won't Work With Null Values Bas Cost Budde (02/25/04)
- Re: AbsSum Won't Work With Null Values John Spencer (MVP) (02/28/04)
- Re: AbsSum Won't Work With Null Values mike (02/26/04)
- Re: AbsSum Won't Work With Null Values mike (02/24/04)
- Re: AbsSum Won't Work With Null Values Roger Carlson (02/24/04)
- dates anonymous_at_discussions.microsoft.com (02/24/04)
- Quartile Calculation - from a Newbie Rob (02/24/04)
- running a query to compare 2 date fields jaberwocky (02/24/04)
- running a query to compare 2 date fields jaberwocky (02/24/04)
- running a query to compare 2 date fields jaberwocky (02/24/04)
- Proper Case Al (02/24/04)
- Special Crosstab mj (02/24/04)
- Counting Offices Jim Johnson (02/24/04)
- Counting Offices Jim Johnson (02/24/04)
- Multiple Prints Paul R (02/24/04)
- Simple select query problem Bill (02/24/04)
- Correct SQL in Code Please Chipmunkwhiz (02/24/04)
- Re: Autonumber in Query Daniel P (02/24/04)
- In Crosstab Query If Any Values Are Null I Want Sum to Be Null mcl (02/24/04)
- Query objects Irine (02/24/04)
- Recordset Jeroen Verdrengh (02/24/04)
- Concatenating Numbers/Converting Dates to Integers grrr223 (02/24/04)
- Concatenating Numbers/Converting Dates to Integers grrr223 (02/24/04)
- Concatenating Numbers/Converting Dates to Integers grrr223 (02/24/04)
- Proper Case APH (02/24/04)
- Overflow (Error when running a query) WaterBrook (02/24/04)
- Removing Input Masks mec (02/24/04)
- Parameter Query - Action Query VBA Coder (02/24/04)
- Top Values Question (02/24/04)
- Removing weekends from a date range Kent Prokopy (02/24/04)
- FYI - Sql for splitting a delimited concatenated string into separate strings/rows. Dr. StrangeLove (02/24/04)
- IIF SQL 2002 Ed Wiancko (02/24/04)
- Retrieve most recent date. Chiral (02/24/04)
- Create numbering JA (02/24/04)
- Multiple outer joins in access Patrick Ryan (02/24/04)
- Access reserved error, Access2002. Kenneth Miles (02/24/04)
- Query Problem Jeremy Dove (02/24/04)
- Finding One Example From Several Categories T. Wilson (02/24/04)
- an unusual query? Nicholas Steinhoff (02/24/04)
- IF in T-SQL Column Expression grrr223 (02/24/04)
- IF in T-SQL Column Expression grrr223 (02/24/04)
- updating (using a unbound box on a diff form) _Bigred (02/23/04)
- SQL subquery problem - bookings database Dan Evans (02/23/04)
- Query to group mostly-alike rows Dean Landry (02/23/04)
- Multiple instances Exaviour (02/23/04)
- Access 97 Reference Books Nancy (02/23/04)
- Proper Case Jaymes (02/23/04)
- numerical value of text Ken L (02/23/04)
- Latest Date Query Daniel P (02/23/04)
- Error 3163 Couldn't Insert or Paste; Data Too Long for Field Rick (02/23/04)
- Output month as name George Schneider (02/23/04)
- Action Query?? MurrayK (02/23/04)
- Action Query?? MurrayK (02/23/04)
- More query help needed! Fred W (02/23/04)
- Date Query Laura (02/23/04)
- Using data from global variable in SQL statement T. (02/23/04)
- Archive data from joined tables to joined tables Eric Hubert (02/23/04)
- Changing Data Format E. Ehrhard (02/23/04)
- to add a # of days... not including holidays/weekends Aaron (02/23/04)
- problem creating a query that searches for field created by control source Buddy (02/23/04)
- Query anonymous_at_discussions.microsoft.com (02/23/04)
- Parameter Query with a Condition Nick (02/23/04)
- Division in an expression Sonja (02/23/04)
- assigning values to dates Tara (02/23/04)
- Showing Total in design anonymous_at_discussions.microsoft.com (02/23/04)
- One Select 2 databases Nigel Findlater (02/23/04)
- Re: query separation sheetal (02/23/04)
- I am confused on a querry mario (02/23/04)
- Querying from the same table Em (02/23/04)
- Can you refer to a variable in a hard query? Dean Spiker (02/23/04)
- Query Kim (02/23/04)
- Word Wrap Daniel P (02/23/04)
- Make Table Query v Select Query MIke Collard (02/23/04)
- Top Values Randal (02/23/04)
- table contents to string Jeroen Verdrengh (02/23/04)
- combo box based on text box value val (02/23/04)
- how do you filter a query-generated sub-form? Paul Simon (02/23/04)
- Combo box Lachie Thomas (02/23/04)
- query between macamarr (02/23/04)
- Missing Records Trevor (02/23/04)
- using a unbound text box date in query with calculation _Bigred (02/23/04)
- Update Query Overwrite? Brandon M (02/22/04)
- Re: Update Query Overwrite? Brandon M (02/22/04)
- Re: Update Query Overwrite? Ken Snell (02/22/04)
- Re: Update Query Overwrite? Brandon M (02/22/04)
- Re: Update Query Overwrite? Ken Snell (02/22/04)
- Re: Update Query Overwrite? Brandon M (02/22/04)
- Re: Update Query Overwrite? Ken Snell (02/22/04)
- Re: Update Query Overwrite? Brandon M (02/22/04)
- Re: Update Query Overwrite? Ken Snell (02/23/04)
- Re: Update Query Overwrite? Brandon M (02/23/04)
- Re: Update Query Overwrite? Ken Snell (02/24/04)
- Re: Update Query Overwrite? Brandon M (02/24/04)
- Re: Update Query Overwrite? Ken Snell (02/25/04)
- Re: Update Query Overwrite? Brandon M (02/22/04)
- Maximum Number of Tables in Union - Jet Mike (02/22/04)
- Address all in one field kenneth_lad (02/22/04)
- calculate the interest on an amount a person owes Dave B (02/22/04)
- Email Validate Robert Raley (02/22/04)
- How to define a unique index over two fields in an Access table? Jarek (02/22/04)
- Create Query for mathing data Roy Goldhammer (02/22/04)
- Comparison Query? Don (02/22/04)
- Proper Function Robert Raley (02/22/04)
- copying a field value to another table with a form Maarten (02/22/04)
- don't know what exactly is wrong Chris Ellis (02/22/04)
- Date Range causing ill effects? Gary De Velder (02/22/04)
- Determining the most recent record T. Wilson (02/22/04)
- Toolbars KA (02/22/04)
- query I did not explaine correctly Dawn (02/22/04)
- access2002 Dawn (02/22/04)
- Querying a memo type field fjt (02/21/04)
- Manipulating table records Eric G (02/21/04)
- Re: Manipulating table records Rick Brandt (02/21/04)
- Re: Manipulating table records Eric G (02/22/04)
- Re: Manipulating table records John Vinson (02/22/04)
- Re: Manipulating table records Eric G (02/22/04)
- Re: Manipulating table records John Vinson (02/22/04)
- Re: Manipulating table records Eric G (02/22/04)
- Re: Manipulating table records John Vinson (02/23/04)
- Re: Manipulating table records Eric G (02/23/04)
- Re: Manipulating table records Jeffrey Williams (02/23/04)
- Re: Manipulating table records Eric G (02/23/04)
- Re: Manipulating table records John Vinson (02/23/04)
- Re: Manipulating table records Eric G (02/23/04)
- Re: Manipulating table records TheBigSmellyOgre (02/24/04)
- Re: Manipulating table records John Vinson (02/24/04)
- Re: Manipulating table records TheBigSmellyOgre (02/24/04)
- Re: Manipulating table records Eric G (02/22/04)
- Re: Manipulating table records Rick Brandt (02/21/04)
- Drop Down Selection In Query Michael Healan (02/21/04)
- Error-"function isn't available in expressions in query expression 'Left([LNAME],4)' Doris Rush-Lopez (02