Search results

Hi All, I am trying to set up a simple form for our receptionist to record where she signposts callers to, and wanted her to be able to just click a button on a form that says Dept A or Dept B etc. I don't need to record any details except the date, which is updated automatically and a counter...

Morning, I set up a database some time ago with two tables, one called Young People and one called Youth Provisions. The Young People table now holds the records of about 700 young people who are registered with us, and the Youth Provisions table holds records of all the youth clubs that we run...

When the query is returned with the list of attendees, what is actually being returned is the Young Person table with their name ticked in the list, if you know what I mean. So when I try to use that in a second query, it either returns nothing, or it returns the information for the whole of the...

Should have added that I set up a relationship between Young People.Name and the Youth Provision.Attendees. I thought that this would allow me to cross reference them, but the resulting query shows the names from the original query but none of the information held on the young persons table...

Morning All, I have a database in which I have a table which I have called Young People and another which I have called Youth Provisions. I very foolishly set up my Youth Provisions table so that I could select the Young People who attended on a particular date from the list in Young People...

Hi all, I have created a very simple query to show the number of times a group runs in a qtr and also the total number of hours. In my query I can see both the count of times the group has run and the sum of the hours, but in the report that I have created from it, I can only see the count. I...

I think I made an error when I set this db up, because I thought I was being clever in using multi-values to select the people who attended the provision. now it is making creating the queries really really difficult. I can get a list of people who attended each provision, but it is one long...

Good Morning, I have a database which records the number of people who attend a number of different sessions in a week, and I have a query which counts the number of people who attend the sessions in a quarter. This gives me the total number of attendees, but I also need to count the number of...

HI, With the help of people on this fabulous forum I have created a number of tables. I have one called people and a number of tables for different events. I have populated the events tables by using a lookup of the people table and now I want to total the number of people at each event...

When I run the query the information is there, but it is displayed in a single cell, separated by commas, whereas I need it to display on each person who attended on a separate row. Thanks for the reply

Thank you. that worked a treat. Follow up question: When I created a query to show the attendees at an event between 2 dates, the attendees are listed in a string. How can I get each entry to show on a separate row?

Good morning, I am trying to create a lookup wizard to record the number of people who attend a regular event. I have a table recording the names, surnames and DOB of registered members and a number of other tables for regular events we hold. Previously people have been manually adding the...

I have deleted a field from a table but when I tried to delete the same field from the form I keep getting an error message - contains changes that are incompatible with the current database format. What have I done wrong please?

Thank you. works perfectly and simple too! Who could want more?

Thank you. Would I need to use some sort of conditional statement? And How would that be phrased?

Hi, I have a form with a drop down box with five options. Is it possible to have each of the different options a different colour and where would I do that please? cheers

Its a matrix. We might have a client who is likely to be aggressive but not particularly violent, so we will give them a likelihood of E but a consequence rating of 1. this would make them a medium risk.On paper this works as a grid, with 1 to 5 across and a to e down to give a risk assessment...

It is for a risk assessment. Field a is the risk of offending, field b is the likelihood of offending and field c is the risk - 5 categories - very low, low, medium, high and very high . So it will be 1 + A very low 1 + b very low 1+c low up to 5 + e very high

I have three fields in my table. One holds numbers 1 to 5 the other holds letters A to E. the third field is empty and I want it to return a calculation based on the other to fields. So, if: Field 1: 1 Field 2: A How do I get the query to return the answer 'Very Low' in field C? Bear in mind...

Error: Error evaluating check constraint in the validation rule What does this mean please? I have used a combo box in the table to input into 2 fields - one restricted to numbers 1 to 5 and the other restricted to letters A to E Message comes up when I try to change the view or press submit...