Complicated formula! Is it even possible?

[Johnhook]

Anyone who could help with this, I would appreciate it a lot.
For this school project of mine, I have to create a function that will calculate the total of a transaction. The trouble is that this isn't just a matter of adding numbers up.
There are certain items that cost £3, but once one is ordered, you get another 4 of the same score for £3. Then there are other items of varying price that don't have a complicated system behind them.
I've started by giving all items that fall into the first category the price of £0, hoping that I could construct a formula to figure it all out. However, I completely lack expertise with access, and my teachers do too!
Please help!

 

[dynamictiger]

So some items are $4.00, $5.00 etc and some items are $3.00 but if I buy a $3.00 item I get four more for free?

You need a second table to do this.

The first table would look something like:

ItemID ItemDescription Price

The second table would look something like:

ItemID(From Table1) Quantity Price


In practical terms this might look like:

Table 1

1 Banana $3.00
2 Apple $4.00
3 Orange $5.00


Table 2

1 4 $0.00

Then you would create a query that joins the two tables, always displaying all records from table 1 and only those items from table 2 that match.

A second query would then add the two quantities together to derive the total quantity for the total price.

HTH