Simple Count

  • Thread starter Thread starter CElogistics
  • Start date Start date
C

CElogistics

I am trying to get a simple count of records returned from a query to show up
on a report. I have a simple select query that pulls all the records from my
table that have a specific date on them. I do not need a total count, I need
an individual count for example:

Line Quant Description Date Ordered
1 4 Caulk 3/13/2006
2 6 Moulding 3/13/2006
3 10 Nails 3/13/2006

etc........

Where as "Line" is the number of records returned in the query, but counted
individually.... and printed on the report that way.

Help please!!
 
Create a query that contains a criterion condition that specifies the date
(or range of dates) you want. You can create such a query manually, or you
can do it programatically. Base your form or report on that query.

You don't say which version of Access you're using. Refer to books from
Microsoft, Sams, Sybex, and other puiblishers for detailed information about
using your version of Access.

Gordon
 
Running the report with the dates specified is not the problem. My query for
that portion of it works just fine, infact it actually prompts you for the
date before the report is run. I am using Access 2002.

I think you missed the whole question. It doesn't have to do with criteria
for the query, it has to do with wanting to number each record that is pulled
out in the search criteria. As in the example above, I am looking for how to
number each line that reports back from the query whether it finds 1 or 100.
I am sure you use DCount in some form either in the query or on the report,
but I have not been able to get it to work.

Gordon said:
Create a query that contains a criterion condition that specifies the date
(or range of dates) you want. You can create such a query manually, or you
can do it programatically. Base your form or report on that query.

You don't say which version of Access you're using. Refer to books from
Microsoft, Sams, Sybex, and other puiblishers for detailed information about
using your version of Access.

Gordon
I am trying to get a simple count of records returned from a query to show up
on a report. I have a simple select query that pulls all the records from my
Click to expand...
[quoted text clipped - 12 lines]
Help please!!
Click to expand...
Click to expand...
 
Ok I will try to explain it again in a little different terms.

I need to know how to number lines on a report. The report is based on a
query. The query pulls the details based on criteria that I determine, but
that is irrelavant. Once the query is run I may have 4 or 10 or 100 lines of
detail that have been pulled out of a table. I need to show that on a report
with each detail numbered in sequence... ie... 1 2 3 4 5 6 etc.....
depending on how may details were pulled out in the query. All I need to do
is number each detail, keeping in mind that the number of details change each
time the query is run.
 
CElogistics said:
Ok I will try to explain it again in a little different terms.

I need to know how to number lines on a report. The report is based on a
query. The query pulls the details based on criteria that I determine, but
that is irrelavant.
Click to expand...

Ok, that's clear.
Once the query is run I may have 4 or 10 or 100 lines of
detail that have been pulled out of a table. I need to show that on a report
with each detail numbered in sequence... ie... 1 2 3 4 5 6 etc.
Click to expand...

Ok, it sounds like you want to number each line of the report. If the
query pulled 50 records out of the table, there would be 50 lines on
the report (one line per record), and you want to number those lines
from 1 to 50. Is that correct?

If so, here's a solution that fredg posted in the past:

If you want to have a number increment alongside
each record, add an unbound textbox control. Set
it's ControlSource property to
=1
Set it's running sum property to
Over All

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
Back
Top