Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
merging two queries
Thank you very much I've been trying for what seems like forever to get this query to work and this: select J.date , J.[job id] , clients.[company name] , cars.car_registration , clients.[contact name] , clients.discount , price_list.[customer price] ... -
merging two queries
if you mean taking the and J.date between #1/1/2003# and #2/1/2003# out of the bottom that makes no effect,,, fini123 -
merging two queries
many thanks, but this code: select J.date , J.[job id] , clients.[company name] , cars.car_registration , clients.[contact name] , clients.discount , price_list.[customer price] , 5*price_list.[customer price] as total from (( clients inner join... -
merging two queries
I presume you meant this (got rid of _'s in some): SELECT J.date, J.[job id], clients.[company name], cars.car_registration, clients.[contact name], clients.discount, price_list.[customer price], 5*price_list.[customer price] AS total FROM ((clients INNER JOIN cars ON clients.company =... -
merging two queries
I have an existing query which goes as follows: SELECT job.date, job[job id], clients.[company name], cars.car_registration, clients.[contact name], clients.discount, price_list.[customer price], 5*price)list.[customer price] AS total FROM price_list INNER JOIN (clients INNER JOIN (cars INNER... -
-
wierd error
no I've checked it several times and its all there. When I add a record after the 4'th (which is the last) record i can then see all the data in the 4'th one, but not the one after that... it is always the last record no matter what the id is.. fini123 -
wierd error
I'm currently getting a wierd error... when i use the code below... SELECT clients.[company name], cars.car_registration, price_list.[tyre id], -1*(front_left_tyre+front_right_tyre+rear_left_tyre+rear_right_tyre+spare_tyre) AS [tyre quantity], price_list.[customer price], clients.discount...
