|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 24th, 2004, 05:31 PM
|
|||
|
|||
How do I set up Date query in a crosstab query?
I have set up a crosstab query that works fine.
I now want to have the user enter the beginning and ending dates for this query. I am unable to make this work. Does anyone know how to make this work? 
|
|
#2
September 24th, 2004, 07:48 PM
|
|||
|
|||
|
Make sure you set the query parameter data types. Menu select
Query-Parameters and enter your parameters and types. -- Duane Hookom MS Access MVP -- "Doddysgirl" wrote in message ... I have set up a crosstab query that works fine. I now want to have the user enter the beginning and ending dates for this query. I am unable to make this work. Does anyone know how to make this work?
|
|
#3
September 24th, 2004, 08:20 PM
|
|||
|
|||
|
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1 Template like this: PARAMETERS BeginningDate Date, EndingDate Date; TRANSFORM ... SELECT ... FROM ... WHERE Date_column BETWEEN BeginningDate And EndingDate GROUP BY ... PIVOT .. -- MGFoster:::mgf00 at earthlink decimal-point net Oakland, CA (USA) -----BEGIN PGP SIGNATURE----- Version: PGP for Personal Privacy 5.0 Charset: noconv iQA/AwUBQVRzeYechKqOuFEgEQKjjACg4qWPMLLfrxlINIrLxXL7sL 6KsNYAn0Oq SoTgNgSALDJKXoVGMFuk5jm6 =U1qn -----END PGP SIGNATURE----- Doddysgirl wrote: I have set up a crosstab query that works fine. I now want to have the user enter the beginning and ending dates for this query. I am unable to make this work. Does anyone know how to make this work?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Query Criteria where a single date comes from a form | Gary O | Running & Setting Up Queries | 3 | July 23rd, 2004 05:24 PM |
| Crosstab query in report | Vincent DeLuca | Setting Up & Running Reports | 19 | July 13th, 2004 04:02 AM |
| Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |
| Date Order in Crosstab Query | Bill | Database Design | 5 | May 4th, 2004 06:09 PM |
| Does date fall between two ranges? | MR | Worksheet Functions | 4 | January 14th, 2004 04:08 PM |
Linear Mode
