access function

misscali · 09-11-2005, 07:16 PM

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 · 10-07-2005, 08:09 PM

Wow ... Ummm ....

Field1 - Date
Field2 - Playcount
Field3 - Desired Value

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

I'm guessing here ....

misscali · 10-07-2005, 09:23 PM

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 · 10-08-2005, 03:11 PM

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 · 10-08-2005, 04:48 PM

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.

09-11-2005, 07:16 PM	#1 (permalink)
misscali Registered User Join Date: Aug 2005 Posts: 19 OS: windows xp	access function 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

10-07-2005, 08:09 PM	#2 (permalink)
Chevy Retired Join Date: Jul 2003 Location: Notlob Posts: 5,452 OS: Vista Ultimate My System	Wow ... Ummm .... Field1 - Date Field2 - Playcount Field3 - Desired Value Field3 = (DateDiff("d",Field1,Now())/Field2) I'm guessing here ....

10-07-2005, 09:23 PM	#3 (permalink)
misscali Registered User Join Date: Aug 2005 Posts: 19 OS: windows xp	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.

10-08-2005, 03:11 PM	#4 (permalink)
Chevy Retired Join Date: Jul 2003 Location: Notlob Posts: 5,452 OS: Vista Ultimate My System	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.

10-08-2005, 04:48 PM	#5 (permalink)
misscali Registered User Join Date: Aug 2005 Posts: 19 OS: windows xp	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.