Two pages report from one table

N

New_Access

I have a table like below

Date/time A B C1 D1 E1 C2
D2 E2 Remark

I want the data separated in two reports,with addition:
*) Date/time sort ascending.
*) Grouping by field A and B
*) The value of C1,D1,E1,Remark are in first page.
*) The value of C2,D2,E2,Remark are in second page
*) There are four function for each C1....E2 fields,they are
Max,Min,Mean,and StDev in both of report pages.

Before printing the report the user should find the records
first in a form.But how to NOT print the secong page actually
there is no data in field C2.....E2 or all of their values is 0.

Please advise?
 

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

Insert columns and values programmatically with IF statement 9
Query/Report Help for Date Difference 8
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Auto update/fill column heading 4
Adding values in to table for appropriate fields only 5
Hiding Group Levels by Criteria 10
Over time? 4
Merging rows based on column value 2

Top