Search results

Thank you for your help. My problem was resolved more easily that i had thinking. I created a new query without group by and the result that i expected was obtained. Now...I have one more question: If i want that my access file update one table linked to an odbc and export file update to one...

I will do this. Thank you for your suggestion :)

I will think about my problem and test other forms and then I share with you. But I thank you for your help.

Right My data are being grouped...I need them grouped...but i need also see my IDs...each one in one line...and actually is not happen...this is the problem... Can I Grouped my books for their author and year but show also their unique ID. Actually access group my books for their author and...

Yes I have a GROUPED BY This is probably an stupid question (sorry)...but I am starting learning and working with this. I can simply remove all GROUPED BY ? Thank you :)

Right :) My Append queries add records to a table. The problem is that the records add to a table are "grouped" in one line and my goal is to have several lines. Something like this... Ex: Author of Book Title of Book ID A B 3...

Hi people, I need urgent help with an access database. I have an append query that give me a table. But I did something wrong, because I have my IDs grouped in one line, when my idea were to have one line for one ID. I think that probably I wrote something wrong in my SQL code. Can I help...