Sales Not Entered - Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all!
I have gotten valuable help on this forum before and I was hoping that today
would not be any different... Here's the situation... I have a team of
salespeople who enter in their backlog numbers everyday (or at least they are
supposed to). Right now I have it set up that they open the form for their
team, choose their name, and enter in their own data. This creates a new
record. What I need now is to show WHO didn't enter in their data for that
day. I have about 30 employees that I need to track. Each day (1/9, 1/10,
1/11, etc...) I need to have ALL the names of employees show up and to tell
me who has data entered. I hope this makes sense! Thank you for your help in
advance!
 
Hi Singinbeauty,

You might want to try using a crosstab query for this purpose.
Crosstab Queries
http://www.access.qbuilt.com/html/crosstab_queries.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hello all!
I have gotten valuable help on this forum before and I was hoping that today
would not be any different... Here's the situation... I have a team of
salespeople who enter in their backlog numbers everyday (or at least they are
supposed to). Right now I have it set up that they open the form for their
team, choose their name, and enter in their own data. This creates a new
record. What I need now is to show WHO didn't enter in their data for that
day. I have about 30 employees that I need to track. Each day (1/9, 1/10,
1/11, etc...) I need to have ALL the names of employees show up and to tell
me who has data entered. I hope this makes sense! Thank you for your help in
advance!
 
Back
Top