Search results

Thanks, this looks like what I need, but I'm getting this error message when I run the query: Syntax error in date in query expression '[ID]<= 1 AND EmplNum = 15607'. It's recognizing some field as "date" but I don't have dates anywhere. The employee number listed here is probably the first...

VBA, I really need this to be in a query because it is just a part of a bigger picture. Here's the true Dsum: Running Sum : DSum("[License Fees with Emp #].[ContractedSale]","License Fees with Emp #","[ID]<= " & [License Fees with Emp #].[ID]) The table = License Fees with Emp # The field...

Hello, I very desperately need help with a query that I'm creating for a client as part of a bigger process. I have a running sum in a newly created field of a select query (soon to be make table query). The DSum is working fine except I need it to start over at a change in employee number...