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
|
|||
|
|||
not display date in past
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 |
#2
|
|||
|
|||
not display date in past
John
It sounds like you want to see records with a [Expiration] Date() (today's date). You could use this as a selection criterion in a query. Regards Jeff Boyce Microsoft Office/Access MVP "H0MELY" wrote in message ... 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 |
#3
|
|||
|
|||
not display date in past
Try using a calculated field.
Field: Warranty: IIF([WarrantyDate]Date(),[WarrantyDate],Null) In a query that will show the value of the field if the field is after the current date, otherwise it will show null(blank). '================================================= === John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County '================================================= === H0MELY wrote: 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 |
Thread Tools | |
Display Modes | |
|
|