Search results

Hi guys, I'm trying to use the following iif statement in a query and it doesn't seem to be working. VAT: IIf([Charge]="NO","0",([Rate]/100*[Sales])) "Charge" is a field in one of my tables (also used in the query) "Rate" is also a field in on the of the tables. "Sales" however is a...

Hello all, wasn't quite sure whether this was specifically a query related problem or something to do with the report so thought it fit better in the 'general' category. Basically I have a customer table and an orders table that I am trying to generate invoices for. I am using a query with the...

Hello, I am having a little trouble using an update query. I think it's an update query that I should be using but I may be wrong. (If anybody could guide me in the right direction if this is the case I would appreciate that) I have a text box on a form which contains a numerical value. The...

Hi guys, I'm fairly new to databases and am just creating sample ones at the moment and following tutorials from books. I tried to create my own cinema/movie database yesterday and there's something wrong. I really wanted to work this one out for myself but after trying many different...

Hi guys, Just a quick question and I'm sure it's something basic. I am trying to use the Sum function on a subform. I have done a search and found the answer to my first question, however I'm still having trouble. I have made a text box in the Form Footer of the sub-form. It contains...

Hi guys, I am having a few issues using the iif statments in Access. Basically, I have a store database with one of fields being "Offer". This is a Yes/No data type. I use the label wizard to make labels that will go on my products. The problem I am having is this - If the "Offer" value =...