Search results

Okay guys, I have found the source of the problem. Yes the IIF statement works fine I think I'll blame it on access :P What I had done is used the "Lookup wizard" datatype and typed the values I wanted. The values I wanted were "Yes" and "No". What Access did (without telling me grrr) was...

Hi bob, I'm getting a return of #Error when I use this IIF statement in the query. Are you using it in the same query or a new query?

pbaldy - it isn't currently yes/no I tried that but couldn't get it to work so I am now just using the lookup function to select YES or NO.

Okay, here's a couple of lines of data - (taken a few out, they're irrelevent) CustomerID|Discount|Cost|Rate|Charge|Sales J1|2|10|11|No|8 J1|4|20|15|No|16 So the Discount is calculated by Sales Rate/100*[Cost] -Where Sales Rate is found on another table Sales are calculated by doing...

Okay I guess you just mean the output. I was thinking about output SQL which probably doesn't exsist :rolleyes: CustomerID|Discount|Cost|Paid?|Rate|Charge|bill_no|Sales

How do I do that? (Sorry :P )

Yeah it runs just fine like that raskew.

I hadn't had a look at the SQL before (Beginner here :P ) but I think I can see some problems, doesn't look it's looking up the correct tables. Anyway - =========Begin SQL======== SELECT Customer.CustomerID, Customer.[First Name], Customer.Surname, Customer.[Address Line 1], Customer.[Address...

Hi sorry meant to put that even with the field set to "NO" it still displays "#ERROR" VAT isn't defined as number or text as I'm defining it in the Field box wihtin the query.

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

Thanks, I found it in the Grouping and Sorting in the right click menu.

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

Hi, Text1 is a text box on a form which contains a numerical value. I want to then update or change a field in a table to the value in Text1. For example - Text1 contains the total quantity of items purchased. So Text1 could equal "15". There is then a field on the customer table called...

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

Thanks ansentry. I'm not quite sure what was happening. I started over again and everything worked fine, I must have made a small mistake somewhere. I also have another question regarding the value I created I the total box. I have tried using a setvalue macro with the following expressions -...

Thank you Chris. The database really helped me understand things. When I am normalising data I always seem to overcomplicate things but I can see from your database that in terms of structure/relationships using three like that works fine. Thank you.

I think it's a single form. I used the Wizard to add one field from one table (main form) and other fields from other tables to create the subform.

Thanks for the reply Chris. I should have explained myself better as I realise after you said that, that one screening will only show one movie. It would be better to explain the type of database I want by using an example of a holiday booking database. I just knocked up a quick txt file...

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

It's the total on the main form. It just adds the extra column and displays the total on each row. ---------------- Field1------Total 1_________11 3_________11 5_________11 2_________11 Like that in the main form. I just want to hide it.