Search results

How do I show the names of children who appear in both my red list and my purple list. These lists are the results of 2 separate queries pulling from multiple fields within 1 table. Context - Our children start nursery at different ages. some at 24months, some at 36months etc. My table has 1...

On a continuous form, when viewed in form view it only shows 8 records, then has a large white space for half the bottom of the screen. I have got a header, but the footer is set to 0cm I am able to scroll to see the rest of the records but would like more records to show at once, there is...

I am needing to conditionally format 16 textboxes but the perimeters may change. We are looking at a RAG rating (Red, Amber, Green) currently red is <15 amber is >14 and <23 green is >22. However in the future we may want to move the boundaries, ie have red as <10. Is there a way of having...

Hello I have this queries that shows the total at the bottom I need to View the total at the bottom in a form (literally just need that number!) Can anyone help? Thanks

Hello I have a database that stores subjects, grades and information about the children. (all in one table) I need to create a chart as below where it displays a percentage of children in a certain cohort (column) who achieved higher than a grade 2 All children Girls Boys Special needs...

Hello! Please help! I have set up a database to store and analyse children's grades. I have 1 table for each subject, and a table with the children's information on. I need to set up a form that has a drop down box to select the child, and it bring up all the grades in all the subjects for...