Search results

I've got 3 number fields in a table and in a query I've written a maximum expression to bring back the maximum of these three values. I want the query to record a null or a number value (as I've discovered 0's cause problems) - so if I do a CDbl expression i.e. CDbl(Maximum) - then nulls in...

I've created a calculated field which is the average score in various exams (called "Average"). I've then created another field: Average 0 Dec Places: CLng([Average]) to set that to a long integer with 0 decimal places. I then create a relationship between the [Average 0 Dec Places] and a...

I have 3 calculated fields in a query and another number from a table which I wish to add together. When I build [query1]+[query2]+[query3]+[table1] Access brings back all the number together in a string (i.e. 10+10+10+10 = 10101010). Presumably I need to add something to the expression to...

I work in a school and am trying to create a database for modular exams. The pupils take more than one practical - but only use the highest grade to go forward to their actual result. I've successfully created a query which works out the maximum of these practicals. However, from this...