If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Table design question??
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 |
#3
|
|||
|
|||
Table design question??
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 |
Thread Tools | |
Display Modes | |
|
|