Search results

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

Man it sounds so simple but for some reason I can't get it to work. It just says "No" even though one customer has made a total of 9 orders. surely on his 5 th order it should have displayed "Yes" in the discount field. i don't know whether to put a discount field in the Order Item table or to...

Hey, Whats the expression used when you want to Count all the records (e.g. Count all the number of orders a customer has made) and for every 5th record ( so when the count =5,10,15,20...etc...) the field displays Yes. In my case I have a Discount field of data type "Yes/No" and I want this...

boblarson, Wow man thanks! The command button works fine its just when I enter a date into the criteria form text box it doesn't correspond to the date that comes up in the actual form i'm trying to open. For example, i type in " 29/11/2011" and when the button is pressed the Order form opens...

Hey man, I've come stuck! My discount field and Order Sum field just say "#NAME?". I'm struggling to understand this DCount function. I'll research it a bit more in the meantime but if your free could you try taking a look at a version of my database that just consists of the tables and the...

I've only been using Microsoft Access for 2 weeks now and well I know no other way. My teacher in school taught us this. How would I do this without using a parameter? What do I use? A query? A form? A combo box? If you have the time can you explain to me how I would do this? Thanks for the...