Search results

Ok, what would be the best way to display a crosstab??? The query doesn't look "professional" (not my words) enough

I would LOVE to make one query but I can't figure out how to do it. I have a trip status field and a trip type field, the queries are based on the different statuses and one is based on status and type. Example... I am doing a count in each query Query1 if trip status =S1 or SQ or SR, then...

Right, I am doing that but it won't let me put in a crosstab, am I doing something wrong or is this just not allowed??

I have 8 queries that ask for a begin date, end date & plan id, I have them as subreports on one report so when I run, it asks me 8 times, can I put in something so it only asks me once??

Can I put a crosstab query in a report as a subreport???

SORRY, I am so new at this I am not sure how to even do that much, I have been searching and will continue to search threads. Thanks

Looking for good info on subreports, I have multiple queries I need to combine into one report. Any help would be appreciated. :D