Unjoin tables in query

[KimTong via AccessMonster.com]

Hi,

I have 2 tables (table1 & table2) in query that don't have a relational field
each other. Table1 has Date, decription & amount. Table2 has RecordNo &
filenm. I'd like to pull all fields in Table1 and only the last record of
field Filenm in table2.

How can I make a query to produce report like that. If anybody can tell me,
I'm very appreciated. Thanks


KT

 

[Guest]

First create a query called qryLastFilenm that sorts the records in Table2 so
that the appropriate record always shows up last.

Then in a column in a query based on Table1, put the following:

LastFileNM: DLast("[Filenm]","Table2")

 

[KimTong via AccessMonster.com]

It works. Thank you very much....

First create a query called qryLastFilenm that sorts the records in Table2 so
that the appropriate record always shows up last.

Then in a column in a query based on Table1, put the following:

LastFileNM: DLast("[Filenm]","Table2")

Hi,

[quoted text clipped - 7 lines]

KT