criteria in a cross tab report

M

Michel Peeters

I have a crosstabreport "rptWeek" which shows the weekly sales and from
which the fiels are looking more or less as follows:

Group By - Row Heading:
CustomerId
ProductId
ProductName
ProductPrice
.....

Group by - Column Heading:

Expr1: "W" & DateDiff("ww";[SalesDate];Forms!fdlgRptWeek!txtBeginSalesDate)



Expression - Value

The Value: Sum([Salesvalue])



Where

SalesDate

Between [Forms]![fdlgRptWeek]![EindSalesDate] And
[Forms]![fdlgRptWeek]![BeginSalesDate]





The user enters the criteria (customerId, ProductId etc...) in the dialog
form fdlgRptWeek.

Then I open the report with Docmd.Openreport....strWhere.

strWhere specifies the Where condition

Everything works.



For some reasons I want also "[SalesDate] Between
[Forms]![fdlgRptWeek]![EindSalesDate] And
[Forms]![fdlgRptWeek]![BeginSalesDate]" in the Where condition instead off
in the query raster from the report.



If I put [SalesDate] in the queryraster as Group by - Columnheading - this
will not work because then my report has a seperate line for every day.

If I put [SalesDate] - Where - in the query raster [SalesDate] will not be a
field in the report and will not be accepted as criteria.

How can I solve this?



tks - Michel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

criteria for cross tab report 1
sort order in report 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Report based on criteria form 5
strWhere criteria 2
Adding control to report 2
Multi-Level Group By clause not allowed in subquery 3
Set report criteria in code? 2

Top