Unjoin tables in query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KimTong - 26 Jul 2007 16:25 GMT

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

Reply to this Message

Jerry Whittle - 26 Jul 2007 17:30 GMT

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")

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> Hi,
>
[quoted text clipped - 7 lines]
>
> KT

Reply to this Message

KimTong - 26 Jul 2007 18:57 GMT

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.
[quoted text clipped - 7 lines]
>>
>> KT

Reply to this Message