424,476 Members | 1,497 Online
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 Bonus: Sum(IIf([SalePrice]>=20000,"\$250 ,0)) Nov 12 '12 #1
4 Replies

 Expert Mod 5K+ P: 5,287 mattb2bad 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