this problem involves:

client db-each client= one record.

job db- each job has one record. one client may have multiple jobs in a day or month. also, there is a calculated field that concantates the client's number with the date, for another solution. this field may come in handy...

i want to have a field that auto fills/calculates the number of jobs worked for the current client in the current month.

ie. we worked 4 jobs for mr jones in april, 3 in may, and 6 in june.

if i'm looking at jones's jobs, i want this new field to say 4 if the job i'm looking at takes place in april, 8 if in may, and 6 if in june.

ideally i would have 2 different fields that are similar-one that counts the present month's jobs, as in the jobs in the month of _today_, and one field that counts the jobs for the month of the job date.

i hope this makes sense. i tried using a summary field, but i can't figure out how to make it count/total a number of records based on the client number/date field. as it is, all it does is return the current record number.

any help is muchly appreciated. thanks.

josh

Hi,

at right side

Job Month = Month(your job date)

Right Concanate = Customer_id & " " Month

at left side

Today'sMonth = Month(Status(CurrentDate))

Left Concanate = Customer_ID & Status(CurrentMonth)

Relationship Left Concanate::Right Concanate

Then Count(Reletionship::Record_ID)