H
H0MELY
Thank you for looking at my question.
I have a table that is full of information about phones and their
locations...we can call it a service file. The service file will contain
information such as the PhoneID, location, model, start of service, warranty
expiration, serial number, etc...
The thing to know is that anytime a phone is replaced, a new service file is
created....that means that the table could contain multiple records with the
same PhoneID. I can use a max query to determine which date is the most
recent...but here is the issue.
I have been asked to prepare a list of all of our phone assets and to
include the warranty expiration date...only if it occurs in the future. If
the warranty is expired they want that field to be empty because the phone
has no warranty. This is easy enough to do manually...but unfortunately it
needs to be in a query that is part of a reporting tool. SO, any ideas on
how I could make this happen as part of a query.
Thank you in advance for anyone who looks at this question. Any and all
suggestions are greatly appreciated.
-John
I have a table that is full of information about phones and their
locations...we can call it a service file. The service file will contain
information such as the PhoneID, location, model, start of service, warranty
expiration, serial number, etc...
The thing to know is that anytime a phone is replaced, a new service file is
created....that means that the table could contain multiple records with the
same PhoneID. I can use a max query to determine which date is the most
recent...but here is the issue.
I have been asked to prepare a list of all of our phone assets and to
include the warranty expiration date...only if it occurs in the future. If
the warranty is expired they want that field to be empty because the phone
has no warranty. This is easy enough to do manually...but unfortunately it
needs to be in a query that is part of a reporting tool. SO, any ideas on
how I could make this happen as part of a query.
Thank you in advance for anyone who looks at this question. Any and all
suggestions are greatly appreciated.
-John