Tech Support Forum banner

access function

934 Views 4 Replies 2 Participants Last post by  misscali
my question is pretty simple..How do you divide in ms access? the entry of one cell divided by another.
I'm not sure if this matters, but its a number divided by the date.. (as in playcount/date added)

If that complicates it, is there a way I can convert the date to the amount of days prior to today's date? Hopefully in a non manual manner..
excel does this no problem :| grr
Not open for further replies.
1 - 2 of 5 Posts
Wow ... Ummm ....

Field1 - Date
Field2 - Playcount
Field3 - Desired Value

Field3 = (DateDiff("d",Field1,Now())/Field2)

I'm guessing here ....
In design mode, right-click on the field in question and select properties. You'll need to enter the formula there under (I think) Default Value.

Also, the formula I gave is an example ... You'll need to modify it with your field names (and probably syntax, too). The Help function in Access should get you there.
1 - 2 of 5 Posts
Not open for further replies.