List work orders by date

A

amaneta

I know this must be simple, but so am I. I am trying to write a query that
will list work order numbers by date, like this:

8/1/05 8/2/05 8/3/05 8/4/05
1234 1247 1258 1269
1235 1248 1259 1270
1236 1249 1260 1271

Crosstab isn't working for me because I need nothing for rows. Any tips will
be greatly appreciated!
 
D

Duane Hookom

You can create a dummy/constant expression for a row heading:
RowHead:"Ignore Me"
 
Top