microsoft.public.access.queries
By Thread
2563 messages sorted by: [ date ]
Starting: 10/31/04
Ending: 11/30/04
- Re: any John Vinson (11/30/04)
- Changing Case in Field JWCrosby (11/30/04)
- Need help to write query to show records by record number bobm (11/30/04)
- ALTER COLUMN question BobV (11/30/04)
- Set up an Autonumber Query CT. College Student Project (11/30/04)
- distinct rows JRS (11/30/04)
- Re: removing commas and apostrophes using query Ken Snell [MVP] (11/30/04)
- calculation on a MAX(DATE) query davidg2356 (11/30/04)
- percentile jvman (11/30/04)
- duplicates JRS (11/29/04)
- Adding a combo box in a query Ammo (11/29/04)
- Would like a drop down choice when using a parameter query LoriO (11/29/04)
- Cumulative total Vincdc (11/29/04)
- combining names JohnE (11/29/04)
- not getting all recs for outer join njp (11/29/04)
- Combo box returns numeric values Joe (11/29/04)
- Dont want to show duplicates, and want to show how many clients J-E (11/29/04)
- Multiple Table Query Bill Burke (11/29/04)
- Adding fields in a query Dave (11/29/04)
- Dont want to show duplicates, and want to show how many clients J-E (11/29/04)
- "validation rules violation" Jeff25550 (11/29/04)
- slecting all fields for a union query jeanne (11/29/04)
- SELECTING ALL FIELDS FOR A UNION QUERY jeanne (11/29/04)
- Day of week Ryno (11/29/04)
- Add Table to Select query Mary (11/29/04)
- need help with access query karoaustin (11/29/04)
- criteria question Angi (11/29/04)
- Query - how to get the blank form to show, not search the databas. Dr_Richie (11/29/04)
- Data Type Ivor Williams (11/29/04)
- Is it possible to get a report where every column is sorted the way I want it? PeterGundrum (11/29/04)
- Re: Is it possible to get a report where every column is sorted the way I want it? Rick B (11/29/04)
- Re: Is it possible to get a report where every column is sorted the way I want i anonymous_at_discussions.microsoft.com (11/29/04)
- Re: Is it possible to get a report where every column is sorted the way I want i Rick B (11/29/04)
- Re: Is it possible to get a report where every column is sorted the way I want i anonymous_at_discussions.microsoft.com (11/29/04)
- Re: Is it possible to get a report where every column is sorted the way I want i Rick B (11/29/04)
- Re: Is it possible to get a report where every column is sorted the way I want i anonymous_at_discussions.microsoft.com (11/29/04)
- Re: Is it possible to get a report where every column is sorted the way I want it? Rick B (11/29/04)
- Date criteria in a crosstab query John Hargrove (11/29/04)
- Double entries in a query J-E (11/29/04)
- Query Problem DCFujiwara (11/29/04)
- Re: How do i convert a regular date to a julian date in a query Wayne Morgan (11/29/04)
- List box and Button Rich (11/29/04)
- Summary Query problem DaveK (11/29/04)
- Query Advice Helga (11/29/04)
- Eval("Name of Field") MDB-HZA (11/29/04)
- How to find the last known value in the following dataset Karen Middleton (11/29/04)
- Excluding empty fields from a concatenated string Tim Long (11/29/04)
- error in query Bart (11/29/04)
- update same field with criteria Angi (11/29/04)
- Query with mathematics criteria!!?? Help! Tomas (11/29/04)
- Using values from a message box Kurt (11/29/04)
- nested subselects with exists Jesper F (11/29/04)
- Query using BETWEEN and Dates as criteria Chuck (11/28/04)
- IF function to show result cursednomore (11/28/04)
- Re: IF function to show result Marshall Barton (11/28/04)
- Re: IF function to show result cursednomore (11/28/04)
- Re: IF function to show result John Vinson (11/29/04)
- Re: IF function to show result cursednomore (11/29/04)
- Re: IF function to show result Marshall Barton (11/29/04)
- Re: IF function to show result cursednomore (11/29/04)
- Re: IF function to show result Marshall Barton (11/29/04)
- Re: IF function to show result cursednomore (11/29/04)
- Re: IF function to show result Marshall Barton (11/30/04)
- Re: IF function to show result tina (11/30/04)
- Re: IF function to show result cursednomore (11/28/04)
- Re: IF function to show result Tom Ellison (11/29/04)
- Re: IF function to show result Marshall Barton (11/28/04)
- Blocking unwanted messages roy barnett (11/28/04)
- Question about Quite up dates Joe Cilinceon (11/28/04)
- How do I link strings then use this to open a query brimmers (11/28/04)
- Create view Donny (11/28/04)
- need a formula KelD (11/28/04)
- Make Table Query field based on Form control B. Meincke (11/27/04)
- Problem: Insert an empty date to a date field Min (11/27/04)
- Help!!! Having Problems w/ Criteria Stacie (11/27/04)
- Alter Table Query Question BobV (11/27/04)
- query won't run RipperT (11/27/04)
- Dinamic Query Linked to a Dynamic Report Alex (11/27/04)
- Setting unknown date range in a query Wells (11/27/04)
- Too few paranetiers Synergy Tooling Systems (11/27/04)
- Q Dermot (11/27/04)
- Count days Ivor Williams (11/27/04)
- Differences the date by time Jerry C.k (11/27/04)
- Re: Differences the date by time Gijs Beukenoot (11/27/04)
- Re: Differences the date by time John Vinson (11/27/04)
- Re: Differences the date by time Jerry C.k (11/28/04)
- Re: Differences the date by time John Vinson (11/28/04)
- Re: Differences the date by time Jerry C.k (11/29/04)
- Re: Differences the date by time John Vinson (11/29/04)
- Re: Differences the date by time Jerry C.k (11/29/04)
- Re: Differences the date by time Gijs Beukenoot (11/29/04)
- Re: Differences the date by time Jerry C.k (11/29/04)
- Re: Differences the date by time Jerry C.k (11/28/04)
- RE: Differences the date by time Jerry C.k (11/28/04)
- Calculated Field To Show 1/3, 2/3 And 3/3 Judy (11/26/04)
- run several queries at once Maileen (11/26/04)
- Parameters in the query T. W. (11/26/04)
- HELP ASAP: The parameter box is preventing me from running queries DDTrx2004 (11/26/04)
- 2 table Query Error GRCC (11/26/04)
- Append Questions Don (11/26/04)
- query from two tables Jack (11/26/04)
- Crosstab Error colin (11/26/04)
- Incorrect calculation of beginning balance jsccorps (11/26/04)
- How do I get the queries icon on my toolbar in Access jiffajaff (11/26/04)
- Combining two queries for total count tanorris_at_academicplanet.com (11/26/04)
- Querying MS SQL database Randy (11/26/04)
- self join query in access Shahzad (11/26/04)
- Access2 NY (11/26/04)
- Access2 NY (11/26/04)
- min() as criteria in a query Christian (11/26/04)
- Generating dates Tim Long (11/26/04)
- Different result of LEFT and LIKE query in mdb file EricYuh Taiwan (11/26/04)
- Rounding up partial months LesleyW (11/26/04)
- How to order a sub table? Min (11/26/04)
- Appending records soljones (11/26/04)
- Error 3122 You tried to execute a query that does not include Steven Cheng (11/26/04)
- Date Query Larry (11/26/04)
- Display an SQL query using VBA Ludo Claes (11/25/04)
- Altering a table design and populating table from VB Islander (11/25/04)
- DateAdd - 2 months from a [orderdate] field in an update query BigG (11/25/04)
- query problem Fernando Ríos (11/25/04)
- Process update query in specific order Byron (11/25/04)
- Inherit table.field format in a summary query Jim Bennett (11/25/04)
- Setting SQL for queries using Visual Basic David Cleave (11/25/04)
- (query) Group and distributes data evenly based on duration of tasks to be completed Dan D (11/25/04)
- Difficult quiry with 3 tables Jens Burup (11/25/04)
- Query to view repeated record David (11/25/04)
- Selecting the first of each group problem James Minns (11/25/04)
- update/convert data? d. (11/25/04)
- how to handle empty fields in queries Christopher Glaeser (11/25/04)
- my query is blank (no records) Demasio (11/25/04)
- Unbound field in query timeteo (11/25/04)
- append queries to transfer flat data file into relational tables Darren (11/24/04)
- Calculated query problem sad (11/24/04)
- Calculated query problem sad (11/24/04)
- Double Click Listbox matching records question Draedric (11/24/04)
- Query Advice Helga (11/24/04)
- Access Query freddy (11/24/04)
- Switch in a Query HollyH (11/24/04)
- IIF x=y, >4<8,100 Deeds (11/24/04)
- Formating a querie Rodolfo Fontes (11/24/04)
- QTD Criteria Deeds (11/24/04)
- Could I get some query theory clarification? Dennis Snelgrove (11/24/04)
- Opening a report from a form Angel b1 (11/24/04)
- Creating a Query in Access with user selection from multiple Table Phil from Hardings (11/24/04)
- How to Compact and Repair a DB within a Macro ? Thomas (11/24/04)
- calculating MEDIAN in a query Tommy (11/24/04)
- How to use a query to merge with Word Susanbee (11/24/04)
- test for a table existence Koni Kogan (11/24/04)
- Query to get month numbers Mauricio Silva (11/24/04)
- Converting Text Date to true Date format Anthony C (11/24/04)
- Domain aggregate multiple criteria Multiple selection criteria in dsum (11/24/04)
- select query count Dan_at_BCBS (11/24/04)
- First and Last Day of Month? Anthony C (11/24/04)
- #####Using Control as a Query parameter##### Jimmy (11/24/04)
- How do I set a criteria in Access to show all if null or the cont. VHII (11/24/04)
- ADD A AT THE Beginning TYE (11/24/04)
- How to skip the "confirm-question" when running an remove-query Anders Berlin (11/24/04)
- SELECT DISTINCT & SELECT in SQL Dragon_Silveroak (11/24/04)
- How to drop all the indexes of a table Thomas (11/24/04)
- Check Box Question in Query Joe Cilinceon (11/24/04)
- Syntax Error Edgar Thoemmes (11/24/04)
- Calender in a query Hank Hendrix (11/24/04)
- how can I use selected lines on a form for criteria in a query Ricallo (11/24/04)
- Re: Mission Impossible - Comparing Files apapw2004 (11/24/04)
- References... Andreas Andreasson (11/24/04)
- Too many numbers LMB (11/24/04)
- IIF Michelle (11/24/04)
- Access 2002-budgets and expenses DonnaG (11/24/04)
- Queries with Microsoft Access Joe Bryant (11/23/04)
- field refresh missing Steve (11/23/04)
- what is the syntax for "SELECT DISTINCT column-name?" Jorge (11/23/04)
- query involving dates C White (11/23/04)
- Re: query involving dates Allen Browne (11/24/04)
- Re: query involving dates C White (11/24/04)
- Re: query involving dates Allen Browne (11/24/04)
- Re: query involving dates C White (11/24/04)
- Re: query involving dates Allen Browne (11/24/04)
- Re: query involving dates C White (11/24/04)
- Re: query involving dates Allen Browne (11/24/04)
- Re: query involving dates C White (11/24/04)
- Re: query involving dates Allen Browne (11/24/04)
- Re: query involving dates C White (11/24/04)
- Re: query involving dates Allen Browne (11/25/04)
- Re: query involving dates C White (11/25/04)
- Re: query involving dates Allen Browne (11/25/04)
- Re: query involving dates C White (11/24/04)
- Re: query involving dates Allen Browne (11/24/04)
- Criteria to find what isn't there. Glenn (11/23/04)
- 2 Combo Boxes Richard Connell (11/23/04)
- No idea how to get the query I want news.microsoft.com (11/23/04)
- Access 2003 MikeD (11/23/04)
- Cross tab query action Slow Learner (11/23/04)
- Separating Names Melanie (11/23/04)
- Consolidating queries Steven Cheng (11/23/04)
- Cross tab query and calculated rows Christian (11/23/04)
- Year in Query Robert Sykes (11/23/04)
- Using Combo Boxes as criteria for a parameter query Ruthy710 (11/23/04)
- Linking problem - Access query to MS query to extract data to Exce FatMan (11/23/04)
- query output as a list martin (11/23/04)
- Count and display different services Simon Jester (11/23/04)
- lock violation when running Append query newsgroupscnhs (11/23/04)
- query report Rosemary (11/23/04)
- Max 3 rocords Steve (11/23/04)
- COUNT on 2 Coloumns vijay (11/23/04)
- Query Prompt with drop down menu BillyRogers (11/23/04)
- How do I print a list of queries? SusanB (11/23/04)
- Help with a new Query Jan (11/23/04)
- Need help with query on a form Paul (11/23/04)
- Access expression result PaulH3 (11/23/04)
- Access 97 and VBA Chris (11/23/04)
- Queries: Tables w/ 1to1 Relationships Helga (11/23/04)
- 90 day eligibility Mandy J.S. (11/23/04)
- How do I get a query to prompt me so i can type the information I Melani (11/23/04)
- time tracking stag246 (11/23/04)
- format command Taher (11/23/04)
- problem with append query in access 2003 Dick (11/23/04)
- How to get data from Analysis Services cubes into Access Karen Middleton (11/23/04)
- Re: How to get data from Analysis Services cubes into Access Steve McHugh (11/23/04)
- Re: How to get data from Analysis Services cubes into Access aaron kempf (11/23/04)
- Re: How to get data from Analysis Services cubes into Access Steve McHugh (11/24/04)
- Re: How to get data from Analysis Services cubes into Access Karen Middleton (11/24/04)
- Re: How to get data from Analysis Services cubes into Access markie (11/24/04)
- Re: How to get data from Analysis Services cubes into Access aaron kempf (11/24/04)
- Re: How to get data from Analysis Services cubes into Access Mark Hill (11/25/04)
- Re: How to get data from Analysis Services cubes into Access Karen Middleton (11/26/04)
- Re: How to get data from Analysis Services cubes into Access luminary (11/26/04)
- Working out costs per trainee Garry (11/23/04)
- Entering VBA Replace function in query criteria Chris Crook (11/23/04)
- how to add extra column in crosstab query KRISH (11/23/04)
- More then 5 result rows with SELECT TOP 5 * Versteijn (11/23/04)
- Building criteria ... zen (11/23/04)
- Help with queries Joe Bryant (11/23/04)
- Microsoft Access - Query Problem Joe Bryant (11/23/04)
- Workstation is Locking the Table Bill (11/22/04)
- Increment custom autonumber in batches Crag (11/22/04)
- How do I work with one-to-many relations in Access queries? DMR5713 (11/22/04)
- Zeros to replace nulls in Crosstab Paul Ilacqua (11/22/04)
- Not updateable query John (11/22/04)
- How to round off to nearest 0.25 Darrell Childress (11/22/04)
- Repost Update Values Edgar Thoemmes (11/22/04)
- Simple query - broken brain..... D. Shane Fowlkes (11/22/04)
- I'm creating query to list people with their countries, and... Debbie (11/22/04)
- Complex Query (was: Refresh vs. requery vs. Remove Filter in FormsCoding NG) rgrantz (11/22/04)
- setting criteria for date difference Jeffery (11/22/04)
- Dropdown Based on Another Field Harv (11/22/04)
- Error while Upating records Stephen (11/22/04)
- Update query - more than 1 column??? MaBell (11/22/04)
- How do I keep from repeating one entry like the same name, info. . Debbie (11/22/04)
- date and time being changed on word doc's dennis (11/22/04)
- Equipment/Sub-Equipmet/Signal query Ed (11/22/04)
- Can I do This-variable criteria for a field Ed Ardzinski (11/22/04)
- Delete Query JLong (11/22/04)
- How do I join tables in a query? R-Enemy (11/22/04)
- Ranges in Criteria of a Query Dawn (11/22/04)
- Re: Ranges in Criteria of a Query Tom Ellison (11/22/04)
- Re: Ranges in Criteria of a Query Dawn (11/22/04)
- Re: Ranges in Criteria of a Query Tom Ellison (11/22/04)
- Re: Ranges in Criteria of a Query Dawn (11/22/04)
- Re: Ranges in Criteria of a Query Tom Ellison (11/22/04)
- Re: Ranges in Criteria of a Query Dawn (11/23/04)
- Re: Ranges in Criteria of a Query Tom Ellison (11/24/04)
- Re: Ranges in Criteria of a Query Dawn (11/24/04)
- Re: Ranges in Criteria of a Query Tom Ellison (11/24/04)
- Re: Ranges in Criteria of a Query Dawn (11/22/04)
- Re: Ranges in Criteria of a Query Tom Ellison (11/22/04)
- Declare... Andreas Andreasson (11/22/04)
- cascading multiselect listboxes Albert (11/22/04)
- Not in Table Query Edgar Thoemmes (11/22/04)
- Enter Parameter Value Dialog Box Mary A Perez (11/22/04)
- query Access table structures Howard Bullock (11/22/04)
- Missing Operator Joe Cilinceon (11/22/04)
- Query with mulitple optional criteria palto1 (11/22/04)
- Re: Key violations??????? Jay (11/22/04)
- Crosstab Query Primer? Dennis (11/22/04)
- Passing parameters from command bottons to criteria shadow (11/22/04)
- WORD XP mail-merge FAILS using ACCESS query SueMackay (11/22/04)
- How do I search for a field in a query? Diarmuid (11/22/04)
- To set a null field to numeric in a query linking two tables (Th. RAJ (11/22/04)
- Bring together tables without Union Query bdehning (11/22/04)
- Re: I found this great little site. StCyrM (11/22/04)
- Date format problem Warren Siu (11/22/04)
- Datagrid in Access? code (11/22/04)
- IIF issues in a Query Sally (11/21/04)
- Passing parameters to action stored procedures using ADO, in Access Project zlatko (11/21/04)
- selection query siemon (11/21/04)
- Update Query Edgar Thoemmes (11/21/04)
- statistics in Access JMG (11/21/04)
- Week Start Date Ed (11/21/04)
- Report loses sorting criteria of underlying query John S. Ford, MD (11/21/04)
- Re: Report loses sorting criteria of underlying query Allen Browne (11/21/04)
- Re: Report loses sorting criteria of underlying query John S. Ford, MD (11/21/04)
- Re: Report loses sorting criteria of underlying query Rick Brandt (11/21/04)
- Re: Report loses sorting criteria of underlying query Albert D. Kallal (11/21/04)
- Re: Report loses sorting criteria of underlying query Marshall Barton (11/21/04)
- Re: Report loses sorting criteria of underlying query John S. Ford, MD (11/21/04)
- Re: Report loses sorting criteria of underlying query Tom Lake (11/21/04)
- Re: Report loses sorting criteria of underlying query Albert D. Kallal (11/22/04)
- Re: Report loses sorting criteria of underlying query Marshall Barton (11/21/04)
- Re: Report loses sorting criteria of underlying query Tom Ellison (11/21/04)
- Re: Report loses sorting criteria of underlying query John S. Ford, MD (11/21/04)
- Re: Report loses sorting criteria of underlying query Allen Browne (11/21/04)
- refreshlink?? Andreas Andreasson (11/21/04)
- how do i display the day of the week using the TODAY() function? jay (11/21/04)
- I hav lost my set up number on the jewel case where else can it b. eanstruther (11/21/04)
- dates query RipperT (11/21/04)
- Query/AND operator/Passing values of many list boxes to a query Denis (11/21/04)
- Displaying data using crosstab query or other method jsccorps (11/20/04)
- Need query to separate 2 entry types in a table field Jan Il (11/20/04)
- Re: Need query to separate 2 entry types in a table field Steve Schapel (11/21/04)
- Re: Need query to separate 2 entry types in a table field Jan Il (11/21/04)
- Re: Need query to separate 2 entry types in a table field Steve Schapel (11/21/04)
- Re: Need query to separate 2 entry types in a table field Jan Il (11/21/04)
- Re: Need query to separate 2 entry types in a table field Steve Schapel (11/21/04)
- Re: Need query to separate 2 entry types in a table field Jan Il (11/21/04)
- Re: Need query to separate 2 entry types in a table field Jan Il (11/21/04)
- Re: Need query to separate 2 entry types in a table field Steve Schapel (11/21/04)
- Re: Need query to separate 2 entry types in a table field Jan Il (11/21/04)
- Re: Need query to separate 2 entry types in a table field Steve Schapel (11/22/04)
- Re: Need query to separate 2 entry types in a table field Jan Il (11/22/04)
- Re: Need query to separate 2 entry types in a table field Steve Schapel (11/22/04)
- Re: Need query to separate 2 entry types in a table field Jan Il (11/22/04)
- Re: Need query to separate 2 entry types in a table field Steve Schapel (11/22/04)
- Re: Need query to separate 2 entry types in a table field Jan Il (11/22/04)
- Re: Need query to separate 2 entry types in a table field Steve Schapel (11/23/04)
- Re: Need query to separate 2 entry types in a table field Jan Il (11/23/04)
- Re: Need query to separate 2 entry types in a table field Steve Schapel (11/23/04)
- Re: Need query to separate 2 entry types in a table field Jan Il (11/23/04)
- Re: Need query to separate 2 entry types in a table field Steve Schapel (11/23/04)
- Re: Need query to separate 2 entry types in a table field Jan Il (11/23/04)
- Re: Need query to separate 2 entry types in a table field Steve Schapel (11/23/04)
- Re: Need query to separate 2 entry types in a table field Jeff Conrad (11/22/04)
- Re: Need query to separate 2 entry types in a table field Steve Schapel (11/22/04)
- Re: Need query to separate 2 entry types in a table field Jeff Conrad (11/22/04)
- Re: Need query to separate 2 entry types in a table field Jan Il (11/22/04)
- Re: Need query to separate 2 entry types in a table field Steve Schapel (11/22/04)
- Re: Need query to separate 2 entry types in a table field Tom Ellison (11/22/04)
- Re: Need query to separate 2 entry types in a table field Jeff Conrad (11/23/04)
- Re: Need query to separate 2 entry types in a table field Jan Il (11/22/04)
- Re: Need query to separate 2 entry types in a table field Tom Ellison (11/22/04)
- Re: Need query to separate 2 entry types in a table field Jan Il (11/21/04)
- Re: Need query to separate 2 entry types in a table field Steve Schapel (11/21/04)
- Multiple common fields between two tables N.F. Harrison (11/20/04)
- Crosstab Query Question Joe Williams (11/20/04)
- Using the Like Formula sdgray (11/20/04)
- Counting Null and Not Null values in one query Amy Johnson (11/20/04)
- Vertical text Lucy (11/20/04)
- How to get all dates between two dates. Debi (11/19/04)
- RE: How to measure the distance between two lat and long points CAM (11/19/04)
- Link Query? CAM (11/19/04)
- Parameter Queries, WHERE...IN.... clauses & VBA - Do they blend? Bill (11/19/04)
- count function Tiffany (11/19/04)
- Same Variable in Multiple Parameter Queries CSSMEPPS (11/19/04)
- Make table Tim (11/19/04)
- Update Query to add data to new table columns Ernie Sersen (11/19/04)
- Querying a Modifying Linked Table Charles Tam (11/19/04)
- return record with blank in one of its field jer (11/19/04)
- Make table query Luis (11/19/04)
- weeks jjrmy1_at_earthlink.net (11/19/04)
- Delete Query Error Message Josh (11/19/04)
- Pass Thru Query jaylou (11/19/04)
- Query by Form Henrique (11/19/04)
- Calculating a monthly average UGA Ag Dawg (11/19/04)
- select every nth record kimdd (11/19/04)
- 1 other query expression needing help... jacqueline (11/19/04)
- HELP with query expression........ jacqueline (11/19/04)
- FE/BE runtime speed MaBell (11/19/04)
- Help with Right$ Expression esersen (11/19/04)
- I have Microsoft Office 97 & Microsoft Office 98 - How do I remove Silver Unicorn Spirit (11/19/04)
- Selecting in between dates me (11/19/04)
- Help with date sorting and crosstab query Eric Blitzer (11/19/04)
- Enter Parameter Value slacker (11/19/04)
- Adding Row to query Oded Kovach (11/19/04) <