P
P51D Mustang
My monthly XL invoices list each person and the fund source charged for the
housing subsidy.
I figured out how to find the Max and Min values for the Invoice_Month for
each grant for each person and made a table from that. The problem occurs
when someone's subsidy has been charged to the same grant at 2 different time
periods, eg SPC100 01/2004 HUD064 02/2004, HUD064 03/2004 then went back to
SPC100 04/2004. I'm trying to end up with one record for each person, , eg
John Doe SPC100 from 01/04-01/04, HUD064 02/04-03/04, SPC100 04/04-04/04.
Is that possible via SQL or would it require some VBA programming voodoo?
I'm learning access as I go so bear with my longwinded exposition!
housing subsidy.
I figured out how to find the Max and Min values for the Invoice_Month for
each grant for each person and made a table from that. The problem occurs
when someone's subsidy has been charged to the same grant at 2 different time
periods, eg SPC100 01/2004 HUD064 02/2004, HUD064 03/2004 then went back to
SPC100 04/2004. I'm trying to end up with one record for each person, , eg
John Doe SPC100 from 01/04-01/04, HUD064 02/04-03/04, SPC100 04/04-04/04.
Is that possible via SQL or would it require some VBA programming voodoo?
I'm learning access as I go so bear with my longwinded exposition!