K
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
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