Recent content by joe_madeira

Hey, I was wondering if it is possible to make a macro that asks the user whether they want to print or print preview a report. can this be done?

Appreciate all the help but i've got it working already. thanks though.

The menu price is always £10 for the menu item that is categorized in the "first floor" category because that category consists of shisha pipe flavours which are all priced at £10. there are other menu items but they are not categorized in "first floor".

I get what your saying, thanks man!

thanks for your help but i've got it to work using this: IIf([Menu Category]="First Floor" And [Quantity]>1,[Menu Price]*0.5*[Quantity]+5,[Menu Price]*[Quantity]) I just had the greater than sign ">" the wrong way around lol. my bad but thanks G

Ohh I got it! =IIf([Quantity]<1,[Menu Price]*0.5*[Quantity]+5,[Menu Price]*[Quantity]) +5 to gain the £5 lost in the original £10 of the first item thanks for all your help!

nop that isn't the correct expression cause the final values are wrong basically: If i buy one item the total cost is £10 however if i buy 2 of that item the total cost is £15 (the same item is discounted 50%) if i buy three of that item the total cost is £20 If i buy four then the total cost...

It was in the control source of the text box in design view in a subquery. got it working tho. however read my post just above this one

Thanks that worked! thanks! But hey i think i got the whole thing wrong though. Basically the rule is: a customer buys a flavor full price. If they buy that flavor again then the second time round the price is half. how would that be put into an expression? Any ideas?

Appreciate your help but it still says error it says "you may have entered an operand without an operator" ?

Hey. In a subform I have a Final Price text box which I added while in design view. First I had the expression: [Quantity]*[Menu Price]. But then i remembered that every time a customer orders an item more than once the price of the item gets cut down to half the price. Obviously i need an IIF...

I quickly made a cut down version of my database with just the tables and the totals query. If it's not too much to ask can anyone check it out and then add the discount function to the database in the best way possible. Thanks a bunch!

Yeah sorry, I edited my 3rd post cause I remembered once i had posted

gemma-the-husky, Where would i do that? In a form, in a query bearing in mind that i already have a query that counts all the number of orders a customer has made? man you guys make it sound so eassssy! i'm so frustrated that i can seem to work this one out.

Well basically I've got these tables: Customer Order Order Item Menu I've got test data in them all. So basically a customer makes an order for an order item and that order item is from the menu. (Restaurant System) The reason for the Order item table is because on order can consist of many...