a query parameter for two dates

H

harry

I am operating a database and I enter new information every day. However I
must figure out how many new entries have been placed on the database for
each month.
Can you help me please
 
K

Klatuu

Define a New Entry
How do you know it is new?
How do you want to present the information?

Need to know these three things to move forward?
 
H

harry

I enter information like (First Name) (Last Name) (HomeAddress)(Date of
Birth) (Date from )and (Date to)
 
K

Klatuu

Sorry, Harry, I still don't think I have enought information. Can you please
answer the questions in my previous post? Also, how do the start and end
dates relate to the month you want the data for?
 
H

harry

Sorry for the confusion I am very new to Access. Here goes again.
I created a database to enter information for a club the information on the
databese is First Name, Last Name, Address, Date of Birth. Accepted Not
Accepted. I need on a monthly basis need to know how many in total have been
accepted and not accepted a total figuer for each heading will do. I could
have up to 150 entries per month.

Thanks for you help

Harry
 
H

harry

I could enter data three days a week. But I must finf out how many applicants
have been accepted or not in a calancer month. ie. accepted from 1/3/06 to
31/3/06 total accepted and Total not accepted from 1/3/06 to 31/3/06.
Thanks again
Harry
 
K

Klatuu

You could use a totals query with the Count option in the Totals row of the
query builder on the Accepted column. You would also need to filter on the
correct date. I would assume that would be the Start Date. So, in your query
builder, you would need to create a calculated field for the month
DateAccepted: Month([Start Date]) and enter the month you want the count for
in the Criteria row for DateAccepted.
 
H

harry

I have no defined method. When I recieve an application thats the date I use
as my starting date and when I reply to the applicant thats the end date.

Thanks again

harry
 
H

harry

Thank you I will try that. Sorry for all the confusion.

Harry

Klatuu said:
You could use a totals query with the Count option in the Totals row of the
query builder on the Accepted column. You would also need to filter on the
correct date. I would assume that would be the Start Date. So, in your query
builder, you would need to create a calculated field for the month
DateAccepted: Month([Start Date]) and enter the month you want the count for
in the Criteria row for DateAccepted.

harry said:
Sorry for the confusion I am very new to Access. Here goes again.
I created a database to enter information for a club the information on the
databese is First Name, Last Name, Address, Date of Birth. Accepted Not
Accepted. I need on a monthly basis need to know how many in total have been
accepted and not accepted a total figuer for each heading will do. I could
have up to 150 entries per month.

Thanks for you help

Harry
Click to expand...
Click to expand...
 
K

Klatuu

No problem, Harry. Let me know how it works out.

harry said:
Thank you I will try that. Sorry for all the confusion.

Harry

Klatuu said:
You could use a totals query with the Count option in the Totals row of the
query builder on the Accepted column. You would also need to filter on the
correct date. I would assume that would be the Start Date. So, in your query
builder, you would need to create a calculated field for the month
DateAccepted: Month([Start Date]) and enter the month you want the count for
in the Criteria row for DateAccepted.

harry said:
Sorry for the confusion I am very new to Access. Here goes again.
I created a database to enter information for a club the information on the
databese is First Name, Last Name, Address, Date of Birth. Accepted Not
Accepted. I need on a monthly basis need to know how many in total have been
accepted and not accepted a total figuer for each heading will do. I could
have up to 150 entries per month.

Thanks for you help

Harry
:

Sorry, Harry, I still don't think I have enought information. Can you please
answer the questions in my previous post? Also, how do the start and end
dates relate to the month you want the data for?

:

I enter information like (First Name) (Last Name) (HomeAddress)(Date of
Birth) (Date from )and (Date to)

:

Define a New Entry
How do you know it is new?
How do you want to present the information?

Need to know these three things to move forward?

:

I am operating a database and I enter new information every day. However I
must figure out how many new entries have been placed on the database for
each month.
Can you help me please
Click to expand...
Click to expand...
Click to expand...
 
Top