Unbound Text need to be linked to Table now??

[Guest]

I set up a form with a text box that calculated sales tax. Now my boss wants
to be able to query that information and sort it out from a table. How can I
link that information to be recorded in a field?

 

[John Vinson]

I set up a form with a text box that calculated sales tax. Now my boss wants
to be able to query that information and sort it out from a table. How can I
link that information to be recorded in a field?

Your boss needs to be able to search on a sales tax value.

Your boss does NOT need to have that value in a Table. Those are two
separate requirements!

You can do the calculation using a calculated field in a Query. That
Query can be searched, sorted, exported, used as the recordsource for
a form or report, just like a table.


John W. Vinson[MVP]

 

[Guest]

John:

Ok! I think I know what you mean. I do that much like the "Bavant Marine"
example where you use a separte column in the query and the zoom command, and
create a field that I can refer to for the orders if I wanted to, but don't
need to really, and treat them as two separate functions. Now that I
remember, I think I saw a subtotals query in the Northwind which would be the
same thing.

Is this correct?

 

[John Vinson]

John:

Ok! I think I know what you mean. I do that much like the "Bavant Marine"
example where you use a separte column in the query and the zoom command, and
create a field that I can refer to for the orders if I wanted to, but don't
need to really, and treat them as two separate functions. Now that I
remember, I think I saw a subtotals query in the Northwind which would be the
same thing.

Is this correct?

I haven't delved into the inner works of Northwind very much, and I'm
not familiar with these two examples - but if they work for you,
great.

John W. Vinson[MVP]