Search results

I'm looking at a database where I allocate students' music lessons. Pupils do not have the same lesson each week. I have a pupil table, a tutor table and a tuition table that links the two. That bit was easy, and allows for pupils to have lessons on more than one instrument. The next thing I...

Not sure if this is a query or VBA topic What I want to do is use Access for an automated rent book. I need to add an amount of rent on to a bill each month, so that I can then subrtract payments and keep a running total. Any ideas please?

I want to set up a database that displays a statement in English in one field and its equivalent in Chinese (full characters) in another. Is it possible to do it? I've done it in the past by having the Chinese as a graphic, but there must be a simpler way.

I have a report in which I total points for each pupil by using =sum([Points]) I now want to use that total to predict a grade using the following rules: below 10 = U 10-18 = E 19 - 27 = D 28 - 26 = C 37 - 46 = A Can I do it on the report? I've tried using switch, but seem to be having...

I used to use the groups total report on access 97, now I use 2000. I have sports results grouped by teams, and all I want to do is add the total points for each team. Am I just being thick?

I am storing module test marks in a table. Each modeule can be repeated once, and therefore my fields are: Student Id Module ID Session In order to calculate a final grade I need my query to select the higher of the 2 grades for any individual module and then add up those maximum marks for...

I'm putting together a database for use at a Sports day. In a field event, for instance, I can record the distances, then use a query to sort them in descending order, ie in terms of position. I now want to allocate a rank, ie 1 to the person with the longest throw, 2 to the next, etc, and then...

Is there an easy way I can set a table field to automatically put names with an initial upper case letter followed by a lower case? Am I right in thinking I can't use a calculated field as a primary key?

I want to set up a system for booking out equipment. How can I get access to give the user a message if the equipment is booked out already for the date they want to book it, particularly bearing in mind bookings are for longer than one day, and there may be many advance bookings for one piece...

I have a table with student marks in, and I want to allocate a grade which corresponds to the score, eg over 6 is an A, over 5 is a B etc. Vlookup or nested if do it beautifully on Excel. Any idea how I can do it on Access other than using a VBA If else statement which seems a bit complex? Iif...