|
| 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
May 22nd, 2006, 04:06 PM
posted to microsoft.public.access.queries
|
|||
|
|||
create a calculation from fields in different records
Am using access 2000.
I need to work out the number of days i have a document before passing it on. The received date is on 1 record and the date sent is on another. Is there an easier way of working out the days without having to add another field on the same record Thanks 
|
|
#2
May 22nd, 2006, 05:48 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
create a calculation from fields in different records
The best way is an In & out date on the same record. Do you have some common
identifier in the two records like Rental Invoice? You can put the same table in the query twice. Access adds a suffix of _1 to the second instance of the table. Then join the two on the field that has the common identifier. Then you have access to both dates. "414Carts" wrote: Am using access 2000. I need to work out the number of days i have a document before passing it on. The received date is on 1 record and the date sent is on another. Is there an easier way of working out the days without having to add another field on the same record Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sorting subform records by two fields | JohnB | Using Forms | 7 | May 17th, 2006 09:38 PM |
| Need to select a certain X records after a query in access | ab | Running & Setting Up Queries | 17 | October 11th, 2005 03:05 PM |
| Create records via code | hughess7 | General Discussion | 4 | May 23rd, 2005 08:48 AM |
| Create Multiple records in a subform base on two fields | Victor Torres | Using Forms | 3 | March 15th, 2005 04:40 PM |
| Attn Sprinks- Not duplicate insert records | babs | Using Forms | 1 | December 13th, 2004 06:25 PM |
Linear Mode
