By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,538 Members | 875 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,538 IT Pros & Developers. It's quick & easy.

excel formula to access expression

P: 2
I am not sure why excel and access use the same method in formula. I am not access expert but been trying to figure it out.

Here is the excel formula that I would like to use in access expression


I have tried using

[NAD27_76_NORTHING] is the coorinate

Attached Images
File Type: jpg access.jpg (27.3 KB, 2962 views)
Nov 25 '09 #1
Share this Question
Share on Google+
2 Replies

P: 2
I figure it out by replacing the MOD with INT - MOD(n-d) excel and n MOD d access but it doesn't work so I replaced with n-d*INT(n/d)

Nov 25 '09 #2

Expert Mod 15k+
P: 31,662
Perhaps if you told us what the problem is we could give some consideration to it. Simply saying it doesn't work is not a great deal to work from ;)
Nov 29 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.