Use a table with ____ fields.
1 - SampleResultID
2 - SampleID
3 - Year
4 - Month
5 - 36 Day1 to Day31
Store sample results in fields 5 to 36.

In your form use some Date math in the OnCurrentEvent to determine whether
to display fields Day29 to Day31.

Sorry for the previous post! Thought you might just like to see your sample
results in a calendar format.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1050 users have come from the newsgroups trusting me and requesting
help.
My fees are very reasonable.



"Fehn" wrote in message
...
Sorry PC Datasheet! But the reason I posted in this newsgroup is because I
know that this is a "friendly" exchange of ideas and knowledge! Not for
advertising!

I am not getting paid to do this database, I am doing this for my own
knowlege gain. So if no one in this group doesn't know or wasn't able to
help, then so be it! i will just have to do it in my own.

Thank you for reading my post, but also understand that Arno R. is just
protecting the users of this newsgroup and if what you say in you
advertising
is true "Over 1000 Access users have come to me for help", then you
woudn't
need to reply to anybody's questions with your advertising.

Thanks again.

"PC Datasheet" wrote:

Fehn,

Consider what another responder said about this obnoxious character and
then
decide if you want my help. I can put your sample results in a calendar
form
and calendar report for you for a reasonable fee. Over 1000 users have
come
from the newsgroups requesting help and trusting me.

"If you have anything to contribute to the group, contribute. Your war
with Datasheet is simply ****ing and moaning in the wind for the sake of
nothing. Grow up and get a life."

Salad

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.




"StopThisAdvertising" StopThisAdvertising@Data**** wrote in message
. ..

"PC Datasheet" schreef in bericht
link.net...
I can put your sample results in a calendar form and calendar report for
you
for a reasonable fee. If you are interested, contact me at my email
address
below,


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.


--
To the OP:

Most people here have a common belief that the newsgroups are for *free
exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to
sell
his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R