justchillin
Registered User.
- Local time
- Today, 23:48
- Joined
- Jun 19, 2006
- Messages
- 13
Hi, can anyone help ? I have 2 tables 1 called orderforminput and another called customerdetails. If i run the following sql statment on the orderforminput table it works just great.
"SELECT orderforminput.* FROM orderforminput " & _
"WHERE orderforminput.[Customer] " & strCustomer & _
strCustomerRefCondition & "orderforminput.[Customer Ref] " & strCustomerRef & _
strDoorNumCondition & "orderforminput.[Door Num] " & strDoorNum & ";"
With this code i am trying to retrieve customer name and address from the second table and conbine the results in a query called invoicequery. I keep getting syntax error in query missin operator in query expression. I am new to access and sql can any one shed some lite PLEASE
"SELECT orderforminput.*, CustomerDetails.* FROM orderforminput INNER JOIN CustomerDetails ON orderforminput.Customer = CustomerDetails.Company" & _
"WHERE orderforminput.[Customer] " & strCustomer & _
strCustomerRefCondition & "orderforminput.[Customer Ref] " & strCustomerRef & _
strDoorNumCondition & "orderforminput.[Door Num] " & strDoorNum & ";"
"SELECT orderforminput.* FROM orderforminput " & _
"WHERE orderforminput.[Customer] " & strCustomer & _
strCustomerRefCondition & "orderforminput.[Customer Ref] " & strCustomerRef & _
strDoorNumCondition & "orderforminput.[Door Num] " & strDoorNum & ";"
With this code i am trying to retrieve customer name and address from the second table and conbine the results in a query called invoicequery. I keep getting syntax error in query missin operator in query expression. I am new to access and sql can any one shed some lite PLEASE
"SELECT orderforminput.*, CustomerDetails.* FROM orderforminput INNER JOIN CustomerDetails ON orderforminput.Customer = CustomerDetails.Company" & _
"WHERE orderforminput.[Customer] " & strCustomer & _
strCustomerRefCondition & "orderforminput.[Customer Ref] " & strCustomerRef & _
strDoorNumCondition & "orderforminput.[Door Num] " & strDoorNum & ";"