Recent content by Fergge

Ridders, Thank you for the information. I had began this quest looking for a way to capture data in a form and then make it static, but it looks like the best option is to create a formula or expression to run the comparison on request.

We can stay on this thread for now as I think you have got me headed in a better direction. TheDate is a time and date field but I have been using the record ID to identify the first record of the day. I am running a Max on Date and a Min on Record ID. The problem is that the most recent...

Mark, I have posted this discussion in multiple places due to not knowing if it was a Forms question or a query, and it appears you are helping me in both sections. Please let me know which thread would be the best to continue in and I will be glad to do so.

Mark, You are headed in the right direction. My issue is that players weigh in multiple times per day, and each weigh in needs to be compared to the previous weigh in that was the first weigh in of the day. The first weigh in of each day must be compared to the previous first weigh in of the...

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

My apologies for the confusion. When I used the phrase current I was speaking of the number I am currently entering at the weigh in. I need to do a comparison using the weigh in currently being conducted vs a previous weigh in that is already stored in the "WeighIn" table. I guess if I could...

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

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

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

Thanks for the advice. I will Work on the query and then post a screen shot for further advice. I was able to make the links and will hopefully be able to build the report later today.

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

Thanks for the response, and I will keep it in mind as I move forward.

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

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