report formatting

[yessir]

I need a report based off a query to look like this:

Date Sampled EN-02 EN-04 EN-05
==============================
March 8, 2004 0 No Flow 20
March 11, 2004 1 No Flow 10

and so forth.

With the query I have included I was only able to have the form produced as:

March 8, 2004 EN-02 0
March 8, 2004 EN-05 20
March 11, 2004 EN-02 1
March 11, 2004 EN-05 10

and so forth.

can someone plz help with this, it shouldn't be that hard

~

 

[joeselch]

Create a crosstab query based on qry_RPT_Glycol.
Use SampleDate as row heading.
Use Outlet_ID as column heading.
Use First FlowValue as calculated value for row and column intersection.

If you want Outlet (instead of Outlet_ID) as the column heading...
First, add the field Outlet, from tblLocation, to qry_RPT_Glycol (besure to delete the join line between tblLocation and tblWater_Sample_Results in the query design window).
Then, make Outlet the column heading in your crosstab query.

 

[yessir]

how do u do this?

 

[yessir]

it says that you cannot use groupby in the value, so what do i put in here to just maintain the value ? SUM?

 

[yessir]

one last thing when i did this it generates a line for each outlet if the date is the same, ie:

Sample Date    EN-02  EN-04  EN-05
march 5, 2004                   5
march 5, 2004      3

 

[yessir]

got it!

Thanks for all your help!