microsoft.public.access.queries
By Thread
3789 messages sorted by: [ date ]
Starting: 09/30/04
Ending: 10/31/04
- When I print pages from Access Query, lines do not appear, even t. JenGlass (10/31/04)
- Help on a query based on the latest date Joe Cilinceon (10/31/04)
- controls on form not totaling when there is no amount Gale (10/31/04)
- Supressing Splashscreen Spammastergrand (10/31/04)
- Help, please about - must use updateable query statement SLW526 (10/31/04)
- Ranking query Leslie Isaacs (10/31/04)
- Design view input???? Phil (10/31/04)
- Crosstab Query Problem sam (10/31/04)
- Crosstab criteria problem sam (10/31/04)
- Apend table problem Min (10/31/04)
- Newbie question regarding text strings V Chandra (10/31/04)
- How stop access query from replacing our SQL code Suzi Carr (10/31/04)
- MDE? Need to destribute db to users who don't have Access R. Choate (10/30/04)
- Very Complex Query Problem... Gary B (10/30/04)
- Query question Bri (10/30/04)
- Delete data with criteria in different table Dennis Cheung (10/30/04)
- More apostophe headaches in StrSQL statement--The dreaded runtime error 3134 Richard Hollenbeck (10/30/04)
- Filtering same items in list ILIR ISTREFI (10/30/04)
- Stumped for solution Hugh (10/30/04)
- Query problem, Please help! Min (10/30/04)
- Conditional consolidation of two fields down to one Sam Carleton (10/30/04)
- DSum for running daily total of hrs jonefer (10/29/04)
- Unable to edit fields on forms after refreshing table link Andi (10/29/04)
- Unable to edit forms data after refreshing a linked table Andi (10/29/04)
- Access NEEDS to have a median function. PRSAMA (10/29/04)
- Have detail records, want to group on one field get totals of oth. David (10/29/04)
- Optimizing join queries with indexes. Brenda (10/29/04)
- selecting distinct fields in a record Jerry Crosby (10/29/04)
- Limiting Rows Raj (10/29/04)
- SQL Linked Tables in MS Access Michael (10/29/04)
- Amount NOT Found... Gary B (10/29/04)
- Complex Query... I think Access Lover (10/29/04)
- How do I check the query record count from a macro? Robert_L_Ross (10/29/04)
- On Close Query Should Prompt To Save GirlInfo (10/29/04)
- Newbie help: sql string conversion steve (10/29/04)
- Misc Time dlemarr (10/29/04)
- Create/Save Query on the Fly Ed Ardzinski (10/29/04)
- Complex Query...Maybe Access Lover (10/29/04)
- Append query (More than one Value at a time) mark (10/29/04)
- Complex Query... I think! Access Lover (10/29/04)
- Complex Query...I think Access Lover (10/29/04)
- Advanced query building??? (new to Access) neills (10/29/04)
- Access time range query w/user input prompt and SQL datasource MRFannon (10/29/04)
- Query to count check boxes Telobamipada (10/29/04)
- Access 2003 help says you can do full outer join, but user interf. John Irwin (10/29/04)
- find non-matching records, sort of needlewomyn (10/29/04)
- only 255 characters in memofield Ron (10/29/04)
- Soundex Function Fabio (10/29/04)
- Query 365 days or 12 months V. Terry (10/29/04)
- Query last 365 days or 12 mo. V. Terry (10/29/04)
- Creating a numeric sequence within a date sequence Jeremy King (10/29/04)
- Getting the High and Low Tides from a Series of Data Herbert Chan (10/29/04)
- Re: Getting the High and Low Tides from a Series of Data Ken Snell [MVP] (10/29/04)
- Re: Getting the High and Low Tides from a Series of Data Bernie Deitrick (10/29/04)
- Re: Getting the High and Low Tides from a Series of Data Michel Walsh (10/29/04)
- Re: Getting the High and Low Tides from a Series of Data Bernie Deitrick (10/29/04)
- Re: Getting the High and Low Tides from a Series of Data Michel Walsh (10/29/04)
- Re: Getting the High and Low Tides from a Series of Data Herbert Chan (10/29/04)
- Re: Getting the High and Low Tides from a Series of Data Michel Walsh (10/29/04)
- Re: Getting the High and Low Tides from a Series of Data Michel Walsh (10/29/04)
- Re: Getting the High and Low Tides from a Series of Data Bernie Deitrick (10/29/04)
- extracting everything from the db on specific ID steven scaife (10/29/04)
- Bound Form and triggers - Write Conflict Angela Law (10/29/04)
- Make table queries wheelz (10/29/04)
- scrolling in a Form Jyotsna (10/29/04)
- Multiple Table Creation in Access GK Tripathy (10/29/04)
- How to select between a range of dates? 04Ram (10/29/04)
- Crosstab Report Totals Formatting Petra (10/29/04)
- Query To Find Records As Of Specified Date Sue (10/29/04)
- Re: Query To Find Records As Of Specified Date deko (10/29/04)
- Re: Query To Find Records As Of Specified Date Sue (10/29/04)
- Re: Query To Find Records As Of Specified Date deko (10/29/04)
- Re: Query To Find Records As Of Specified Date Sue (10/29/04)
- Re: Query To Find Records As Of Specified Date deko (10/29/04)
- Re: Query To Find Records As Of Specified Date deko (10/29/04)
- Re: Query To Find Records As Of Specified Date Sue (10/29/04)
- Re: Query To Find Records As Of Specified Date deko (10/29/04)
- Re: Query To Find Records As Of Specified Date Sue (10/29/04)
- Re: Query To Find Records As Of Specified Date Allen Browne (10/29/04)
- Re: Query To Find Records As Of Specified Date Salad (10/29/04)
- Re: Query To Find Records As Of Specified Date deko (10/29/04)
- Compare Data Daniel (10/28/04)
- Showing related value in form's field value rgrantz (10/28/04)
- dates query noelle_xcel (10/28/04)
- Criteria for Query Ashley (10/28/04)
- I keep getting a "#Error" Jason Butler (10/28/04)
- Querydefs not working? Paul Fenton (10/28/04)
- Sum of queries on a form Ravi Sandhu (10/28/04)
- Trying to check 3rd character in string as criteria rgrantz (10/28/04)
- Re: Trying to check 3rd character in string as criteria Tom Ellison (10/28/04)
- Re: Trying to check 3rd character in string as criteria Duane Hookom (10/28/04)
- Re: Trying to check 3rd character in string as criteria MGFoster (10/28/04)
- Re: Trying to check 3rd character in string as criteria Brian Camire (10/28/04)
- Time Calculations Songoku (10/28/04)
- find lowest date value from multiple fields & WORK DAYS Function DonD (10/28/04)
- show only records where NEXT record is different then the prior ave (10/28/04)
- Re: show only records where NEXT record is different then the prior Tom Ellison (10/28/04)
- Re: show only records where NEXT record is different then the prior ave (10/28/04)
- Re: show only records where NEXT record is different then the prior Tom Ellison (10/28/04)
- Re: show only records where NEXT record is different then the prior ave (10/29/04)
- Re: show only records where NEXT record is different then the prior Tom Ellison (10/29/04)
- Re: show only records where NEXT record is different then the prior ave (10/29/04)
- Re: show only records where NEXT record is different then the prior ave (10/28/04)
- Re: show only records where NEXT record is different then the prior Tom Ellison (10/28/04)
- pass through query variable mroby (10/28/04)
- Parameter Query To Pull Null Value mk2 (10/28/04)
- Query help GLW (10/28/04)
- Remove multiple numbers from field with code hysonmb (10/28/04)
- Pull a list from a table to use as exclusion criteria in a query eggman (10/28/04)
- Combine two tables in Access quartz (10/28/04)
- EOMonth Add-in jamnjana (10/28/04)
- Mode Function in Access QVCJDN (10/28/04)
- Mode Function in Access? QVCJDN (10/28/04)
- Newbie: Distinct values steve (10/28/04)
- Excluding data GLW (10/28/04)
- Must use updateable query statement SLW526 (10/28/04)
- Pulling a list with no duplicates Jerry Crosby (10/28/04)
- Using Grouping and MAX funciton tc (10/28/04)
- Need to create a counter, need help AG (10/28/04)
- Ranking Posts-Sorry Tim Sullivan (10/28/04)
- How to get percentage and sort Yubasus (10/28/04)
- Date Expression NL (10/28/04)
- Where to put SQL Mike Binger (10/28/04)
- Find umatched query question Edward Armstrong (10/28/04)
- ranking Tim Sullivan (10/28/04)
- Ranking Tim Sullivan (10/28/04)
- adding work days to a begin date to derive the end date Susan (10/28/04)
- should this be a query? lost!! (10/28/04)
- Query on Multiple Fields Simultaneously??? BARKAROO (10/28/04)
- Rank Tim Sullivan (10/28/04)
- DLookup Question Raj (10/28/04)
- DLookup Question Raj (10/28/04)
- Re: How do I retrieve the median value of a field? Hampsmom (10/28/04)
- Oh so simple query - but it ain't working! Calculated fields. Stan Smith (10/28/04)
- Subquery SUM() by Date Matt Volatile (10/28/04)
- Subtotal and Grand Total in Query quartz (10/28/04)
- Passing value from inputbox to query gb (10/28/04)
- Escalating invoice number. SHIPP (10/28/04)
- Re: Escalating invoice number. Ken Snell [MVP] (10/28/04)
- Re: Escalating invoice number. SHIPP (10/28/04)
- Re: Escalating invoice number. Ken Snell [MVP] (10/28/04)
- Re: Escalating invoice number. SHIPP (10/28/04)
- Re: Escalating invoice number. Ken Snell [MVP] (10/28/04)
- Re: Escalating invoice number. SHIPP (10/28/04)
- Re: Escalating invoice number. SHIPP (10/28/04)
- Re: Escalating invoice number. Ken Snell [MVP] (10/28/04)
- Re: Escalating invoice number. Ken Snell [MVP] (10/28/04)
- Re: Escalating invoice number. SHIPP (10/29/04)
- Re: Escalating invoice number. Ken Snell [MVP] (10/29/04)
- Re: Escalating invoice number. SHIPP (10/29/04)
- Re: Escalating invoice number. Ken Snell [MVP] (10/29/04)
- Re: Escalating invoice number. SHIPP (10/29/04)
- Re: Escalating invoice number. Ken Snell [MVP] (10/29/04)
- Re: Escalating invoice number. SHIPP (10/28/04)
- Re: Escalating invoice number. Ken Snell [MVP] (10/28/04)
- Date nir020 (10/28/04)
- comparing strings in a query?? Ivan Debono (10/28/04)
- Problems counting nick (10/28/04)
- Using Pass-Throw query Oded Kovach (10/28/04)
- Access2k + SQL 7.0 Lock problem Kyrill Fomichev (10/28/04)
- Date query fails when updating from 2000 to 2002 or later JP (10/28/04)
- query problems rico (10/28/04)
- Querry need help!! ppm (10/28/04)
- Query Help.. Creating a running Total Field????? Darryn Ross (10/28/04)
- Re: Query Help.. Creating a running Total Field????? Tom Ellison (10/28/04)
- Re: Query Help.. Creating a running Total Field????? Brian Hoops (10/28/04)
- Re: Query Help.. Creating a running Total Field????? Tom Ellison (10/28/04)
- Re: Query Help.. Creating a running Total Field????? Darryn Ross (10/28/04)
- Re: Query Help.. Creating a running Total Field????? Tom Ellison (10/28/04)
- Re: Query Help.. Creating a running Total Field????? Darryn Ross (10/28/04)
- Re: Query Help.. Creating a running Total Field????? Darryn Ross (10/28/04)
- Re: Query Help.. Creating a running Total Field????? Brian Hoops (10/28/04)
- Re: Query Help.. Creating a running Total Field????? Tom Ellison (10/28/04)
- Time sacredarms (10/28/04)
- Group By Rajani (10/28/04)
- Referring to columns in a listbox in the criteria of a query Dale Fye (10/28/04)
- Inventory db question 7 of 9 (10/28/04)
- how to used parameter query? WeeShawn (10/28/04)
- Sort in a query Tony (10/28/04)
- Using VB variables in Query Brian Hoops (10/28/04)
- Re: Using VB variables in Query Ken Snell [MVP] (10/28/04)
- Re: Using VB variables in Query Brian Hoops (10/28/04)
- Re: Using VB variables in Query Ken Snell [MVP] (10/28/04)
- Re: Using VB variables in Query Brian Hoops (10/28/04)
- Re: Using VB variables in Query Brian Hoops (10/28/04)
- Re: Using VB variables in Query Brian Hoops (10/28/04)
- Re: Using VB variables in Query Ken Snell [MVP] (10/28/04)
- Re: Using VB variables in Query Brian Hoops (10/28/04)
- Re: Using VB variables in Query Brian Hoops (10/28/04)
- Re: Using VB variables in Query Ken Snell [MVP] (10/28/04)
- Please help Tia (10/27/04)
- How do I remove records in which a field value is duplicated in another record? Matt Meserve (10/27/04)
- Re: How do I remove records in which a field value is duplicated in another record? Brett Collings [429338] (10/28/04)
- Re: How do I remove records in which a field value is duplicated in another record? Michel Walsh (10/28/04)
- Re: How do I remove records in which a field value is duplicated in another record? John Spencer (MVP) (10/30/04)
- Nested If Ken_at_AP&T (10/27/04)
- Nested If Ken_at_AP&T (10/27/04)
- Parameter Error on Calculated Field (Not typo or "visible" problem Bettergains (10/27/04)
- Comparing Employee Records Scott (10/27/04)
- Parameter Query Curiosity B. Meincke (10/27/04)
- Append Query with Date Bryan Hughes (10/27/04)
- between ... and ... Ezekiël (10/27/04)
- Fill in Records with Header Info Above Jason Morin (10/27/04)
- Calculate user totals in table one and enter values in table 2 osullipa (10/27/04)
- DEBITING BUDGET SPEND IN TABLE1 FROM BUDGET ALLOCATED IN TABLE 2 osullipa (10/27/04)
- Too many queries Somecallmejosh (10/27/04)
- query for time only Lisa (10/27/04)
- Update table from another table. Sorlenny (10/27/04)
- Filter button issue Jason (10/27/04)
- How to use a parameter query with multiple values? Norm Lundquist (10/27/04)
- How can parameter query use multiple values for same field? Norm Lundquist (10/27/04)
- How to do a parameter query with multiple values? Norm Lundquist (10/27/04)
- Search button Ilan (10/27/04)
- Date query C (10/27/04)
- help me create a directory for my own microsoft office 'assistanc. jimmyg (10/27/04)
- Queries Bmistry (10/27/04)
- Query Bmistry (10/27/04)
- Queries Bmistry (10/27/04)
- QRY for Everything open in a certain time period Jason (10/27/04)
- ? search and return? jeanne (10/27/04)
- query when dont use parameter for blank items toby (10/27/04)
- CIRCULAR REFERENCE CAUSED Carl Schuster (10/27/04)
- Append Queries Denis (10/27/04)
- Delete Query Error Message Msslove97 (10/27/04)
- Joining Tables on Similar, but not identical, Fields? Gerry Goldberg (10/27/04)
- 2nd Attempt: Updating one table from another one. Burger King (10/27/04)
- Summing certain groups of values on a report ChuckW (10/27/04)
- IIF question quixote (10/27/04)
- crosstab query column headers do not match data in cells martyc (10/27/04)
- Where am I going wrong? Matt Volatile (10/27/04)
- Assign a Primary Key in Query Rob Meiner (10/27/04)
- Bringing Info From Two Table Together Chandra (10/27/04)
- Relationships burg (10/27/04)
- Operation must use an updatable query Serge Myrand (10/27/04)
- Unmatched Query Mess Natalia (10/27/04)
- Using a PassThrough Query to Make a Table Conor Walsh (10/27/04)
- Converting from string to time and subtracting two time fields Anamik (10/27/04)
- Multiple queries AND macros Malcolm Andersson (10/27/04)
- How do I find the maximun values in each group? michelle (10/27/04)
- Is Not Null Doesn't work right XeniaEagle (10/27/04)
- how to find who has and who has not taken "food poision" training? Chocolate Cookie (10/27/04)
- How do I set up the IF THEN Condition in the SELECT clause? davidg2356 (10/27/04)
- How do I calculate the result of a number raised to the power of . Harro (10/27/04)
- Finding similar records? Paul Fenton (10/26/04)
- Pass-Through Query Frank Martin (10/26/04)
- Combining tjh (10/26/04)
- Help with simple delete query Randal (10/26/04)
- Access query Celest (10/26/04)
- NOT IN operator not working with subquery. Terry (10/26/04)
- How do I set up a crosstab query to act like a parameter query? Jude G (10/26/04)
- Need Help print Access report from vb6 Angel b1 (10/26/04)
- How to check a text field which has no value asigned? Min (10/26/04)
- Too many queries Somecallmejosh (10/26/04)
- Crosstab Query - Column headings GDAVIS (10/26/04)
- Crosstab Query - Column Heading GDAVIS (10/26/04)
- Trim Email Address down to domain only Steve Roberts (10/26/04)
- Re: Trim Email Address down to domain only Douglas J. Steele (10/26/04)
- Re: Trim Email Address down to domain only John Spencer (MVP) (10/26/04)
- Re: Trim Email Address down to domain only Steve Roberts (10/26/04)
- Re: Trim Email Address down to domain only Douglas J. Steele (10/27/04)
- Re: Trim Email Address down to domain only Steve Roberts (10/27/04)
- Re: Trim Email Address down to domain only Douglas J. Steele (10/27/04)
- Re: Trim Email Address down to domain only Steve Roberts (10/27/04)
- Re: Trim Email Address down to domain only John Spencer (MVP) (10/28/04)
- Re: Trim Email Address down to domain only Douglas J. Steele (10/28/04)
- Re: Trim Email Address down to domain only John Spencer (MVP) (10/26/04)
- Re: Trim Email Address down to domain only Steve Roberts (10/26/04)
- Sum and Group in Query Chandra (10/26/04)
- Access 2003 sudden slowdown on front-end Julie (10/26/04)
- Unrecognized database format: C:\PROGRAM FILES\MICROSOFT OFFICE\O. Dale (10/26/04)
- Linking to bigint Steve Kallal (10/26/04)
- Queries and Subqueries Tia (10/26/04)
- Better Way to Phrase SQL simsjr (10/26/04)
- Date Problem Bryan Hughes (10/26/04)
- Make Table Query-Issue with Date SMac (10/26/04)
- Multiple Query results into a single table for all? Edward Armstrong (10/26/04)
- Using a field name as QBE criterea Brian Goodheim (10/26/04)
- Need help print access report from VB6 Angel b1 (10/26/04)
- DateSerial question JMorrell (10/26/04)
- triggers in MS Access Prashanth (10/26/04)
- Strain Your brain with me (text Length) MacALF (10/26/04)
- Delete Query MEKL (10/26/04)
- Problem with a report RobertM (10/26/04)
- make table query Taher (10/26/04)
- code a range of records? TreDogg103 (10/26/04)
- functions Left, Mid, Right Jyotsna (10/26/04)
- Aliasing JOINs Matt Volatile (10/26/04)
- INLIST function Carl Hilton (10/26/04)
- date diff query Kay Davies (10/26/04)
- Query help - please Scott Duncan (10/26/04)
- Queries too complicated - Is there an easier way Tony Wainwright (10/26/04)
- Item as per Latest Date + Summed quantities of distinct items Matt Volatile (10/26/04)
- Multiple Quaries Malcolm Andersson (10/26/04)
- Selection Criteria Steve (10/26/04)
- Order Problem, what's wrong? Min (10/26/04)
- Qry based on form w cbo boxes Charles L. Snyder (10/26/04)
- Query Help! Michael (10/26/04)
- "Like" query Paul Fenton (10/25/04)
- Advanced query on numbers stored in a text field. Dub333 (10/25/04)
- Re: Advanced query on numbers stored in a text field. Van T. Dinh (10/25/04)
- Re: Advanced query on numbers stored in a text field. Dub333 (10/25/04)
- Re: Advanced query on numbers stored in a text field. Van T. Dinh (10/26/04)
- Re: Advanced query on numbers stored in a text field. John Vinson (10/26/04)
- Re: Advanced query on numbers stored in a text field. Dub333 (10/26/04)
- Re: Advanced query on numbers stored in a text field. PC Datasheet (10/26/04)
- Re: Advanced query on numbers stored in a text field. Dub333 (10/26/04)
- Re: Advanced query on numbers stored in a text field. Van T. Dinh (10/27/04)
- Re: Advanced query on numbers stored in a text field. Dub333 (10/25/04)
- Re: Advanced query on numbers stored in a text field. Van T. Dinh (10/25/04)
- date criteria haggr (10/25/04)
- all values prior to certain date JMorrell (10/25/04)
- SQL syntax question bjnova (10/25/04)
- make table query Taher (10/25/04)
- Runtime licens in access 2003? news.online.no (10/25/04)
- Group By Date issue - date format is "general" chris (10/25/04)
- Query Parameters that use subform fields Geof Wyght (10/25/04)
- Group by Date question (date format is "general") chris (10/25/04)
- Group By Date question - date format needs to be "general" chris (10/25/04)
- Search for IP ranges query, URGENT! Serg (10/25/04)
- Synax for decimals Dennis (10/25/04)
- Use of the Nz function in a 2k query MLaguna (10/25/04)
- criteria in parameter queries R (10/25/04)
- Re: criteria in parameter queries Duane Hookom (10/25/04)
- Re: criteria in parameter queries fredg (10/25/04)
- Re: criteria in parameter queries R (10/25/04)
- Re: criteria in parameter queries John Vinson (10/25/04)
- Re: criteria in parameter queries Duane Hookom (10/25/04)
- Re: criteria in parameter queries R (10/25/04)
- Re: criteria in parameter queries Duane Hookom (10/25/04)
- Re: criteria in parameter queries John Vinson (10/26/04)
- Re: criteria in parameter queries R (10/26/04)
- Re: criteria in parameter queries John Vinson (10/26/04)
- Re: criteria in parameter queries fredg (10/26/04)
- Re: criteria in parameter queries R (10/26/04)
- Re: criteria in parameter queries John Vinson (10/26/04)
- Re: criteria in parameter queries R (10/26/04)
- Re: criteria in parameter queries R (10/26/04)
- Re: criteria in parameter queries R (10/27/04)
- Re: criteria in parameter queries R (10/27/04)
- Re: criteria in parameter queries R (10/25/04)
- Query Results from an Empty Table NewAccessDeveloper (10/25/04)
- Problem with query and report MCK (10/25/04)
- Using VB to search multiple criteria in subforms/Using ADO code. Justin Walters (10/25/04)
- replace line breaks in memo field shank (10/25/04)
- Question using LIKE Jeff (10/25/04)
- Query Prompt jk (10/25/04)
- Selection Criteria Steve (10/25/04)
- Selection criteria Steve (10/25/04)
- Unmatched Query Natalia (10/25/04)
- IF function in Microsoft Query? DES_Optima (10/25/04)
- Can this SQL code be simplified? Ron (10/25/04)
- Calculations from Query sad (10/25/04)
- find the highest value in one field for each value in another John Van Horn (10/25/04)
- Error 3071-Not really sure of cause... Bev (10/25/04)
- "invalid bracketing of name" when referencing Query Parameter GreggLund (10/25/04)
- SQL Specific Window for numeric data types? debkay_rich (10/25/04)
- MULITPLE IF STMNT EASIER jeanne (10/25/04)
- New to queries Support (10/25/04)
- Access Queries - Group in selection and in output Peter (10/25/04)
- Another Union query question dar (10/25/04)
- How to post/update a field of a previously posted records Irshad Alam (10/25/04)
- Decimal Time Problem Songoku (10/25/04)
- I want to see records with null values. Pantelis (10/25/04)
- automatic reorder for report fields administrator (10/25/04)
- combining table via query tang lk (10/25/04)
- Export to Excel & protect Joe (10/25/04)
- Help with Queries Michael (10/25/04)
- Setting a filter on a query palto1 (10/24/04)
- Why can't I do this? Jerry (10/24/04)
- Comparing Content of Tables Matt Volatile (10/24/04)
- Comparing Content of Tables Matt Volatile (10/24/04)
- SQL ACCESS Pete_R (10/24/04)
- Please help me with an SQL query Newboy 21 (10/24/04)