Code:
SELECT [Job Form].[Invoice Number], [Job Form].Customer, [Job Form].[Booking Reference], [Job Form].[B/L Number], [Job Form].[Number of Containers], [Job Form].Line, [Job Form].Vessel, [Job Form].ETA, [Job Form].ETS, [Job Form].[Invoice Value (£)], [Job Form].[Cost (£)], [Job Form].[Payment Recieved (£)], [Job Form].[Payment Made], [Job Form].[Internal invoice number], [Job Form].[Payment Made], [Job Form].IntInvoice2, [Job Form].IntInvoce3
FROM [Job Form]
WHERE ((([Job Form].[Invoice Number]) Like [forms]![Search]![qinvoice] & "*") AND (([Job Form].Customer) Like [forms]![search]![qcustomer] & "*") AND (([Job Form].[Booking Reference]) Like [forms]![search]![qbooking] & "*") AND (([Job Form].[B/L Number]) Like [forms]![search]![qbl] & "*") AND (([Job Form].Line) Like [forms]![search]![qline] & "*") AND (([Job Form].[Payment Made]) Like [forms]![search]![qlinepayment] & "*")) OR ((([Job Form].[Internal invoice number]) Like [forms]![search]![qInternal] & "*")) OR ((([Job Form].IntInvoice2) Like [forms]![search]![qInternal] & "*")) OR ((([Job Form].IntInvoce3) Like [forms]![search]![qInternal] & "*"));
That is a copy of the SQL for the query. All of the invoice number text boxes in the table should be searched from the same criteria, which is entered in the text box in the search form. Thats what i want to happen anyways.
The boxes in the table i want to search are; "internal invoice number", "intinvoice 2" and "intinvoice3"
The search box with the criteria in is "qInternal"