Search results

Thank you very much for your response, however this still goes not give me a result, only a #error? Also, I never remember to use the "chr(34)" instead of the double quotes, it is much easier to read, I will make this a standard going forward!

This is very good background, and I believe I even had it written this way at one point but was still (and currently) getting the #error. I think this gets back to my original question, is there a more efficient way to say sum up "Debits" for Account Number X for the month of X on a form?

Its only a 4 digit date field (01/28), as everything relates to the current year. Nothing I can do about this format

Even with the brackets, I still get an error, Is there a more efficient way to get this answer? For example taking the left 2 characters from the date field? But then wouldn't there have to be an array to say "01"=January... I thought it may be easier to have an expression where it gives the...

My question has a little bit of a twist from the information (which is extensive) I find in my search. I want to do a dsum in an unbound text box on a form, I need it to look at a query and sum the "Debit" field based on 2 criteria, Criteria 1:account number in question Criteria 2: Paid in...

I was able to figure this out, and, for anyone who faces the same problem, this is the answer,DLookUp(Format(DateAdd("m",-2,Date()),"mmmm"),"qrySalaries","COST_CENTER=3200")

I have 2 formulas that I need to combine for a report that I am creating, the first one pull the name of the previous month: =Format$(DateAdd("m",-1,Now()),"mmmm") The second one is a dlookup, Where I am trying to pull a value from the previous month...