User Profile

Collapse

Profile Sidebar

Collapse
dunkleypilot
dunkleypilot
Last Activity: Mar 2 '07, 11:42 PM
Joined: Sep 13 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • dunkleypilot
    replied to Returning the first value For a Date Range on a Form (DLookup?)
    in Access
    Wonderful!

    Thanks so much, those solved all my problems. I am still learning about all the syntax and the way to use functions. They are all there in my head it's just a matter of putting them down right order. Thanks again

    Steve
    See more | Go to post

      Leave a comment:

    • dunkleypilot
      replied to Returning the first value For a Date Range on a Form (DLookup?)
      in Access
      Thanks Mary,

      The first one worked, however I had to change it to:

      =DMin("[HobbsOut]","FOR","[AircraftID]=6 AND
      Year([Date])=Year(Date()) AND Month([Date])=Month(Date())-1 AND Day(1)")

      by adding the AND Day(1) to get the first day of the month.

      Now I'm trying to use DMax Function

      =DMax("[HobbsIn]","FOR","[AircraftID]=6...
      See more | Go to post

        Leave a comment:

      • dunkleypilot
        replied to Returning the first value For a Date Range on a Form (DLookup?)
        in Access
        This is what I tried:

        =DMin([HourMeterOut],[FOR],[AircraftID]=3 And [Date]=DateSerial(Yea r(Date()),Month (Date())-1,1))

        It came back with "#Name?" error when I loaded the form.

        I also tried:

        =DMin("[HobbsOut]","[FOR]","[Date]=DateSerial(Yea r(Date()),Month (Date())-1,1)" And "[AircraftID]=3")

        This time is came back with "...
        See more | Go to post

          Leave a comment:

        • dunkleypilot
          started a topic Returning the first value For a Date Range on a Form (DLookup?)
          in Access

          Returning the first value For a Date Range on a Form (DLookup?)

          Hello,

          I have created a database to track the flights on three aircraft owned by the flight school I manage. The relevant fields in the FlightRecords table are Date, AircraftID, HourMeterOut, and HourMeterIn. [HourMeterIn] - [HourMeterOut] = TotalFlightTime .
          Each month I generate a report that calculates the total flight time for each aircraft. That report calls a Dialog box which has BeginDate and EndDate, BeginHourMeter...
          See more | Go to post
          • dunkleypilot
            replied to Too many decimal places in a report.
            in Access
            Well I figured it out, no need to respond.....
            Thanks,

            Steve
            See more | Go to post

              Leave a comment:

            • dunkleypilot
              started a topic Too many decimal places in a report.
              in Access

              Too many decimal places in a report.

              Hey,

              I am having a problem with one of the text boxes on my report. Every time I run the report it shows up with 5 decimal places instead of 1 like I want. I have tried limiting the length in the properties but it doesn't work. Thanks for any help.

              Thanks,
              Steve
              See more | Go to post
              • dunkleypilot
                started a topic How to use a value from a subreport in the main report?
                in Access

                How to use a value from a subreport in the main report?

                Hey Again,

                I am currently working with an unbound report that incorporates several subreports. I would like to use a values that are generated in the subreports in the main report. How do I retrieve the calculated values from the subreports?

                Thanks,

                Steve
                See more | Go to post
                • dunkleypilot
                  started a topic Double Reporting
                  in Access

                  Double Reporting

                  Hey,

                  I am having trouble with a report that I am trying to write in Access. I am putting the body of the report in the "Detail" section. However, when I run the report I keep getting two copies of everything in the "Detail" section. How do I get only one.

                  Thanks,
                  Steve
                  See more | Go to post
                  • dunkleypilot
                    replied to Dialog and prompt forms in Access
                    in Access
                    Hi,

                    Could you explain that a little more....

                    Thanks,

                    Steve :)
                    See more | Go to post

                      Leave a comment:

                    • dunkleypilot
                      replied to Dialog and prompt forms in Access
                      in Access
                      How would I generate a report that calls on several queries with date ranges. If I use parameter values then I would have to enter the date range about 5 times. I explored trying to do the whole report with one query but I don't think it will work. Thanks for the help.
                      See more | Go to post

                        Leave a comment:

                      • dunkleypilot
                        started a topic Dialog and prompt forms in Access
                        in Access

                        Dialog and prompt forms in Access

                        Greetings,

                        I am relatively new to access and am pretty much learning as I go. What I am trying to do is to use the acDialog feature to provide information to a query that generates a report. I have built a Dialog form to provide the information. I am just not sure how to code the report, and or query to use it and then generate my report.
                        Thanks for the help,
                        Steve
                        See more | Go to post
                        No activity results to display
                        Show More
                        Working...