Table design question??

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

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
-*--*--*--*--*--*--*--*-
"Norman F" wrote in message
...
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

On Thu, 29 Apr 2004 16:19:41 -0700, "Norman F"
wrote:

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public