Hi
I need to make a calculated filed in access 2007,
actually i have two date fileds which have to be calculated and inserted
in separate column , it's possible by Access 2010 but
i can't do it in 2007
Please Help me
Thanks
Hi
I need to make a calculated filed in access 2007,
actually i have two date fileds which have to be calculated and inserted
in separate column , it's possible by Access 2010 but
i can't do it in 2007
Please Help me
Thanks
I think we need more details.
Calculated fields are done in queries.
Do you know how to write expressions (calculated fields) in queries?
For Example we have two fields named (Enter_Time , Exit_Time) for each person
exp:
Enter_Time ==> 8:30
Exit_Time ==> 14:00
i need to put 5:30 which is 14:00 - 8:30 (duration time) in other field
and then i can make query on calculated filed
any better idea ?
You don't actually store the calculation in a field in a table, but rather do the calculation in the query itself.
If some value can be calculated, there is no reason to store the calculation in a table (and it actually violates rules of normalization to do so).
Perhaps you are referring to the new Calculated Data Type field that Access offers in versions newer than 2010 (see: http://www.quepublishing.com/article...aspx?p=1594884).
Unfortunately, Access 2007 does not have that. So you can also store the values of calculations, but not the calculations themselves in tables. Which goes to my comments about queries...
So if you are using Access 2007, you won't be able to store the calculations in tables.
anyway .. How can i get the above scenario done ?
without calculated filed ..
I don't understand.
How do you think you can perform a calculation without doing a calculation?
As I said and referenced, you CANNOT store calculations in table fields in Access 2007. So if you are trying to do this in Access 2007, I am afraid you are limited to doing it in a query, or to try to use VBA. But you would have to have some event trigger the VBA. It won't be automatic if they update the table directly.
What's the big hang-up on doing it in a query anyway?