Crosstab ??

[pungigi]

I have a crosstab that the row is based on PKUP ZIP and the Columns are based on DEST ZIP, doing a simple count. I need to be able to specify though that it only counts trips with a certain STATUS but I don't want to have to enter the status each time. Any help would be appreciated

 

[hneal98]

just put that filter in your query. Not sure why you would have a problem with that. If that is not clear, post here again.

 

[pungigi]

Sorry, I am very new at this and am not having much luck, my query is as follows:

Vendor Name Vehice Type ID Total of ID
Table Table Table Table
Group by Group by Count Count
Row Heading Column Heading Value Row Heading

There is a parameter assigned to this query of:

[Enter Start Date] Date
[Enter End Date] Date
[Enter Plan Id] Number

Where would I put this filter?? I'm sure this is a stupid question and very basic stuff and I'm sorry for that but any help would be GREATLY appreciated.

BTW, the parameter does not appear to be working even though it asks for the information it still seems to be returning ALL information.

 

[hneal98]

There is a criteria row on the query grid. You would enter your criteria there under the Status field. For instance if you had a status of OK, you would put "OK" in the criteria row under the status column.

 

[pungigi]

Can I base it on multiple criteria?? Like = S1 and SQ and SG and SR??

 

[PHV]

IN ('S1','SQ','SG','SR')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[pungigi]

THANKS, that worked.