Problems linking a crosstab Query to a parameter query

cliffschooling

New member
Local time
Today, 03:20
Joined
Feb 15, 2012
Messages
4
I've created a Parameter query that links two tables to select a specific item in one field and between 2 dates in a date field. The query works ok, but when I try to run a Crosstab query off it to sum one of the fields it appears not to recognise the parameters within the underlying query :banghead: . Any pointer would be greatly appreciated. Ta!
 
Can you sum the fields in the parameter query? Why do you need to create a crosstab?
If you post the sql for your query, or be a bit more specific then you are more likely to get an answer.
HTH

T
 

Users who are viewing this thread

Back
Top Bottom