Build Query

[Kyoshikawa]

I need help with creating a query.

[June7]

Exactly what do you not understand about creating a query?

Use the Access query builder.

This is basic Access functionality.

[Kyoshikawa]

I need to create a query that caculates the Gratuity on a room service order (18%) or spa treatment (25%) Gratuity is a caculates field and if there is not a spa treatment or room service a zero should be displayed in the Gratuity field.

I don't know your db structure or field names, so example of an expression is:

[Charge] * IIf([order type] = "room service", 0.18, IIf([order type] = "spa", 0.25, 0))

http://www.techrepublic.com/article/...s-and-reports/

[Kyoshikawa]

Do I need to go to the zoom option?

[June7]

What is zoom option?

Have you completed any tutorials? Start with http://www.rogersaccesslibrary.com/

[Kyoshikawa]

Thank you so much

[Kyoshikawa]

Can you use that same expression for a discount query

[June7]

Probably. Change the percent constants as needed.