Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Access 2003

Comment:

Hi I need an IIf statement to turn pupils marks into grades. for example all students scoring 0-10=F, 10-30=E, 30-50=D, 50-60=C, 60-80=B, 80-100=A I have never built an access database before and am finding it all very confusing, would really appreicate any help, anyone could give me. Thanks Cheri

Reply:

Cheri, I don't think your ranges are what you really want --- they overlap. 0-10=F, 10-30=E, 30-50=D, 50-60=C, 60-80=B, 80-100=A , I think you want: 0-10=F, 11-30=E, 31-50=D, 51-60=C, 61-80=B, 81-100=A or similar. Here's a link that may help: http://www.599cd.com/tips/access/ii...

0

adodb connection

Shell Script

Summary: I have created an MS Access db, 2 of the fields relate to time...StartTime & EndTime. From this I have created a query to display the attendance time ([EndTime]-[StartTime])*24 which gives me the dif...

Summary: Im trying to implement a function in Access 2003 to allow the application to find a given field from a give another field in the same record. e.g. I have a table of Assets called tblAssets, im trying ...

Summary: Our agency maintains a Paradox 9 security database. Within this database is table (with 1311 records) which contains demographic data for all employees. One of the fields on this table is BLOB field...