Recent content by mickeyboy

Didn't work!! I'm just looking for an expression to enter into an unbound text box. I am a real newbie at this

The record source is a form called Report

The reports source is a form called register

I have been stuck trying to write an expression that will calculate the Yes values in a range of 16 Yes/No fields. I have attached a screen print of the report I am working on. Hoping for some help!!!

I am trying to work out the expression that will first count the number of 'Yes' returns in a series of yes/no boxes and then display as a percentage. To explain...The yes/no boxes represent attendance over a 20 lesson course. I have added a count for each lesson for student...

Thanks Spikepl... I have managed to attach the screen print that show the relationship tables of both db's. The field properties are exactly the same.

Thank you for the reply...I had thought about just copying the db but I wanted to recreate to make sure I knew what I was doing. What had me stumped was that I wanted to create a single entry form that added common data into the three tables without having to enter it three times. In the...

As this is my first post please forgive if I have posted it incorrectly! I am relatively new to DB creation so forgive any ignorance. I recently created a database to help me manage my (Entry level) IT classes and manage all the documentation I have to produce. With a couple of small hiccups...