S
Shanin
I keep having problems with this type of query when I get more than two
items, so I don't know if it's possible.
I would really like to make a query that counts 4 separate fields, one which
is from a separate table, between a variable of a date range. It's for
applicants coming in, we want to have a report that shows the number of
applicants in, number of interviews, number of new hires, and the number of
current open positions for a date range.
Currently this applicant stuff is something we had on an Excel sheet which I
imported to Access. The fields in this table (there is only one table) that
need to be counted are: ApplicantIN(Date field), Hired(yes/no field),
InterviewDate(Date field).
The other table is in a separate database that is secure, so I built the
query in that database and linked the table from the other. The open
positions are what is stored in this database. The table name is tblSchedule
and the field that would need to be counted in this would be EmployeeID, but
only if it is null.
If the last cannot be counted with the three from the other database, that
is fine, since I can run that separatly, but I would really at least like to
to get the first three to be counted in one query so I can put it all on one
report.
So basically what I would like to be able to do is to enter a date range and
count the number of applicants, number of new hires, and number of interviews
for that date range, and count the current open positions.
items, so I don't know if it's possible.
I would really like to make a query that counts 4 separate fields, one which
is from a separate table, between a variable of a date range. It's for
applicants coming in, we want to have a report that shows the number of
applicants in, number of interviews, number of new hires, and the number of
current open positions for a date range.
Currently this applicant stuff is something we had on an Excel sheet which I
imported to Access. The fields in this table (there is only one table) that
need to be counted are: ApplicantIN(Date field), Hired(yes/no field),
InterviewDate(Date field).
The other table is in a separate database that is secure, so I built the
query in that database and linked the table from the other. The open
positions are what is stored in this database. The table name is tblSchedule
and the field that would need to be counted in this would be EmployeeID, but
only if it is null.
If the last cannot be counted with the three from the other database, that
is fine, since I can run that separatly, but I would really at least like to
to get the first three to be counted in one query so I can put it all on one
report.
So basically what I would like to be able to do is to enter a date range and
count the number of applicants, number of new hires, and number of interviews
for that date range, and count the current open positions.