Search results

Thank you very much for your time I will check it out as soon as i have 5 minutes, Will get back to you Thank you again

I came here hoping to fing help, not just make me feel like a no good person. I provided the db, exactly for that pupose so i can learnn from more advanced people. :-(

I rename everything in english and changed to short text. I keep getting the :SELECT your Data Source popup. I have attached my latest version with the Query under Ebhard Test

I don't need Memo. I have Long text on my end. What should i use instead?

I tried your version and i end up with this screen (A) when i run it. Same as the other SQL from Eberhard B is the code C is the table Is it because i use a french version of Acces?

OK thank you

No, i saw my error. I changed it, but still not working Here is a snapshot of what i have so far. I do understand a little as i did some dB course a long time ago. But it's not my profession

Thank you for your reply, very interestig, but i do need to have the date as i need to nnow when is the last time i called the customer Trying to figure out what i'm doing wrong with the other SQL

Good morning, I entered the SQL and chaged the labels But when i run it this prompt come up I tried several things but it's not working. What am i doing wrong. Here is the SQL i did: SELECT A.[Clients], A.[Date du commentaire], A.Commentaire FROM AnyTable AS A INNER JOIN...

Can you help me make it happen with the database that i sent? I woud'nt know where to start doing this. I'm not advanced enough. Sorry

at the end, i need to be able to send the data into an excel sheet 3 columns, only one entry per partner. the latest information

OK, this is way out of my league. Table is Commentaire Query is Commentaire Requete Can you help me install the sql in there. Thank you in advance

Hello, I have this table that has 3 fields: Partners name, Comment Date, and Comment I want to query all the partners with the latest comment. Only 1 per partners Been trying for a while without result. Anyone can help? I can upload the db if you need Thank you Yves

I will try this. But what if i want to have a standardise report with the years in the column and all the 12 month showing all at onece in the rows even if there is no data for that particular client. It would be easier to read when you are going thru record and doing comparaison.

WOW You are a magicien. What did i do wrong?

OK, i mis-cominicate, Just realized. It works in QUERY but not on the REPORT. It is the report that provide the error.à

WOW!!! Then what is wrong?

When you are entering 9136 in the client save it and run the query, is it working?

Here you go! Client 111 will work individually id you enter '111' in the criteria, but not the other ones..

It refer to the slide 'Without 2018' Maybe i shoud have make a sample database to send you guys. Woud that be easier ?