Count

[Guest]

I am using access 97. I have a field called journals, which I enter the
journals name we receive and I have a date field in which we enter date
received. I need to do a count on the journals field. In the query I have
added my journals field and then in the next grid I have put a totals field
EG Totals: [Joranls], to count the number of journals. On the totals field
I have changed to count. I have a between dates parametor on the date
received field, I have to changed this to where. (because it will not do the
count for me). which means when I run the query it will not show my date
field. I need to be able to show the date field and still be able to do a
count on my journals field. How can I do this

 

[OfficeDev18 via AccessMonster.com]

Sorry, but in one query that won't happen.

Make a query with the following SQL:
SELECT Count(Journals) as JCount FROM YourTableName WHERE TheDateFieldName
Between SomeBeginDate And SomeEndDate;

Give the query a name. In your existing query, bring up this new query in the
query designer, and add a field in the QBE grid for JCount. Now you have
everything you need.

Hope this helps,

Sam

I am using access 97. I have a field called journals, which I enter the
journals name we receive and I have a date field in which we enter date
received. I need to do a count on the journals field. In the query I have
added my journals field and then in the next grid I have put a totals field
EG Totals: [Joranls], to count the number of journals. On the totals field
I have changed to count. I have a between dates parametor on the date
received field, I have to changed this to where. (because it will not do the
count for me). which means when I run the query it will not show my date
field. I need to be able to show the date field and still be able to do a
count on my journals field. How can I do this

 

[Guest]

Thanks for that it works fine

Sorry, but in one query that won't happen.

Make a query with the following SQL:
SELECT Count(Journals) as JCount FROM YourTableName WHERE TheDateFieldName
Between SomeBeginDate And SomeEndDate;

Give the query a name. In your existing query, bring up this new query in the
query designer, and add a field in the QBE grid for JCount. Now you have
everything you need.

Hope this helps,

Sam

I am using access 97. I have a field called journals, which I enter the
journals name we receive and I have a date field in which we enter date
received. I need to do a count on the journals field. In the query I have
added my journals field and then in the next grid I have put a totals field
EG Totals: [Joranls], to count the number of journals. On the totals field
I have changed to count. I have a between dates parametor on the date
received field, I have to changed this to where. (because it will not do the
count for me). which means when I run the query it will not show my date
field. I need to be able to show the date field and still be able to do a
count on my journals field. How can I do this