R
rokjock
The database that I will be referring to in this querstion was developed to
help track interviews at a local helth care facility. The fields in my table
include: Name, Interview Date, Interview Time, and interview Location, and
State.
I am trying to develop a few queries to pull certain information out this
database. Specifically I am trying to pull out information in NUMBER.
Currently I can only figure out how to pull out the information that is
currently listed in text format. For example: We have had 57 interviews come
into the door this month. All of these inteviews are going to different
areas. How can I develop A query that will give me interviews per location
(in numerical format instead of text). When I go to query how many total
interviews we have had, I am getting names and not numbers. Any and all help
would be greatly appreciated! Thank you soooo much!!!!!
help track interviews at a local helth care facility. The fields in my table
include: Name, Interview Date, Interview Time, and interview Location, and
State.
I am trying to develop a few queries to pull certain information out this
database. Specifically I am trying to pull out information in NUMBER.
Currently I can only figure out how to pull out the information that is
currently listed in text format. For example: We have had 57 interviews come
into the door this month. All of these inteviews are going to different
areas. How can I develop A query that will give me interviews per location
(in numerical format instead of text). When I go to query how many total
interviews we have had, I am getting names and not numbers. Any and all help
would be greatly appreciated! Thank you soooo much!!!!!