Search results

Thank you for the reply. I understand the entry, but I don't have a clue as to what's happening with the end result and Access Help is soooooooooooo not helpful. I set up the update query like Access said and input the date when prompted, but I can't find anywhere where the date is actually...

My form contains the field Bill_Date, which may or may not be input during data entry. What I need is to run a query (I think) that allows me to input a specific date that will automatically populate all Bill_Date fields that are currently null with the date specified. Eventually this will end...

Thank you Paul! I ended up with the following and it calculates correctly: =Sum(IIf([Account_Group]="MHTL" And [Equipment_Type] Not Like "POTS*" And [Service_Type]="Install",1,(IIf([Account_Group]="MHTL" And [Equipment_Type] Not Like "POTS*" And [Service_Type]="Disconnect",-1,0))))

I think I tried that, but will try it again. After breaking the code down I still couldn't get it to calculate correctly even without the POTS parameter. I'm going to work on it this weekend and see if I can figure it out. Thanks!

IIF statement with several parameters Here is the db with the report.... I almost had it, then I had ot add another parameter of <> "POTS*" to count anything not containing the word POTS.

Soooooooooo close. Expression: =Sum(IIf([Service_Type]="Install",1,IIf([Service_Type]="Disconnect",-1,0))) works correctly by bringing back 0 from both Account Groups (3 Installs - 3 Disconnects=0) Expression: =Sum(IIf([Account_Group]="MHTLCM" And...

Well, they scrapped the whole other form and went a somewhat different direction, but still an issue at hand for my IIf statement calculating correctly. *I have two Account Groups: MHTL and MHTLCM *I need to count the number of installs and subtract the number of disconnects. *The following...

Awesome! Worked like a charm. I even figured the next calculation out myself. Only a couple more to go for THIS report.

I have different fields in a table that I need to combine and count as one item. For instance, I have check boxes on my form for POTS/DSL_In and DSL_In that I want to combine in my report as just DSL and have them counted. So, if my records have 4 check boxes total selected for POTS/DSL_In and...

OMG! Thanks a million! Now, on to the more difficult tasks and getting my report to do what I want.

Ok, I see what you mean, but I don't see that I have that problem. Here is the db. It's only in the beginning stages, so it is very simple. I believe I'm going to be shopping tonight for a new book!

OK, I see what you mean, but I don't see that I have that problem. I tried uploading the db, but the zip file exceeds the limitation at 614kb.

Sorry, I don't understand what you mean. Unfortunately, since the company isn't supplying an Access book I have to wait until Wed or later for one to transfer in to the library. I'm just a temp who got asked to help out with this project 'cause no one else knows how to create what they want...

Thanks Paul, but it still didn't work. I am at a loss. Checkbox Control Source: POTS/DSL In Control Source for the footer: =Sum(IIf([POTS/DSL In]=True,1,0)) The data is there in the report, so why would I keep getting an error for the total?

I have read the many posts here regarding creating a simple COUNT function and am still unable to get my calculation to work. I have check boxes in my report that I am trying to count if selected. The calculation is in the footer. I have read in the forum and tried to use the following as...