Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 16th, 2007, 10:45 AM
Friend of Wrox
Points: 912, Level: 11
Points: 912, Level: 11 Points: 912, Level: 11 Points: 912, Level: 11
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2005
Location: Dublin, , Ireland.
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default Crosstab date query

Hi All
I have a crosstab query that runs from a another query
The query runs a parameter asking for dates from/to
When I try to run the crosstab query I get a ms jet error message
What can I do
Thanks

Brendan Bartley
__________________
Brendan Bartley
  #2 (permalink)  
Old February 16th, 2007, 04:12 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

What is the error message? What is theSQL in each query?

mmcdonal
  #3 (permalink)  
Old February 19th, 2007, 05:51 AM
Friend of Wrox
Points: 912, Level: 11
Points: 912, Level: 11 Points: 912, Level: 11 Points: 912, Level: 11
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2005
Location: Dublin, , Ireland.
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am getting the following error message
The Microsoft jet database does not recognize date as a valid field or expression
Thanks

Brendan Bartley
  #4 (permalink)  
Old March 29th, 2007, 09:18 AM
Registered User
 
Join Date: Mar 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I just ran into this myself. I'm pretty sure you need to:

Open the query that your crosstab depends on.

Click "query", then parameters from the menu bar up top

In the window that opens, put your parameter name in there, and choose date/time as your data type. That should fix it.



Similar Threads
Thread Thread Starter Forum Replies Last Post
Crosstab - Limiting Date On Formulas - Dynamic Dat vashknight Crystal Reports 0 October 19th, 2006 05:23 PM
Crosstab query with no results edubbelaar Access 0 November 22nd, 2004 06:12 AM
Crosstab Query Ben Access 7 November 22nd, 2004 06:08 AM
Crosstab query Berni016x SQL Server 2000 2 September 17th, 2004 10:43 AM
Crosstab query vladimir Access 1 December 1st, 2003 04:02 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.