Recent content by Willis

I agree with you, it seems irrelevant - the next part of the question requires it and I can do that fine, it is just this that has tricked me up. I managed to have my query result in $26k - basically made a new query and only have the Unit table on the design view (as relations made the...

I think it is more simple than that - from my understanding, the question is asking me to obtain the total cost of taking all the units. Which should be the sum of all the credit points multiplied by the unit cost - which if I do manually is $26k. However, my query gives me $33k

Sorry, I thought I should post all the tables in the question. For some reason, if I run my query I get $33k. When if I do it manually (by hand) I get $26k

Hi guys, Basically I am trying to make a query (using the expression builder) which can show this if hypothetically a student enrolled in all units, how much would the total (SUM) tuition fee be? Basically I have four tables and have been using this Total: ([UNITS]![Credit...