Recent content by Bobbi

Richie...I'm not sure I follow what you mean by using the query for the date. Are you suggesting that the query I created for this last problem of mine, that I have criteria in one of the sources be an ending/desired date? Bobbi

Ian...Don't be sorry for trying to help. I appreciate that very much! I did switch it and it still will not work for me. So, I took the easy way out. I created a query to gather the information and in the report did a DLookup. I feel so cheap, but I need the numbers to work right now. This...

Richie.... I don't want the sum of zero. Would this last string give me that? I was planning on trying the one Fornatian gave me later today. When these expression get this complicated it loses me. I try to only think of one step at a time but I tend to overwhelm myself easily confusing...

Richie.... With the exact expression you gave me, I'm getting a "#Name?" error. I think I understand the zero return, but I will be breaking it down even further. There are 3 phases (II, III, IV), I will add into the expression to only calculate all of this for only each individual phase. Will...

Richie...I just tried that...it's not working for me. I get the same error. What is the "0" stand for? Cuz I need to tell it to only retrieve from certain fields. Since I'm getting so detailed, that is why I'm getting lost I think. Thanks for your help!! Bobbi

Karl, that might have been the problem. I found another way to make it work. I used "DLookup" at the query and just took the total. I will go check and see if that was the possible problem though and keep that in mind in the future. Thank you very much! Bobbi

I know one of you out there can help me with this. I posted yesterday, but hoping to find some help pretty fast. Here's the deal. I have used this expression in another database and it works. But it won't in this one. The only thing I can think of, is the other database was created using...

HI...I am having a problem with a report that I'm creating. In one of the fields I am getting the error "#Name?". I have checked the ControlSource property, which is ok. I have checked the spelling, which is ok. At first they had the same name for 3 separate queries which is where I'm wanting to...