Search results for query: *

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] ...

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

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...

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 =...

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...

no its an MS Access database... fini123

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

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...