Discountinued data/Info

[jonamua1971]

Hi All
I have a form built on query called Current Med. its have medications info for the people and we have situations where the med get discontined for some reasons. i would like to have the discontinued med info to put be into another form for discontinued meds automically but i do know how do that. Hope you get the picture.
any help will be highly appreciated.

 

[KeithG]

You could add a boolean field to the table names discontiued. And then you canmark the filed as true if the med is discontinued. Then just set up your form to show all records with the true in the new field.

 

[jonamua1971]

thank you.
it gives me where to start from.

 

[jonamua1971]

Discontinued items

still stuck need more help!

table called Current Med
person ID
Name
Purpose
RefillDate
Presc Physican

Second Table
Name
Purpose
discontuned date
Where do i go from where .confused somewhere!

 

[KeithG]

You could use the IsNull function or IsDate function to test the field. If isnull returns true then the med is not discontiued.

 

[jonamua1971]

thanks G for your response