HOW TO QUERY BY DATE AND USER 1

[jesusbearer]

Hi! I'm new to programming and have the task of making improvements to out Access 97 database.

This is probably a no-brainer: Is there a way to query for two results from a single table? I need to show all entries by a single employee for a given week.

I am able to do a query by date using an SQL something like this:

SELECT a, b, c, usernumber, date
FROM table1
WHERE date BETWEEN [Start Date:] AND [End Date:];

And I can query by employee using this SQL:

PARAMETERS [Please enter your user number:] text;
SELECT a, b, c, date, usernumber
FROM table1
WHERE usernumber = [Please enter your user number:];

I would appreciate any advice in how to combine the two into one query. Thanks in advance!

 

[browolf]

i think u can join the 'where' statements e.g.

WHERE ( Chapters > 25 OR Chapters < 20 ) AND Published < 1945

so ...

WHERE (date BETWEEN [Start Date:] AND [End Date:]) AND usernumber = [Please enter your user number:] ===============
Security Forums

http://www.security-forums.com

 

[jesusbearer]

I'll give that a try. Thanks!

 

[jesusbearer]

Thanks, Browolf, it worked like a charm! '