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

Calculate Cost Per Item in 3rd Field

P: 2
I'm working on an inventory database to track the individual cost of each item I purchase. Usually items are purchased in a bag or pack.

I tried a validation rule, but received an SQL syntax error telling me it was referring to multiple columns.

SO, I went to the entry form and set up an expression there, but still no answer----just get a #Error in the field.

My expression is this:

Cost_E = [Cost_SB]/[Count_SB]

Pretty simple, or it should be, but I'm missing something.
Dec 14 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,315
What do you mean by "I went to the entry form and set up an expression there"?
Dec 14 '07 #2

Post your reply

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