G
Guest
Ok, this maybe isn't the right place for this, but I posted it in reports
almost a month ago and got zero responses.
What I have is a report which we call our Job Log. We print this weekly to
tally up the number of jobs that have been entered into our system in the
previous week. We have an auto-fill field which puts the current date into a
record every time a new record is created, and to do this report, we search
based on a date range in that field. We track jobs by an assigned job number,
current typical jobs are something like 9235.
What I want to do is just add up the number of records that are included in
the report, so that we know in a quick glance the number of jobs we've
entered in a date range (week, month, year). Sounds simple, except not all of
our jobs get a number; some of them are sub-jobs, like 9235A, 9235B, etc. So
I can't just ask the report to add/subtract job#s because the "job number"
field isn't a numerical field.
I have an auto-number field (which isn't something users can't tamper with),
which I could use, but I don't know how to set up a query or an expression to
do this.
To clarify really quick; I have auto-number "Record#", an enter-the-text
"Job#" and what I'm trying to do is add up the records in a report after I
run a query on an auto-number "Date" field.
Any suggestions/advice is greatly appreciated.
Thanks,
Melissa
almost a month ago and got zero responses.
What I have is a report which we call our Job Log. We print this weekly to
tally up the number of jobs that have been entered into our system in the
previous week. We have an auto-fill field which puts the current date into a
record every time a new record is created, and to do this report, we search
based on a date range in that field. We track jobs by an assigned job number,
current typical jobs are something like 9235.
What I want to do is just add up the number of records that are included in
the report, so that we know in a quick glance the number of jobs we've
entered in a date range (week, month, year). Sounds simple, except not all of
our jobs get a number; some of them are sub-jobs, like 9235A, 9235B, etc. So
I can't just ask the report to add/subtract job#s because the "job number"
field isn't a numerical field.
I have an auto-number field (which isn't something users can't tamper with),
which I could use, but I don't know how to set up a query or an expression to
do this.
To clarify really quick; I have auto-number "Record#", an enter-the-text
"Job#" and what I'm trying to do is add up the records in a report after I
run a query on an auto-number "Date" field.
Any suggestions/advice is greatly appreciated.
Thanks,
Melissa