Search results for query: *

Hello, I have a report that I created (births). I have set it up so that when I print, it sends it directly to WINFAX for faxing to a community. The problem is as follows: I have set up my query so that it groups by community. I can either print up a report for 1 community or for all...

Unfortunately, I am stuck with the existing table structure. I wouldn't worry too much about [disease2] or [disease3]. I can find an easy way around that. The crux of my problem is that I need to list the distict occurences in my field [disease1], while producing a sum of total occurences.

Hey folks, I have a small problem I was hoping someone could help me with. I have a report based on a query (access 2002). I would like to count the frequency of all distinct records in the following fields: [disease1],[disease2] and [disease3], listing the disease and the combined...

Thanks for all the posts - I will never "repeat never" underestimnate the power of the inverted date! many thanks to all! (:-

Hi Bob, I had initially tried something similart to what you suggested and I got "expression too complicated" error. I've tried the code that you gave me and got the same answer. thanks, Rugbyguy (AKA Rob)

I've used this code in my parametre in the query but I don't think that I've got the syntax quite right.... >=[Please Enter Report Start date MMYY] WHERE Mid(MMYY,3,2) & Left(MMYY,2) Between Format( [Reporting_Period] ,"yymm") AND Format(reporting_period!ToDate) And <=[Please Enter Report End...

Here is what is entered in the control in my report. =Where([Reporting_Period] Between Format(Reports!notifiable_diseases!reporting_period,"mmyy") And Format(Reports!notifiable_diseases!reporting_period,"mmyy")) I also have the following criteria in my query [notifiable_diseases]: >=[Please...

I apologize Skip, I guess that I'm not really getting my head around this problem (not to mention I hate having to deal with dates!) I've entered the code as written in the control for an unbound object in my report, but it gives me an error. Rugbyguy

that is correct. I can't really change the type of data that is entered. It is an automated process. therefor, the reporting_period field is text and 4 characters. This allows me to keep the leading 0's.

I have tried using the following: =[Reporting_Period] WHERE Mid(MMYY,3,2) & Left(MMYY,2) Between Format(reports!notifiable_diseases!reporting_period,"yymm") AND Format(reports!notifiable_diseases!reporting_period) In my control source for the report. Alas, no success. Advice? where should I...

My only question is as follows; since I don't need to modify the table, should the =Format([notification_date], "mmyy") >= Me!Start be entered in the report in the control section? My 4 digit variable MMYY is called "notification_date". I tried entering the above and got an error. Thank You

Help please, I am trying to query a database (access 2003). The date that is stored in my database is in MMYY format (I know - not too swift of me for digging my own hole!) I have created a query parametre that asks for 'beginning date' and 'end date'. The problem is that Access does not...

Thanks for the replies - I've used the count function and it works well. The problem is as follows - my field [birth_type] has 2 variables in it -"live" and "Still/Mis". When I put "live" in the criteria of my query - it returns all the lives births. Problem is that I also need all the...

Hope someone can help, I am using DCount in a report to count all live births (all communties). Using the script below it does this job well. My problem is when I sort my report by community, it still returns all births for all cummunities. My report is based on a query, with a community and...