Queries

  • Thread starter Thread starter Pishoy
  • Start date Start date
P

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
 
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
Click to expand...

Use a criterion

=(SELECT Max(BCrit.[your date field]) FROM B AS BCrit WHERE
BCrit.[linking field] = A.[linking field])
 
-----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
Click to expand...
tableB then use that query instead of tableB in your
orginal query
 
Back
Top