G
Guest
How can I show the remainder of the results after running a query? Eg. I
enter a date criteria which shows the user id's for that day, how can i view
the remainder user id's for that day as they will not be entered in the
table. I currently have 2 tables, the first which dispays the user names and
their id's. The second displays their user id's, a request id and the date
for that particular record. Thus for a total of 10 Users (UserId 1-10) say,
on a particular date UserID 1 & 2 have records in the second table, but the
remaining users 3-10 do not have records for that date but may have records
for other dates in the table. An simple analogy could be to show all
customers who did not place an order on a particular day. I know I have to
have a left join on the first "Users" table, but after thatt I'm stumped to
the logic of how to display the results. I've triedCould I use a subdatasheet
in any way? various SQL strings but to no avail. Please help and thanks in
advance.
enter a date criteria which shows the user id's for that day, how can i view
the remainder user id's for that day as they will not be entered in the
table. I currently have 2 tables, the first which dispays the user names and
their id's. The second displays their user id's, a request id and the date
for that particular record. Thus for a total of 10 Users (UserId 1-10) say,
on a particular date UserID 1 & 2 have records in the second table, but the
remaining users 3-10 do not have records for that date but may have records
for other dates in the table. An simple analogy could be to show all
customers who did not place an order on a particular day. I know I have to
have a left join on the first "Users" table, but after thatt I'm stumped to
the logic of how to display the results. I've triedCould I use a subdatasheet
in any way? various SQL strings but to no avail. Please help and thanks in
advance.