NeoPa, you're a life saver :) which is not to say that I'm not grateful to all of you who've contributed.
But when under pressure to produce, a lay-man like myself tends to get a little nervous, so after trying Pat's Where clause with no success - probably 'cause I forgot a bracket somewhere, plugging the gaps by changing the perc-high field property to 3 fixed decimal points picked up the 2 remaining records.
So now I know that as...
thecheyenne
Last Activity: Jun 28 '10, 02:04 PM
Joined: Jan 2 '09
Location:
-
Thanks so much Pat
the thought had occured to me too but i dismissed it as soon as i realised that the query had picked up the value 49. this being the case, i just couldn't see why it didn't pick up the values 69 and 79. in the end, running out of time - it is world-cup-year after all - i changed the values in tbl_%_2_grades but your idea is lots neater, mine just happens to work this time round because no student happens to have the round...Leave a comment:
-
Comparison-query does not return all records
Dear all!
I have a database that stores student results - no, it's not a chart-graph question :):):) via the back door.
Within this database, sits a query called "qry-yr10-end-of-year-results". This query contains the fields "student_ID ", "Name" and "SumofWeighting _applied".
This "sumofWeighting _applied" is nothing other than a calculated numerical value, I won't... -
O.k, here it goes, I hope this format is acceptable, I wouldn't know how else to describe it. I do appologise for any database design flaws and am grateful for any improvement tips.
The following tables are linked (1-to-many) via their individual -ID fields; these fields are also primary key fields
tbl.assignments (holds all info relating to assignments, in other words, the tests that my graph should display
AssignmentID...Leave a comment:
-
Sorry, I can see how that might be helpful, so here it is:
SELECT Results!Score*1 00/Assignments![out of] AS Percentage, Results.Student ID, Assignments.[Skill-Area], [Assignment-Distribution].SubjectYearID, Results.Assignm entDistribution Date
FROM Assignments INNER JOIN ([Assignment-Distribution] INNER JOIN Results ON [Assignment-Distribution].AssignmentID = Results.Assignm entID) ON Assignments.Ass ignmentID = [Assignment-Distribution].AssignmentID...Leave a comment:
-
graph / chart from query without summarising data
Dear All!
I have a query that holds test results for my students; each test is either a listening-test, reading-test, speaking-test or writing-test. All results are in % and already calculated by the query using the expression
Percentage: Results!Score*1 00/Assignments![out of]
I'd like to convert these results into a simple [:):):)] bar chart and I'd like to add this chart to each student's report card, which is essentially... -
most people probably know this anyway;
If Medical = 0 Then
is wrong
it should be
if medical.text = "" thenLeave a comment:
-
o.k. that one is solved; - only took me one day !! If I had to earn my daily bread with this type of thing, I'd starve to death.
thanks be to this site, which helped me discover that the 'event' tab, into which code can be written, is accessible only for sections of a report, rather than for individual controls within a section.
Apart from that, for some reason, I was under the impression that the code ought to include...Leave a comment:
-
Hello ChipR (chipR rings a friendly bell, I'm sure I got some tips from you before - thanks again for taking the time to help)
I ought, perhaps, have given a more detailed discription of the database. In a nutshell it is thus:
every student must be processed one way or another, so there is a tbl.students
not all students will take part but those who do, are appended to tbl.participant s.
tbl.participa...Leave a comment:
-
label.visible=false on report??
Hi there everybody;
Fresh from reading my Access VBA for Dummies, I'd like to update my database about activities on a school outing.
Here's what I'd like to achieve.
The school outing costs money - nothing's for free these days.
The prices for the individual activities are stored in tbl.prices; in this table,
there are 3 fields: PriceID, Amount, Description
and 4 records: a record for the morning... -
Hi ChipR and thanks for the interest and tips.
In the end I came up with something similar, although I'm not sure yet whether this is the best it can be.
As for the activity-sessions, I've split it right down into tbl.sessions (am/pm/all-day)
and then a junction-table tbl.activity-sessions (activitysessio n.Id; activity.Id; session.Id). The idea is to then combine the activitysession .id with a student.id.
...Leave a comment:
-
Not urgent - just learning - database design tips
Hi and good evening / good morning (depending on your location on this planet)
Despite my limited - o.k, non-existing - knowledge of vba, I'd like to design a database to help with the admin of school outings. I pretty much know my way around MS access, but may well need vba for this thing here, so if you have any hints and tips for me, I'd be most grateful.
The outline of the day-out is as follows:
There is... -
Fantastic!!! it works!!! Fantastic!!!
Thank you for the tip about reserved access words. my next step will be to find a list of all of them, so I don't use them to name tbl.fields. It took almost 20 minutes to change them all - the 'date' field is used in a number of other forms and reports as well - and re-set the links between the main-forms and subforms.
Thanks again:):):):):) :)Leave a comment:
-
Hi there 'linq' and thanks for the reply.
tried it out straight away but I must be doing something wrong.
I was actually looking for the bit of code that opens the form in the first place but couldn't find it. I'm sure it must be there somewhere, else the form wouldn't open, or would it?
the from's name is 'Lessonplans' and this is the code attached to it so far:
=============== =============== =============== ==========...Leave a comment:
-
open form after checking system date
Hi there and happy new year to all of you.
I've been reading the thread "Auto Date in form "pages" from 'frys' in the topics and his/her problem is similar though not identical to mine.
Here is my database structure which works, crudely, but I'd like to re-fine it, if possible, so feel free to give your 2-pence on my design effort
My 'journal' is actually a time-table for an educational establishment. It...
No activity results to display
Leave a comment: