Queries

[Pishoy]

I'm trying to creat a query using 2 tables(A,B). Table "A"
i'm using all the information in it, but table "B" I want
to use the most recent Financial information "Date wise"

If someone can help please
Thanks

 

[John Vinson]

I'm trying to creat a query using 2 tables(A,B). Table "A"
i'm using all the information in it, but table "B" I want
to use the most recent Financial information "Date wise"

If someone can help please
Thanks

Use a criterion

=(SELECT Max(BCrit.[your date field]) FROM B AS BCrit WHERE
BCrit.[linking field] = A.[linking field])

 

[Larry]

-----Original Message-----
I'm trying to creat a query using 2 tables(A,B). Table "A"
i'm using all the information in it, but table "B" I want
to use the most recent Financial information "Date wise"

If someone can help please
Thanks

.
Try create a query with your criteria on the dates from

tableB then use that query instead of tableB in your
orginal query