S
Sinner
Hi,
I have a union of 3 tables.
I have and ID table in which I have user name, location, selection
(YES-NO).
I have another query in which I get the result as per selected users.
I add new data to a table & then include it in the above union & carry
on.
I can also make a consolidated with 'MAKE TABLE' but since data in all
4 tables tend to update, I have kept each in seperate tables.
Now one of the users has changed/left location. If I select NO in the
ID table, it will omit all the lines against that user in back dates
with same user & location.
Now here is what is required.
In new query, I want to have the lines of old user & in new date not
to show old user lines.
User left on Dec 01, 2008.
Also I have a new user who had some previous entries as well.
His old entries should not populate. His entries after Dec 01, 2008
should show in query.
Here is summary.
Include old user entries till Dec 01, 2008.
Exclude old user entries after Dec 01, 2008.
Include new user entries after Dec 01, 2008.
Exclude new user entries before Dec 01, 2008.
Thx.
I have a union of 3 tables.
I have and ID table in which I have user name, location, selection
(YES-NO).
I have another query in which I get the result as per selected users.
I add new data to a table & then include it in the above union & carry
on.
I can also make a consolidated with 'MAKE TABLE' but since data in all
4 tables tend to update, I have kept each in seperate tables.
Now one of the users has changed/left location. If I select NO in the
ID table, it will omit all the lines against that user in back dates
with same user & location.
Now here is what is required.
In new query, I want to have the lines of old user & in new date not
to show old user lines.
User left on Dec 01, 2008.
Also I have a new user who had some previous entries as well.
His old entries should not populate. His entries after Dec 01, 2008
should show in query.
Here is summary.
Include old user entries till Dec 01, 2008.
Exclude old user entries after Dec 01, 2008.
Include new user entries after Dec 01, 2008.
Exclude new user entries before Dec 01, 2008.
Thx.