CrossTab Query Help

[tmartin]

I am trying to create a report that has a monthly report that shows the sales for New Business, endorsement, and payments for each employee with a total for that month. I have attached a DB file with A query that is close but not suitable to build a real report. Any suggestions. I need to be able to control the date range from a form


Tom
DemoDB.zip

[ranman256]

On the form , put your 2 text boxes

txtStart

txtEnd



I use 2 queries,

Q1 is the base query to get the date range and fields needed

...where [date] between forms!frmRpts!txtStart and forms!frmRpts!txtEnd



then Q2 is the crosstab query using Q1.

NOTE: THE CROSSTAB QUERY MUST HAVE PARAMETERS. Under Query, parameters, fill in

forms!frmRpts!txtStart date

forms!frmRpts!txtEnd date



Otherwise the query will keep asking you for this.

[tmartin]

I created a query Q1 that used the values from the form to select a range of date. I had the output of the query create a new table called Temp
Then I modified the query I had and used the temp table instead to produce a result. Its clear that is a real kludge. Could you be more specific on how to resolve this
issue without creating a temporary table?

Thanks

[June7]

Building a stable report to run perpetually based on crosstab is not easy. Review http://allenbrowne.com/ser-67.html