473,467 Members | 1,481 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Formula for Access

2 New Member
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
4 1883
zmbd
5,501 Recognized Expert Moderator Expert
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
mattb2bad
2 New Member
Sorry, but i do not quite understand what you mean by "double quote" =/
Nov 12 '12 #3
zmbd
5,501 Recognized Expert Moderator Expert
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
NeoPa
32,556 Recognized Expert Moderator MVP
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

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

Similar topics

1
by: Dim | last post by:
Hi, need some help/idea... I have data table in Excel(about 30 columns) and it's getting too big (over 65K) so I need to move it to DB (MS Access is the choice) one of the columns (for example...
14
by: Crimsonwingz | last post by:
Need to calculate a sum based on a number of factors over a period of years. I can use formula ^x for some of it, but need totals to carry over in the sum and have only been able to do this thus...
7
by: Helen | last post by:
vb .net 200 crystal reports Oracl Acces Hi, I have all selection formula results needed from the main crystal report, called in the vb form (Oracle db) I now need to build in the logic in...
0
by: RJN | last post by:
Hi I have a main report and a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be evaluated after the formula in the main...
0
by: RJN | last post by:
Hi Sorry for posting this message again. I have a main report and a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be...
0
by: rjn | last post by:
Hi I have a main report in which I have inserted a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be evaluated after the...
5
by: nedian | last post by:
Hello I am student and trying to learn access.I am having problem in making a program can any one help me? i wanted to make 2 tables in access and then create a link.First i am telling u what...
0
by: toton.basak | last post by:
In C++ any i can simulate some restricted access modifiers based on association & inheritance? eg, class BombMaker{ private: void makeAtomBomb(){ std::cout<<"making atom bomb\n"; } int...
2
by: welshkaiboy | last post by:
Due to the size of the data I have to manipulate I need to apply a excel formula in access which determines date of manufacture from a serial number 716001 so I use...
24
by: joeldault | last post by:
Question For Microsoft Access Data Base -------------------------------------------------------------------------------- I am Trying to create a single formula that would do the following: If...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.