Lesson 1 - Microsoft Access Expert 13 - Computer Learning Zone


	Back to Access Expert 13 Comments List

Upload Images @Reply Bookmark Link Email

Lesson 1

Lizelle Henrico

32 days ago

I am receiving the following error when I run the new query on Order2Q.

"Unable to Execute Query.Invalid operation or syntax using multi-value field

I checked the Lookup of all the tables in the query and they all seem ok Lookup = textbox
I am not sure where to find the multi value field in order for me to correct and run the query without errors

	Sami Shamma @Reply 32 days ago
Share the table and design view.

	Richard Rost @Reply 32 days ago
I don't think there are any multi-valued fields in this lesson at all. So you probably got something very wrong in there. Check the tables that the Order2Q is based on and make sure you don't have an invalid data type. But like Sami said, post some screenshots and see what you're dealing with.

	Lizelle Henrico OP @Reply 31 days ago
Does a change in the regional setting on my computer makes a difference because I am getting more of the errors of syntax I am not sure if the decimal symbol should be . and the list separator , or the other way round. I had to replace my hard drive and everything is a mess now.

	Sami Shamma @Reply 31 days ago
Lizelle Let's try to fix your problems one at a time. Post the table screenshot in design view. And no regional settings should not make your Access stop working.

	Lizelle Henrico OP @Reply 31 days ago
I managed to resolve the issue. Thank you

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 13.