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.
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
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
- Status
- Not open for further replies.
1 - 3 of 5 Posts
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 - 3 of 5 Posts
- Status
- Not open for further replies.
Tech Support Forum
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Recommended Communities
