Search results for query: *

yes ive tried it with the ';' and still get the error.. i cant switch to design veiw either....gives the error message. ------ eXtacy

im still getting an error...missing operator in query expression in the inner join part.. ------ eXtacy

i get a syntax error....it says missing operator in query expression 'Transaction.Registration_Number = Transaction.Registration_Number Inner Join Car_Details.CompanyID = Company_Details.CompanyID' ------ eXtacy

opps....no it is'nt ........i thought it was i tried it and it works thanks for your help... ------ eXtacy

thanks for your reply.... yes it is... ------ eXtacy

...type mismatch error: SELECT DISTINCT Transaction.Invoice_Number, Transaction.Number_of_Tyres_Fitted, Price.Price_Ex_VAT, [Number_of_Tyres_Fitted]*[Price_Ex_VAT] AS Subtotal, [Subtotal]*1.175 AS Total FROM Company_Details INNER JOIN (Price INNER JOIN (Car_Details INNER JOIN [Transaction] ON...

...to do is to create a query which would display the details of all transactions together with the price (excluding vat), the subtotal (price_ex_vat * number_of_tyres_fitted), price after discount (subtotal - discount)(discount from the company_details table), and finally the total price...

Nice one Kenwright!! ------ eXtacy

extacyman007@hotmail.com ------ eXtacy

yes please could you..........that would be greatly appreciated.....youve been most helpfull. How can i recieve it? ------ eXtacy

hi bluedragon Thanks for that....I have a problem though.. I have copied the VBA Code in SHEET1's code window and now i am trying to run it. I am totally new to VBA... i only know a few things.... please could you tell me how i could run the code or what other things i need to do to make it...

Would you know the VBA code by any chance then? ------ eXtacy

Hi Isnt there a different way......I tried it the way in the post above but i would still takes time. I want it to perform this action automatically as this table is always updated and new information is always added. This is part of my company records and it takes a real long time to update...

Hi geoCan, i dunno what happened. neway here is what i am trying to do. I have this excel spreadsheet which contains clients information. An example of the spreadsheet is below. id Name Amount NoOfWeeks line1/ 1 JHON 1 1 line2/ 1 JHON...

Hi I have this excel spreadsheet which contains clients information. An example of the spreadsheet is below. id Name Amount NoOfWeeks line1/ 1 JHON 1 1 line2/ 1 JHON 15 14 line3/ 2 PETER 2 2 line4/ 2 3 3 line5/ 3 CHRIS 8 5 line6/ 3 10 9 line7/ 4 JAMES 4 4 line8/ 4...

Thanks alot for your help Paul :) it worked.

Thanks alot Golom..... It worked.

Hi I have created a query which gives an output of something like this: IDNO NAME COST 34 Twigg £500 110 Rich £200 120 Gray £150 34 Twigg £2000 86 Kemp £100 86 Kemp £100 12 James £200 what i am trying to do is to group the ID numbers together and add the costs so that i would get the...

Hi I have created a query which gives an output of something like this: IDNO NAME COST 34 Twigg £500 110 Rich £200 120 Gray £150 34 Twigg £2000 86 Kemp £100 86 Kemp £100 12 James £200 what i am trying to do is to group the ID numbers together and add the costs so that i would get the...

hi!! Thanks alot CajunCenturion.....That solved my problem!! its my first time i have posted a message here and never thought i would get a reply. U made my day!! thanks again!!