Database Help Please

[orange]

What exactly is the problem? Your last post is too vague.

[Bellablu]

Ssnafu

Could you please give me a step by step guide on how to create this. Its just not working for me I have tried to replicate it & I must be missing something.

ie: create form
add text box & title GST
Go to properties & in source code put "blag blah"

[ssanfu]

Ssnafu

Could you please give me a step by step guide on how to create this. Its just not working for me I have tried to replicate it & I must be missing something.

ie: create form
add text box & title GST
Go to properties & in source code put "blag blah"

My example was to show how to do the calculation. The amount (percentage) of the GST is hard coded into the calculation. What happens when the GST changes? So you have to decide if you want to store the GST amount (percentage) in the record or look or up from a table.

First, create the query. I don't know the name of your table or fields so.......
Add the table to a new query. add the fields to the design grid.
"Journal Description", "Cost", "GST Yes" (note: this is a bad name for a field; shouldn't use spaces)

In a new column, enter:

GST: IIf([GST Yes],[cost]*0.1,0)

The blue is the GST percentage

In the next column, enter:

Total: [cost]+[gst]

Execute the query. Are there values in the grid?

If there are values in the query, create a new form, set the record source to the query. Set the default view property to "Continuous Forms".
Add the fields to the detail section of the form. Change from Design view to Form View - you should see the "GST" and "Total" amounts.

Again, I would think about what to do with the GST - look it up from a table or store the GST percentage in each record.

Does this help??