Can this be done? Please help!!!!
Jan105 H2O Temp 9am H2O Reading 3pm Do Reading 8am Do reading 3pm
Mortality#
Jan202 Same headings--------->
Jan305 Same headings--------->

How do you set this up for a month and be able to add or delete
headings with out jumbling info. Can you do this for the whole year in
one table or is it better to use a table foe each month and cross
reference?

Start with this table:
TblWasteWater
WasteWaterID
SampleDate
H2OTemp9AM
H2OReading3PM
DOReading8AM
DOReading3PM
MortalityNum

You can use this one table for all days, months and years!

To report the data, create a crosstab query based on the above table.
Instead of including SampleDate in the query, put the following expression
in a blank field of the query:
DateSampleTaken:Format([SampleDate],"Medium")

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource (AT) pcdatasheet (DOT) com
www.pcdatasheet.com



"Wade" <mcgowanl (AT) auracom (DOT) com> wrote