|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
May 7th, 2009, 07:56 AM
|
|||
|
|||
|
Date Calculations
Hey, I want to calculate 2 fields of dates. So I cant specifie which dates they are, there are 2 lists of them, I want the dates to calculate row by row into another field. My database is on a video store. This query is to make a receipt for the customer to show the overall bill they have. The bill will be calculated by "Date due back" and "Returned Date." I need to find out the difference in days between these 2 dates and times them with the "Overdue cost per day" to make the total bill. sorry if this is not clear enough, im finding it hard to explain lol
|
|
#2
May 17th, 2009, 11:04 AM
|
||||
|
||||
|
In a new field in your query type the following:
=([DATEReturned]-[DateDue])*([OverdueCostPerDay]) This will create an expression Alan
__________________
Alan Sidman __________ If I helped you, I'd like to know. Click on the icon next to the thread number and tell me.
|
|
| Viewing: Dev Articles Community Forums > Databases > Database Development > Date Calculations |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
