Recent content by markjohnson

Thats it - cheers :)

Hi, I have a report that I have called "0 Master". It details the number of complaints that my company has received, broken down by a specific service. I have a CountIIf that returns the number of complaints received in a certain category. This works - but this only shows the total number of...

Hi, I have a databse that is meant to record complainants information. I want to create a query that returns peoples information, but ONLY if they have contacted us more than once. Is that possible? If so, how? Thanks

Hi, I have a database that lists people that contact me. I want to know if people contacted me before, so i creted this code that is linked to the "Full Name" Field in my table... =IIf(DCount("*","[Contacts]","[ID]<>" & Nz([ID],0) & " And [Full Name] = '" & Replace(Nz([Full...

Yes, thats it! I think the problem was that the field was orignally a text box that i changed to a combo box. Now i have added a new combo box, and rejigged the formula, it works, so.. PROBLEM SOLVED! THANKYOU!

Hi All, I am trying to do a calculation in Access based on a value on a form. In the text box where my calculation is, it says; =[Text863]*13.59 Text863 is a combo box with dropdown list, that contains values 0.25, 0.5, 1, 1.25 etc etc However, if anything that isnt a whole number is...

No, still the same error message #Name?

When it is open, I get #Error, and when it is not #Name?

Sometimes yes, sometimes not. I get the same error both times

Hi All, This sounds pretty easy, but I cant figure it out. I have a report. It is called "6 Cost To Resolve Community Services Complaints" I have a Total field on there called "CS Total" I want the value of "CS Total" to show on another report that is currently called "Report1" At the...