Search results

Thanks you Brian, I really appreciate you give me your time and advice, I did what you recommended but still getting a error, is there anything else you would recommend ?

I'm receiving a syntax error "See Below" when I'm trying to run a Rank query. For those of you that want to see the database and how I'm running this sql in it I have attached it. I have also attached a picture of the error message I'm receiving. To explain the end result I'm trying to get is...

I'm using the formula below to get my 3Month, 6Month, 9Month, and 12Month totals for the [Amount_Actual_Loan]. I don’t thing I'm getting the information I'm actually wanting Please see below: 3Month: Sum(IIf([CORRESPONDENT_PURCHASE_DATE]>DateAdd("m",-3,Date()),[Amount_Actual_Loan],0)) 6Month...

Hi, if anyone can help me understand why when I attempt to combine all these of these queries, that I’m getting duplicity records on some of then. Am I joining them wrong, should I be doing something different, please help me learn how to correctly join these queries I have attached the db to...

I’m working on compiling three queries into on The first one counts the number of apps The next one sums the told worth of apps And the last one ranks the reps by apps Three Problems I’m having: **When running the query is takes 20 -30 minutes. (I’m assuming this is do to the Ranking...