Recent content by duesouth

But won't that still bring back a value where not null that Access won't recognise as a number? What I want it to return is CDbl(Maximum) OR a null value - as when I use the CDbl expression I get an error rather than a null value.

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

Tried a lookup expression: Spec A Current: DLookUp("Grade","Spec A Current Lookup","Mark = " & [Spec A Dbl]) And it worked! Thanks.

Still getting the overflow error.....

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

Perfect! Many thanks.

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

OK - got it!! Went into the SQL view and added a DISTINCT SELECT DISTINCT [SCYC Calculation].[Exam Number], [SCYC Calculation].SCYC, DLookUp("UMS","CAU Raw to UMS","Raw = " & [SCYC]) AS Exp FROM [CAU Raw to UMS], [SCYC Calculation]; Thanks for your help.

I'm nearly there with: DLookUp("UMS","CAU Raw to UMS","Raw = " & [SCYC]) The only problem is that it brings back each record more than one - the same data, but tons of times......

Cheers - it sounds like the right idea, but I can't get it to work! I have in the query QRY_SCYC_Calculation a calculated field called SCYC - which is the maximum of three coursework scores. I have a Table - TBL_Raw_to_UMS which containts the Raw Scores (which will the the SCYC) and then the...

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