User Profile

Collapse

Profile Sidebar

Collapse
brittb
brittb
Last Activity: Jan 19 '12, 11:53 PM
Joined: Jan 6 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • brittb
    replied to Calculation based on count of records in a query
    in Access
    Okay wait, I think I figured it out. I forgot the quote marks (duh). Thanks!
    See more | Go to post

      Leave a comment:

    • brittb
      replied to Calculation based on count of records in a query
      in Access
      Okay, I tried that and now I'm getting "#Name?" in the report view. What's wrong now? I triple-checked the name of my query; that's not the problem.

      No, the query is not the report's record source. When I set the record source as this query, I get an "Enter Parameter Value" prompt, which I don't know how to get rid of.
      See more | Go to post

        Leave a comment:

      • brittb
        started a topic Calculation based on count of records in a query
        in Access

        Calculation based on count of records in a query

        Hi,

        I'm trying to create report that will have calculated values based on the number of returned records for a query. The query returns records based on the date, so the number of records returned will change day to day. The calculations in the report should reflect the fluctuating number of records in the query. Hopefully that makes sense.

        So in the report, I have a text box with the Control Source:

        =13.2+4.4*Count ([QueryName].[FieldName])...
        See more | Go to post
        • brittb
          started a topic Auto-population of fields
          in Access

          Auto-population of fields

          Hi there. I'm a complete novice trying to create my first database, so please feel free to treat me as such.

          I'm trying to track specimens coming through my lab, which will go through several steps of a long procedure. We want to track on what date each step happens for a specimen, and each specimen might go through each step multiple times (if say, a run fails), so I have separate tables for everything: Specimens, Extractions, PCR,...
          See more | Go to post
          Last edited by NeoPa; Jan 13 '12, 12:59 AM. Reason: Made pic viewable
          • brittb
            replied to Access text box expression error
            in Access
            Aha! All I had to do was delete the On Format event that somehow got placed in the properties for my report. It works now. Thanks!
            See more | Go to post

              Leave a comment:

            • brittb
              started a topic Access text box expression error
              in Access

              Access text box expression error

              Hi there. I created a very simple database recently with just one query and one report based on that query. Yesterday the query and report worked just fine, and I was easily able to export my reports as PDFs. Today I've tried to do the same thing, but now when I try to export the report to PDF, or even print preview, I'm getting this error:

              "The expression On Format you entered as the event property setting produced the following...
              See more | Go to post
              No activity results to display
              Show More
              Working...