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