Search results

Found a solution: In a crosstab query you must enter all the valid column headings into the Column Headings property of the crosstab query. http://allenbrowne.com/ser-67.html Since my column headings are the numbers corresponding to the days of the week, it was no problem. The report is...

Duhhh. :rolleyes: I was just googling "Query Parameters" when I checked back here. This is a great site. Thanks alot!

That didn't work.

Thanks. That helped with the summary reports. But now I need to figure out how to duplicate the results of that crosstab query with a select query. Any ideas?

Newbie here. :) I have a query that accepts two dates. The Criteria entry is: Between [Enter beginning date] And [Enter ending date] . How do I get the second date to appear on the report in the following format: For week ending: 2/16/07 . Thanks in advance.

I created a database that contains 2 tables. I then created a query that simply groups the data and calculates a row total. And it works as expected. However, when I try to create a report, using the query, I get, "The wizard was unable to generate fields from the record source you chose...