Search results

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...

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...

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...