473,386 Members | 1,674 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Expression you have entered contains invalid syntax?

I am currently in class and the online teacher takes awhile to answer back so I will try here. We are to follow a text book and it says to make a query. I have done that but then says in the first columns field box to type MinimumInvoiceAmt: (including the colon). When I do, I get the error message saying i have entered an invalid syntax?
Oct 4 '17 #1

✓ answered by NeoPa

Hi.

I suggest you reread the instructions carefully as box can be misleading. It's hard to tell from the little information whether this is the name of a field in your data (Unusual/almost idiotic to include semi-colon but missing spaces tends to lean towards field name rather than label.) or just the information to show for a label.

Bear in mind all controls have properties so you also need to consider which property you should be entering that value into.

Good luck with your work and I hope you enjoy using Access as most here have enjoyed it.

1 1952
NeoPa
32,556 Expert Mod 16PB
Hi.

I suggest you reread the instructions carefully as box can be misleading. It's hard to tell from the little information whether this is the name of a field in your data (Unusual/almost idiotic to include semi-colon but missing spaces tends to lean towards field name rather than label.) or just the information to show for a label.

Bear in mind all controls have properties so you also need to consider which property you should be entering that value into.

Good luck with your work and I hope you enjoy using Access as most here have enjoyed it.
Oct 4 '17 #2

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

Similar topics

4
by: Bradley Kite | last post by:
Hi all. I'm trying to diagnose/solve a problem with internet explorer, whereby sometimes the form submits, and other times IE produces an 'invalid syntax' error. First, I have a form, and...
10
by: ronrsr | last post by:
no matter where I place this imported file,the statement after it in the main program gets a syntax error, regardless of the syntax. I think I may have changed something in this file, but I'm...
8
by: glitke | last post by:
I need the quantity entered in a field to be <= a certain quantity. I've opened the field properties and entered the following under the "Validation Rule". <= ( sum ( ( ! ) Where ( ( ! = ) AND (...
5
by: curtok | last post by:
I am having trouble trying to get and expression to work. I keep getting the same syntax error, you may have entered and operand without an operator. What i am trying to do: one field contains a...
2
by: shalskedar | last post by:
I 've created Report in Ms access which contains subform.The field value in the report is retrieved from the subform.When this report is exported,it shows the error as The expression you entered has...
1
by: Steven Hayes | last post by:
I am trying to convert this excel expression into an Access expression: =IF(OR(B79="",B62="", H7=""),"Required Fields Incomplete",IF(AND(F87<20000,OR(J87>P14, B87>P37)),"Yes, this is a HIGH COST...
3
by: Dobletz | last post by:
I have a query in which I am trying to return values for one of 3 conditions, <,> and =. See code below: =IIf(->0,"N/A"),IIf(-=0,"0.0%",IIf(-<0,/,"0.0%")) Access will accept the second to IIF...
3
by: Norgi | last post by:
kk so ive been looking at it (and im pretty new to access) but i dont know what is wrong with my statement plz help = SiteIncome IIf(.=1, ., IIf(.=2, ., ...
1
by: MarcinM | last post by:
Hello, Once I delete a record on a form (form has a subform) using a button available on a ribbon the following error window is displayed: „You entered an expression that has an invalid reference...
1
by: djm0427 | last post by:
I am trying to create an expresion that if one field is equal to close or if a calculation is less than 0 then 0 else the results of the calculation. IIf(="Closed" OR...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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
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
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
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.