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

Expression you have entered contains invalid syntax?

P: 1
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.

Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
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

Post your reply

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