Tech Support banner

Status
Not open for further replies.
1 - 5 of 5 Posts

·
Registered
Joined
·
19 Posts
Discussion Starter #1
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
 

·
Registered
Joined
·
4,890 Posts
Wow ... Ummm ....

Field1 - Date
Field2 - Playcount
Field3 - Desired Value

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

I'm guessing here ....
 

·
Registered
Joined
·
19 Posts
Discussion Starter #3
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.
 

·
Registered
Joined
·
4,890 Posts
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.
 

·
Registered
Joined
·
19 Posts
Discussion Starter #5
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.
 
1 - 5 of 5 Posts
Status
Not open for further replies.
Top