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
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 HenricoOP
@Reply 15 months 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 15 months 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 HenricoOP
@Reply 15 months ago
I managed to resolve the issue. Thank you
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 13.
