Search results

Hi there, I am making a db that will store complaints for an institution. I currently have a Complaint ID field, however I want to append the current year to the Compalitn ID field. i tried the following: Me.f00 = Year(Now()) & f00, but got an error. Any suggestions.

Hi there I am trying to display the value of a field on a report. This field exists in a query. This is what I have right now: =[UnitConcernCount]![Ash 1] but I keep getting a #NAME whenever I run the report. Any idea on what I am doing wrong? Thanks

Hi there, I currently have a chart that displays stats (# of incidents in a hospital per ward). Currently there are 10 wards in the hospital, but I only show 8 of them in the chart. What I want to do is have a little table beside the chart that shows the name of the ward as well the percentage...

Hi there, I have a date field in my table with the following format mm/dd/yyyy. The dates in my table vary from all the way back from 1994 to today. What I am trying to do is count the number of records in each year. So have it output something like this Year Number of Records 1994...

Excellent Thanks so much that worked Your help is much appreciated.

Thank you so much that worked. however where in that query would i put the Count? Thanks

Thanks Studento However, right now they are being displayed in multiple rows. I want them in colums For example this is how it looks now North 12 South 15 East 14 I want it like this North South East 12 15 14 Any thoughts?

Hi there, I have a field called Unit in my table. That field references another table which has about 5 entries. The user can select one on the form. What I want to do is count how many times each one has been selected so that i can create a chart. The unit names are: North, West, East, South...

Thanks a lot that worked!!! The help is much appreciated.....if you dont mind so could you please explain the syntax.

hi there, I have been struggling over this the past few days and get no where. I am trying to count the number of times Yes appears in a few fields. This is what I have right now in design view: Field1YesCount: Count(IIF([Field1] = True,1,0)) Field2YesCount: Count(IIF([Field2] = True,1,0))...

hi there, I have been struggling over this the past few days and get no where. I am trying to count the number of times Yes appears in a few fields. This is what I have right now in design view: Field1YesCount: Count(IIF([Field1] = True,1,0)) Field2YesCount: Count(IIF([Field2] = True,1,0))...

I am having a problem doing the IIF statment. Is there anyway that I can avoid the else part of the IIF statment from being executed. I am genterating a report based on what a user selects on a combo box from a form. There are about five options to pick from so this is what I want...

What is happening is that I have a bunch of service names such as service treatment, programs etc.. these are all in a drop down box in my form. On the table they each have their own field with either yes or no. So the user can select which service they want to generate a report on and query...

Thanks for the help Keith, but I am still getting an error? Would a Case statement work at all?

Thanks for the help bodisathva, but i'm still getting and error. It says the query is too complex???

So just replace the If with the IFF and remove the "Then" ?? are the Else if ok?

Hi there, I currently am trying to generate a report. I have a bunch of option buttons on my form. What I am tryign to do is generate a list of each option selected. So a list of how many times each option is selected. Sicne each option has its own field in the table i'm having trouble...

Hi, I am trying to display a default value of 06 followed by 3 digits, that the user would enter in. Would this be done in the Input Mask, if so how? Thanks

Hi, I am trying to display a default value of 06 followed by 3 digits, that the user would enter in. Would this be done in the Input Mask, if so how? Thanks

Thanks Joe