Table design question??

[Norman F]

Hi there

How can i set up a table design structrue that allows me
recording events, which are 4 month apart?

In the database I need to record 2 vaccination. the first
dose and the second dose. The second dose has to be given
in 4 month! eg: if the first dose was given on the
01/01/2004 the second dose can't be given earlier than
01/05/2004.

the table structur consists of
GroupID,LocalCategory,Datevisisted, amount_given, as core
fields.

any suggestion is much appiciacted.

Regards Norman

 

[Anne Troy]

That's fine. Now create yourself a query that adds a new field called
"VaccDue". Use this expression:

=DaveVisited+120 (which will give you a date 120 days--4 months--from the
date visited

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Com.Piersontech@Dreamboat
(Reverse it!)
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

 

[John Vinson]

Hi there

How can i set up a table design structrue that allows me
recording events, which are 4 month apart?

In the database I need to record 2 vaccination. the first
dose and the second dose. The second dose has to be given
in 4 month! eg: if the first dose was given on the
01/01/2004 the second dose can't be given earlier than
01/05/2004.

the table structur consists of
GroupID,LocalCategory,Datevisisted, amount_given, as core
fields.

Your table is fine; for two vaccinations you would just add two
records. A Query using a criterion of

= DateAdd("m", 4, [DateVisited])

would list only those records eligible for another vaccination.