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
|
|||
|
|||
Access Crosstab Query Should Link To Forms
MS-Access Crosstab query doesn't take the form field in the criteria. So one
need to create a crosstab query and then build another select query on top of that which will have the filtering criteria for the form. Can we make a single query?? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...access.queries |
#2
|
|||
|
|||
Access Crosstab Query Should Link To Forms
This question gets asked and answered several times per week. You can use
parameters/criteria in crosstab queries if you explicitly identify the data types of the criteria. Select Query-Parameters and enter Forms!frmA!txtB Date/Time -- Duane Hookom MS Access MVP -- "Anonymous" wrote in message ... MS-Access Crosstab query doesn't take the form field in the criteria. So one need to create a crosstab query and then build another select query on top of that which will have the filtering criteria for the form. Can we make a single query?? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...access.queries |
#3
|
|||
|
|||
Access Crosstab Query Should Link To Forms
I wonder why Crosstab queries behave that way...I was stuck with a
crosstab a few weeks ago until I figured that out on my own... Jeff On Wed, 08 Mar 2006 13:14:39 -0500, Duane Hookom wrote: This question gets asked and answered several times per week. You can use parameters/criteria in crosstab queries if you explicitly identify the data types of the criteria. Select Query-Parameters and enter Forms!frmA!txtB Date/Time -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ |
#4
|
|||
|
|||
Access Crosstab Query Should Link To Forms
I wonder why Crosstab queries behave that way...I was stuck with a
crosstab a few weeks ago until I figured that out on my own... Jeff On Wed, 08 Mar 2006 13:14:39 -0500, Duane Hookom wrote: This question gets asked and answered several times per week. You can use parameters/criteria in crosstab queries if you explicitly identify the data types of the criteria. Select Query-Parameters and enter Forms!frmA!txtB Date/Time -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ |
#5
|
|||
|
|||
Access Crosstab Query Should Link To Forms
A clue to why they behave that way is if you enter the Column Headings
property, you won't need to declare your data parameter types. For instance if you have a date criteria but set your column headings property like: Column Headings: "Jan","Feb","Mar","Apr" You don't need to specify the data types of your parameters. -- Duane Hookom MS Access MVP -- "Anonymous" wrote in message newsp.s55wfqj1aq8s7f@kvitjb... I wonder why Crosstab queries behave that way...I was stuck with a crosstab a few weeks ago until I figured that out on my own... Jeff On Wed, 08 Mar 2006 13:14:39 -0500, Duane Hookom wrote: This question gets asked and answered several times per week. You can use parameters/criteria in crosstab queries if you explicitly identify the data types of the criteria. Select Query-Parameters and enter Forms!frmA!txtB Date/Time -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2002 vs. 2003 | Neil | General Discussion | 52 | February 16th, 2006 10:18 PM |
MS Access 2003 CrossTab Query Question using VBA--Item not found i | Mike S. S. | Running & Setting Up Queries | 11 | January 24th, 2006 09:52 PM |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |