Recent content by peterlum

thanks r937 that works almost perfectly but i have certain instances where there are multiple purchases on the same day, how would i go about grabbing just one, say the highest valued purchase. the reason i need this is because an account can only appear once in my report even if there are 5...

im trying to get a 1 to many join to be a 1 to 1 on a filtered criteria. So to simplify I have 2 tables Accounts | [acctnum], [name] Purchases | [acctnum], [ammount], [purchasedate] There can be many purchases to one account but I just want joins from its single most recent purchasedate. I've...

it worked! many thanks lbass. that formula looked a bit daunting at first but it makes perfect sense now. thanks so much.

20 people but not everyone has counts every month so there would probably have to be some conditional logic in there.

hey thanks for the reply lbass. gave your suggestion a shot but i think im still too noobish to apply your method sucessfully. I was thinking if there were a way of dynamiclly creating a numVar name to the PERSON and have that value sumed on month to month but when i try: numberVar...

Hi Im trying to get a count to carry over from month to month so theres a running total within the PERSON group but im having trouble since the count resets every PERSON. kinda like so DETAILS: [value] MONTH PERSON.1 COUNT of(value) PERSON.2 COUNT of(value) TOTAL X MONTH...