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

Calling query which uses alias results in different value

P: n/a
Hello, and thank you for your help. I have a query that I call from a
VBA function which results in a different value than when viewed in the
datasheet window. The query does a calculation, and stores an
intermediate value using an alias, then uses that value to
format(round()) so that a pdf file can accept it. If I don't use the
intermediate alias (I use it as this value is also used for other
calculations) it works fine. Also, when I view the value either in
datasheet view, or from within a form - it's correct. But after coming
out of the function - it is incorrect.

Does anyone have any idea why this would happen?

Thank you again for your help.

Mar 1 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.