Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rugbyguy

    Parse report for faxing

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

    Display and count unique in report

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

    Display and count unique in report

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

    MS Access MMYY format

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

    MS Access MMYY format

    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)
  6. rugbyguy

    MS Access MMYY format

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

    MS Access MMYY format

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

    MS Access MMYY format

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

    MS Access MMYY format

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

    MS Access MMYY format

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

    MS Access MMYY format

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

    MS Access MMYY format

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

    Access DCount problem

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

    Access DCount problem

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

Part and Inventory Search

Back
Top