New Database

[bayswatergirl]

Hi there,
I am new to database and have been creating a simple database for tracking sales. I have been able to get what I want so far . I am now trying to figure out how I would get some information by creating I'm thinking a query. Here's a little back up to what I'm doing.

I'm tracking sales for a co-op group and have to produce reports monthly on how much each person sold. I think I have my database the way I want it but now I would like to include in my report when the sale was paid for by Visa/Mastercard that I can tell it to deduct the service charge ie 3% of the sale. And then the total amount of the report will tell me what I owe them for the month.. Total sales minus the service charge of all the visa/mastercard sales. Is this possible?

[alansidman]

First you will need to add a field to your table and form that indicates that the merchandise was paid for with a credit card. Perhaps a Yes/No field.

In your query, you will then need to add an expression field that reads something like the following:

Seller Proceeds:  IIF([CreditCardField]="Yes", [SellPriceField]*.97,[SellPriceField]

Make sure to change the field names to match your field names.

Alan

[bayswatergirl]

Thank you for your reply. I am here trying to get it to work and it keeps telling me something about parathesis. I am not sure what I am doing wrong and have never worked with expressions before. I am in the query and went to the builder and tried doing it from there. I doesn't work for me. would it be possible to get a little more detail as to where I am supposed to this at?
thank you again.

[bayswatergirl]

Here is my formula
Sales Proceeds: IIf( [Credit card yes/no]="yes", [s_Amount] *.97, [s_Amount] )

And here is the error I keep getting
The expression you entered has an invalid . (dot) or ! operator or invalid parentheses.You may have entered an invalid identifier or typed parentheses following the Null constant

Why does this keep doing this to me?

[bayswatergirl]

I got it figured out!!!