Access 2000 - Dates

[JJeremy]

Hello All,

I have tbl_1 with less date and I have tbl_2 with all dates. I want to grab tbl_1 dates = tbl_2 and also grab > tbl_1 dates on tbl_2 on a query. How do I that? Please help. Thanks.

JJeremy

Analyst
Lakewood, CA

 

[fredericofonseca]

you use a SELECT, associated with WHERE, and eventually a INNER JOIN

Once you have some code please come back to us if you have specific problems.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[SkipVought]

Sounds like an OUTTER JOIN, not INNER JOIN.

Right click the JOIN LINK and select all from tbl_2 and those that match in tbl_1

Skip,

_{[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie!}