Flagging samples that are reaching their expiration.

[Tinajj]

Hi,

First thank you for looking at my post, I'm pretty new to Access (just
finished a beginning college course) and have couple of quick questions. I'm
wondering how I might flag data samples that are reaching their expiration to
prevent those expired samples from remaining in a stock?

Also, I've had some difficulty looking up info on the web about flagging,
and couldn't find much in my textbook. Anyone know of some good sites for
details about flagging in Access?

Thanks very much for your input and help!
Tina

 

[Philip Herlihy]

Hi,

First thank you for looking at my post, I'm pretty new to Access (just
finished a beginning college course) and have couple of quick questions. I'm
wondering how I might flag data samples that are reaching their expiration to
prevent those expired samples from remaining in a stock?

Also, I've had some difficulty looking up info on the web about flagging,
and couldn't find much in my textbook. Anyone know of some good sites for
details about flagging in Access?

Thanks very much for your input and help!
Tina

"Flagging" is an informal term, like "highlighting". All it signifies
is a wish to identify certain records in some way. You could add a
Yes/No field and click the resulting check-box, for example.

However, that's a manual way of selecting the records. If you have a
date field in your Samples table, you could put a condition (a
"criterion") in a query to exclude (or select) only those records whose
date is earlier than a particular value. If you use a "Parameter Query"
(see Help) you can have Access prompt you for the date to use.

HTH

Phil, London

 

[Philip Herlihy]

Hi,

First thank you for looking at my post, I'm pretty new to Access (just
finished a beginning college course) and have couple of quick questions. I'm
wondering how I might flag data samples that are reaching their expiration to
prevent those expired samples from remaining in a stock?

Also, I've had some difficulty looking up info on the web about flagging,
and couldn't find much in my textbook. Anyone know of some good sites for
details about flagging in Access?

Thanks very much for your input and help!
Tina

"Flagging" is an informal term, like "highlighting". All it signifies
is a wish to identify certain records in some way. You could add a
Yes/No field and click the resulting check-box, for example.

However, that's a manual way of selecting the records. If you have a
date field in your Samples table, you could put a condition (a
"criterion") in a query to exclude (or select) only those records whose
date is earlier than a particular value. If you use a "Parameter Query"
(see Help) you can have Access prompt you for the date to use.

HTH

Phil, London

 

[Tinajj]

Thanks very much Philip! That was very helpful.

"Flagging" is an informal term, like "highlighting". All it signifies
is a wish to identify certain records in some way. You could add a
Yes/No field and click the resulting check-box, for example.

However, that's a manual way of selecting the records. If you have a
date field in your Samples table, you could put a condition (a
"criterion") in a query to exclude (or select) only those records whose
date is earlier than a particular value. If you use a "Parameter Query"
(see Help) you can have Access prompt you for the date to use.

HTH

Phil, London

 

[Tinajj]

Thanks very much Philip! That was very helpful.

"Flagging" is an informal term, like "highlighting". All it signifies
is a wish to identify certain records in some way. You could add a
Yes/No field and click the resulting check-box, for example.

However, that's a manual way of selecting the records. If you have a
date field in your Samples table, you could put a condition (a
"criterion") in a query to exclude (or select) only those records whose
date is earlier than a particular value. If you use a "Parameter Query"
(see Help) you can have Access prompt you for the date to use.

HTH

Phil, London