a query parameter for two dates

[Guest]

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

 

[Guest]

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?

 

[Guest]

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

 

[Guest]

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?

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

Harry

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.

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

 

[Guest]

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

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

Harry

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.

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