S
SteveKap
Hello All!!
I'm extremely new to Access and trying to get something from the database
here at work. Hopefully, I can explain this so you understand. Also, I've
noticed the responses are in code .. which I assume is SQL code. Where does
one put that in a query?
Ok .. here goes:
Our database contains info that people give to us through a website. These
are live databases that update as people continue to enter information into
the site. I work in a call center an am asked to verify specific records by
telephone. Since our call center is open until 9pm west coast time, I need
to be able to exclude certain records due to time. Therefore, I wanted to be
able to see, through a query, which records are in which timezone.
In the main database, there is a field that lists the state the person called
from. I've created 4 simple queries that break out the records by timezone
by restricting the states it shows. Now, I want to run one query that gives
me a total of each of the 4. One would think it was as easy as a crosstab
query, but I'm not doing something right.
Any help you can offer would be appreciated!!
I'm extremely new to Access and trying to get something from the database
here at work. Hopefully, I can explain this so you understand. Also, I've
noticed the responses are in code .. which I assume is SQL code. Where does
one put that in a query?
Ok .. here goes:
Our database contains info that people give to us through a website. These
are live databases that update as people continue to enter information into
the site. I work in a call center an am asked to verify specific records by
telephone. Since our call center is open until 9pm west coast time, I need
to be able to exclude certain records due to time. Therefore, I wanted to be
able to see, through a query, which records are in which timezone.
In the main database, there is a field that lists the state the person called
from. I've created 4 simple queries that break out the records by timezone
by restricting the states it shows. Now, I want to run one query that gives
me a total of each of the 4. One would think it was as easy as a crosstab
query, but I'm not doing something right.
Any help you can offer would be appreciated!!