SOLVED: Add Field to Report

[ptvGuy]

i thought there would be a "view SQL query" option like there is in Crystal, or maybe a "report selection crietria" section... i can not find either of those so i can get part way to the final result in Crystal but not completely there - and in Access i cant get it to sort the way i want...

I don't know if you figured this out already, but any time you're in the Query Design view (where you can see the design grid at the bottom and the field list at the top), you can always go to the top of the window, push the "View" button and choose "SQL View". I hope that's at least some help.