[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

 

[Chevy]

Wow ... Ummm ....

Field1 - Date
Field2 - Playcount
Field3 - Desired Value

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

I'm guessing here ....

 

[misscali]

hmm..i enter in exactly (DateDiff("d",Field1,Now())/Field2) in the entry field in design view? I tried that..and I tried the same thing with an equals sign infront. both are displayed as what i typed..it doesnt calculate the function. Do I have to enter in the today's date in Now()? Tried that as well..Ugh I have no clue how to do this.

 

[Chevy]

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.

 

[misscali]

yeah i figured i would have to change the values with my names. I dont see default value though. and when i right clicked for properties, it opened the table properties. i dont think thats right.