Calculation

[Spikemannen]

Hi everybody!

I have a table:

ID (calc)
Cost per day (currency)
From (date)
To (date)
Number of people (numbers)

And I want to calculate like this:

Cost per day X Number of people X amount of days between from and to

My query looks like this now:

ID Sum:[Cost per day]*[Number of people]
tblCost

How should I continue?

Best Regardz,

Spikemannen

 

[alvechurchdata]

Try the DateDiff function

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[Spikemannen]

Thank you.

I have wrote:

Days: DateDiff("y",[From], [To])

But I get this error:

Microsoft Access
Expression syntax not valid

Best Regardz,

Spikemannen

 

[SuicidED]

Hi
DateDiff("d",[From],[To])

 

[Spikemannen]

Still the same error message.

Access marks the first , .

Best Regardz,

Spikemannen

 

[PHV]

In the query grid:
MyCalc: [Cost per day] * [Number of people] * ([To] - [From])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Spikemannen]

Thank you...

Now I got it

Best Regardz,

Spikemannen