Linking Tables

[vinulopez01]

I made a new table by doing group-by max from table-A, through Query design. Now i need to include a new column from table-A that matches the content in the Max column(which i already done max group-by). I try to do some ways but its picking the whole data in Table-A( but i need only matching contents)

[twinnyfo]

I'm not sure what you mean or what you are trying to do.

Typically, it is not a good practice to create a table based on calculated data from another table.

Also, if you add the field in Table-A to your query can't you add that to your new table as well?

I am a bit confused about what you are trying to do.

[MikeTheBike]

Hi
If I understand this correctly, I believe you need to save this Max/Grpup query as a stored query and then create another query using this Max/Group query and join it to Table A by its Primery Key field(s) (and the Max() field if it is not part of the PK). You can then add as many fields from table A as you like to this second query and only get rcors that match the Max/Group query.

I don't know if that helps (or is understandable)!?


MTB

[Brilstern]

vinulopez01,

It is hard to decipher what you are attempting here. One thing to note as twinnyfo mentioned. If you are creating calculated values or a logical view of data this should be done with queries. Tables are used to store data, and you should not duplicate data in multiple tables. That causes a lot of issues. If you can clarify what it is you are trying to do we can try to help you do it :)

-SB