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

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

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

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?

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

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

Hi, I have two fields in my form, one called Offending Likelihood, in which I have a list from which the inputter can choose numbers 1 to 5 and a field called Offending Likelihood from which the inputter can choose the letters A to E. I have an another box called Offending Score in which I would...

Hi, I have a form in which I am trying to build a matrix scoring system and need some help please. I have two fields one called Offending Consequences and one called Offending Likelihood. The first field is limited to a list 1 to 5 and the second to a list A to E. What I want to do in a...

Hi All, I have a number field and I want the numbers all to be either whole numbers or to end in .25, .5 or .75. How do I write a validation rule that ensures that only these numbers are entered? thanks Hazell

Hi, I have written a query to find the number of students we have on our books who are between 15 and 18. The query lists the students and gives the total number in data sheet view. Now I have written another query which looks at the number of students between 15 and 18 who have completed a...

Hi, I am trying to get a form to display certain information based on the data in another box. I have to input some exam results and want to assign a level to them. So, if they score < 13, the result would read "Below Entry 3" if between 13 and 21 "Entry 3" etc If this was a spreadsheet I would...

Hi all, Hope you can help. I am trying to create a form where I store the literacy and numeracy results of a group of students. So far I have designed a form which gives me a tick box as to whether the test they took was literacy or numeracy, then a box where I enter the score. Literacy tests...

Hi, I have built a query that lists all the members in a group aged 15 to 18. Now I need to build another query that counts a subsection of that group (the number who gained employment in the quarter) and express this as a percentage of the whole of the 15 - 18 group. I presume I can use the...

Hi, I have written a large number of queries to gather data for a quarterly monitoring form. How do I replace the dates to update them for next quarter. For example I have written a query which counts the number of new members who started in the period 01/04/2013 to 31/07/2013. How can I change...

Hi all. I am writing some queries with a fairly complicated naming system and have hit a snag. The naming goes like this: QM H 1 32 etc etc QM H 2 32 etc etc down to QM H 10 32 etc etc And the query jumps up the list of queries. How can I get access to recognise it as 10 and not 1.0. I...