I'm currently building a monster database that requires a massively intricate reporting structure.
I've hit a brick wall with a report that I need to create. I'll explain..
I have a table that includes this type of structure:
selected card # bfl access restore planning
--------------------------------------------------------------------------
yes 1 23 45 27 38
yes 2 43 12 63 24
yes 3 83 15 33 28
Now each "Card #" in the above table has "jobs" associated with it that have thier own "access" and "restore" hours. But, each specific job number can be associated with more than one "card #".
Example:
Job # Card # Access Restore
--------------------------------------------------
1 1 23 45
2 1 43 12
2 2 83 15
3 1 83 15
3 2 83 15
What I have now is a form that selects the card and a report based on that card's hours. No problem there.
But, since the card is the selectable item, I run into a problem tieing the job# to the card # and not getting duplicate job hours.
Example:
If Card # 1 is selected, my report shows all hours associated with it and since Card # 2 has the same job #, my report would calculate that job's hours twice if card # 2 is selected along with card #1.
In summary, what I need is to be able to select card #s and have all associated hours to total and if duplicate jobs happen to fall into this report, their hours are not duplicated in the calculation.
Did I confuse anyone? Sorry....
I've hit a brick wall with a report that I need to create. I'll explain..
I have a table that includes this type of structure:
selected card # bfl access restore planning
--------------------------------------------------------------------------
yes 1 23 45 27 38
yes 2 43 12 63 24
yes 3 83 15 33 28
Now each "Card #" in the above table has "jobs" associated with it that have thier own "access" and "restore" hours. But, each specific job number can be associated with more than one "card #".
Example:
Job # Card # Access Restore
--------------------------------------------------
1 1 23 45
2 1 43 12
2 2 83 15
3 1 83 15
3 2 83 15
What I have now is a form that selects the card and a report based on that card's hours. No problem there.
But, since the card is the selectable item, I run into a problem tieing the job# to the card # and not getting duplicate job hours.
Example:
If Card # 1 is selected, my report shows all hours associated with it and since Card # 2 has the same job #, my report would calculate that job's hours twice if card # 2 is selected along with card #1.
In summary, what I need is to be able to select card #s and have all associated hours to total and if duplicate jobs happen to fall into this report, their hours are not duplicated in the calculation.
Did I confuse anyone? Sorry....
Last edited:
