A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access Crosstab Query Should Link To Forms



 
 
Thread Tools Display Modes
  #1  
Old March 8th, 2006, 06:41 PM posted to microsoft.public.access.queries
external usenet poster
 
Posts: n/a
Default 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  
Old March 8th, 2006, 07:14 PM posted to microsoft.public.access.queries
external usenet poster
 
Posts: n/a
Default 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  
Old March 9th, 2006, 08:58 PM posted to microsoft.public.access.queries
external usenet poster
 
Posts: n/a
Default 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  
Old March 9th, 2006, 08:58 PM posted to microsoft.public.access.queries
external usenet poster
 
Posts: n/a
Default 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  
Old March 10th, 2006, 05:31 AM posted to microsoft.public.access.queries
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2002 vs. 2003 Neil General Discussion 52 February 16th, 2006 11: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 10: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 07:36 AM
Access XP Compared to Access 2003 Mardene Leahu New Users 1 October 1st, 2004 05:11 AM


All times are GMT +1. The time now is 10:52 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.