Report showing sites with no activity

M

martin

Hi

It's been a while for me and I'm sure this is probably quite simple,
but I have a table listing sites, I have another table listing site
activity, I have a common field in both of "Site Code".

I need to generate a report showing all sites that have had no
activity since a given date (that the user needs to input). Can
anybody please give me some hints as to how I can do this with a
query expression ?

Thanks guys

Martin
 
A

Allen Browne

Not that it might be best to use the subquery in the WhereCondition of
OpenReport.
 
J

John Spencer

I think that Allen meant to say
"Note that it ..."

If you need specific help with setting up the query, post back with your table
names and field names. And we can try to help you with the specific SQL
statement you would need.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top