Search results

hi still, there is an error message, refer attached JPEG

I pasted above codes in SQL mode, there was an error. pls refer the attachment thanks.

SELECT DiscoverMessinaCustomerT.Data, DiscoverMessinaCustomerT.Nome, DiscoverMessinaCustomerT.Cognome, DiscoverMessinaCustomerT.Nave, DiscoverMessinaCustomerT.Tour_Operator, DiscoverMessinaCustomerT.Codice_Operatore, PacchettiT.Tour_e_Escursioni, PacchettiT.Codice, PacchettiT.Adulto_€...

I went to customersearchF table in design mode and selected RUN QUERY button. and selected [Event Procedure] and pasted your codes. I got an error. maybe i dint undertand well. refer attachment. can you please tell me where should I put these codes step by step from the beginning.

hi, above mentioned commission rate (,75) is changing agent to agent (20%,25% 0%...etc). so is there any other way to generate this query (especially commision). I mean these all calculated fields using a form or any other method? thanks.

hi, thanks for the idea. i need a calculation fields also. these are already attached to query. can i do the same calculation in a report also? because i need to print the final result calculated query details : (which already exist) (I did these calculated in a query because there is no...

thanks for the advice. noted

hi, i would like the second option (partial match:) do you ask me to do this in a query? (without making a report) and kindly let me know, where should I put these codes? (select build event... VB code builder ) pls refer attached file also thanks

hi all, I created a table and made a form according to the table.now I want to run a query (or don't know if there is another easy way ) to search some details in the table and i want to print them too. Eg: by customer name, by dates, by customer sure name, by package etc... i already did this...

it works fine thanks

hi i entered above first formula to query. i got en error message like this, the expression you entered contains invalid syntax

hi, i want to deduct 25% commision from quota_totale(:[TotaleAdulti]+[TotaleRagazzi]+[TotaleBambini]) and that answer will be the final total. can you explain what formula and where I should put it? thanks

yes, thanks. You are a genius now i can see my net total in my query .great:) now i have to make a new table because this table is a little bit messed up. i hope i can manage the situation now. big thanks from italy for every one those who helped me.

ok, guys, i will go to plog choice. so kindly explain me what should I do now? (in the beginning)

which one is most suitable for my case?

dear all, I have attached my database fill. you can modify it and send back to me. so i can learn the steps by watching it. thanks.

please, I'm very new to access. what should I do now? what are the steps I can do in the query field? did I put my formulas([adulto]*[adulti]) incorrect place? in "criteria", I have to put them right?

i changed thanks. check the JPEG fill attached

no, i didn't do anything. can you explain what should i do?

ok, thanks, i have done as you said. can you please check the attached JPEG fill for verification.