Search results

  1. F

    Formula to identify a record based on first of the day but not

    I am in need of a formula or expression to run a comparison of a field in different records but from the same table. I want to select a record from my "WeighIn" table and then have its "weight" column compared to the "weight" column in the most recent record that is also the first record...
  2. F

    Retrieve the current value then make static

    I have a query that sorts data from a weigh in table and returns a single result per player based on some date and time criteria. The returned result is then used in a comparison the next time a player weighs in to determine a recovery score. Since the data from the query is based on...
  3. F

    Interactive Form to display calculations from background query

    I have a database that is used to track health/performance factors of high school football players. During the summer months we are concerned about proper hydration recovery from day to day and thus weigh in our players every day. What I would like to have is a function to notify me instantly...
  4. F

    Display an image in a report using a url located in the table

    I have created a database that is linked to a csv file that contains the metadata or EXIF tags from digital photos. Included in that data is the filepath to the images. I am creating a report that will need to display the image on the top half of the page and display the EXIF data on the...
  5. F

    Create Report from Query and Tables?

    I have a database of high-school football players, and I am looking to print out single page reports (or forms) that will show detail from several tables and queries. This will act as their resume when they visit schools on recruiting visits. The reason for needing query items, is that I have...
  6. F

    Do I continue to build it, or get professional help.

    I have been working on a database that will capture data pertaining to a high school football program. We want to capture general profile info (Contact, DOB, Jersey #, etc,) weight chart (weigh in weekly) maxes (max lifts in weight room quarterly) and Combine Skills (40 time, broad jump...
  7. F

    Excited new member.

    I am new to the forum and excited to be here. I have been using Access for almost 10 years, and I am certain that I have been using it wrong all along. I have been given the task of developing a database for a high school football team, and the challenges have become many. I have no formal...
Back
Top Bottom