Syntax error in control source of text box

[shaunacol]

I am trying to use a Dlookup to find out the buying price of an item but am somehow getting my syntax wring due to my lack of experience...any help appreciated...I can get it to work before I multiply by the number of tickets so I think its something going wrong there.



=DLookUp("[our buying price]","tbl_Price","[Type of Ticket]= '" & [TypeOfTicket] & "' And [SKU]= '" & [AttractionID] & "' * “ & “[nooftickets]”)

[orange]

You have some strange quotes here
* “ & “[nooftickets]”

change each of these to "


Is SKU a text or numeric?

[shaunacol]

Yes I'm sure I've done the quotes wrong somehow as I'm just copying examples from on line as don't understand syntax. Sku is text field thanks

[orange]

Did you make the changes, and did it work?

[June7]

As orange said, strange quote marks. Access doesn't like those funny slanted quote makes. Retype them.

[shaunacol]

Im afraid it still says invalid syntax - this is what it looks like now. Is it because nooftickets is numeric?

=DLookUp("[our buying price]","tbl_Price","[Type of Ticket]= '" & [TypeOfTicket] & "' And [SKU]= '" & [AttractionID] & " * " [nooftickets]")

[CJ_London]

your problem is here

....."' And [SKU]= '" & [AttractionID] & " * " [nooftickets]"

Not clear what you are trying to achieve but at the minimum you need a closing single quote and you have a surplus double quote (in blue)

if sku is constructed as something like

1234 * 34

then your code would be

....."' And [SKU]= '" & [AttractionID] & " * " & [nooftickets] & "'"

[shaunacol]

Thanks all, I was still getting #name for that code so I got rid of the multiplication and used the other dlook up and then made another text box and did the multiplication. All works fine now. Many thanks!