Recent content by Mrsostrich

Sorted! Thanks In one of those truly bizarre Access moments, the thing is now working. I'm not aware of doing anything differently, but I rebuilt the query and form and it seems fine now. I think I'll just settle for that and be grateful! Doncha just love it?

Thanks Pretty much, but as you can imagine in a school we have a set number of lessons in a day, and more or less the same number of weeks in a term, and I'm trying to keep data entry down as far as possible. Yours is very similar to mine. Thanks anyway :)

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

That's another good idea. The rents are actually billed monthly, but the append query would still work nicely, and would be tidier than just a date diff, it's more like what I had in mind originally. I could then have a similar query working for payment which appends when a payment is entered...

Ok, I'm probably being dense, but why not and how do I bully it into doing what I want it to?

Oh that's a good idea - I hadn't thought of recalculating from the start each time - that also makes it easier to allow for different rent dates for each tennant. Thanks a lot

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?

That's right, I don't need a translation facility - I teach Chinese pupils and want to display report comments in Chinese, as well as in English, using the English version of Access. Some of those leads look promising, so I'll investigate a bit further and report back. Any more suggestioins...

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.

Solved it I couldn't actually get that routine to work. Or at leaset, I couldn't work out how to get the result displayed, but it did give me an idea. I allocated a vartiable name of PointsNo to the sum function, and then used that in the switch...

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

Thanks The query was just what I wanted - thank you. I had to find the instruction file too though, but once I had it was straightforward.

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