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

Formula for Access

P: 2
Hello there,

I am having a slight issue with a formula input for Access. our teacher gave us this formula to put in for a specific step and i keep getting the error code 2048. Can someone please explain what i am possibly doing wrong? Thanks. Here is the formula we were asked to put in under an IIf Function.

Expand|Select|Wrap|Line Numbers
  1. Bonus: Sum(IIf([SalePrice]>=20000,"$250 ,0))
Nov 12 '12 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 5K+
P: 5,287
Normally, we do not answer homework questions unless they are of the Rubik’s Cube variety....

However, I'll make this one exception and give you a hint due to the fact I hate Gremlins... and you have one named the "Double Quote" in your formula. The error message you received should have put you in the right direction... try it again and very carefully read the error description along with my hint... it'll be a head-against-the-wall moment when you figure it out - I promise! It's that easy!
Nov 12 '12 #2

P: 2
Sorry, but i do not quite understand what you mean by "double quote" =/
Nov 12 '12 #3

Expert Mod 5K+
P: 5,287
what is a "double quote"
(hint... just used two of them) :-)
Really... I'm not trying to be mean... just take a look at your formula along with the hint and the error message detail... don't over-think it.
Nov 12 '12 #4

Expert Mod 15k+
P: 31,186
A "double quote" is a character that is used to delineate literal string values in VBA. In fact, as Z says, they are the characters around the words near the start of my first sentence. A "single quote" character (') is used for literal string values in SQL.
Nov 12 '12 #5

Post your reply

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