Search results for query: *

Hello again! Ok so here is what I did to make this work. In my form that contains the dates that I needed as paramaters for the chart in my report, we had to create a table on the fly. This worked very well. I managed to generate reports according to the specified year, in between 2 years...

umm sorry, this date stuff is not quite working yet ... it keeps showing the same data everytime (all of the data actually)? I think that I got a little too excited and replied too fast but I will keep at it till I get it and let you guys know! =o)

Thank you very much MazeWorX! [thumbsup2] everything works fine your help is greatly appreciated! =o) as for murphysdad's question if your dates are dynamic then just do what MazeWorX suggested, it works like a charm but if your dates are static you can do it from the chart wizard when creating...

thanks for replying I have a quick question though, where am I supposed to put that code? You have 'me.date' so that would mean that I would put it in the form that contains those 2 dates but the syntax you provide looks like it goes into a query? once again thanks I will be working on it some...

Hello! I have a form with 2 date fields [txtDateStart] and [txtDateEnd], these 2 fields are used as parameters in my query, the syntax is right but then when I open my report I get the following message: "The Microsoft Jet database engine does not recognize "[the dates]" as valid...

Hi! I had posted a question about the DCount function a few days ago and CosmoKramer was able to help me out a bit but my expression is still not complete and I am running out of ideas as to how to solve this problem. I have created a report for viewing information on the People Affected but...

Hello! no they are not distinct text boxes I only have 5 text boxes * Quarter Control Source: = Format([DateIncident], "q") * IncidentID: Control Cource: =Count([IncidentID]) * PersonAffected1 * PersonAffected2 * PersonAffected3 Contol Source: =DCount...

I tried the code that you gave me and I will show you the data that I get in a bit. I think that I have found a solution, let me know what you think please. when I use 1) original one: =DCount("[PersonAffected]", "IncidentsByPersonQuery", "[PersonAffected] = '2'")...

Hello! I had tried a few lines of code involving quarter but without having any clue as to what I was really entering. Either way they never worked, I tried to search for information on dates and qtr but I really don't know what exactly I need to know on quarters so my searches have not been...

I am working on and incident report database. I have created a report for viewing information on the People Affected but before viewing this report, from a form, you must select who is affected from the option group .... "1" = Employee, "2" = Patient, "3" = Visitor...

W o W thank you very very much your help is GrEaTly appreciated =o)

Hey! this is my little problem . . . . I have a few checkboxes on my form, they are not part of the option group because of multiple selections. When I do a report I want to show the ones that have been selected without having to add all of them in the report so I wanted to add a text box on my...

Hello! I was just wondering how to display text in my report instead of the value number from my check boxes. I have and option group with 3 choices to pick from. chkEmployee = 1, chkPatient = 2 and chkVisitorVolunteer = 3 How do I get text in my report instead of 1,2,3 and where do I modify it...