textbox formatting

[jlabre01]

Hi,
I'm having problems with the syntax on a query for a text box, i want it to check a couple values from the same table then output a 3rd value from that table, but access keeps saying there is a syntax error, please help, query is listed below:

=SELECT [Price List].Price, [Price List].ServiceID, [Price List].PriceCategoryID FROM [Price List] WHERE (([Price List].ServiceID = [Forms]![SubQuotes Subform]![ServiceID]) && ([Price List].PriceCategoryID = [Forms]![Quotes]![PriceCategoryID]));

 

[Kiwiman]

Howzit

Try changing the two ampersands with "AND"

=SELECT [Price List].Price, [Price List].ServiceID, [Price List].PriceCategoryID FROM [Price List] WHERE ((([Price List].ServiceID)= [Forms]![SubQuotes Subform]![ServiceID]) AND (([Price List].PriceCategoryID)= [Forms]![Quotes]![PriceCategoryID]));