Cross Tab Query Paramenters Not Working

A

Alex

I have a cross tab query. I typed parameters in the Query
Parameters dialog box. Parameter: [Type Date] Date Type:
Date/Time. When I run the query, all records are still
showing. Any idea what could I be doing wrong?

Thanks,
Alex
 
D

Duane Hookom

What I know you are doing wrong is not posting your sql view.
What I guess you are also doing wrong is that you don't have [Type Date]
entered into the criteria or [Type Date] is the name of a field.
 
A

Alex

Thank you Duane.
-----Original Message-----
What I know you are doing wrong is not posting your sql view.
What I guess you are also doing wrong is that you don't have [Type Date]
entered into the criteria or [Type Date] is the name of a field.

--
Duane Hookom
MS Access MVP


I have a cross tab query. I typed parameters in the Query
Parameters dialog box. Parameter: [Type Date] Date Type:
Date/Time. When I run the query, all records are still
showing. Any idea what could I be doing wrong?

Thanks,
Alex
Click to expand...


.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

crosstab query with datea parameters 2
Expression Error on Parameter Query with link to Cross Tab Query 8
Display columns without data in cross tab query 4
Parameters error in Cross Tab Query 0
Using automation to load a cross tab query to Excel 11
cross tab query outer join 1
Query using date range entered by user 2
Cross-Tab Query 2

Top