Unbound Text need to be linked to Table now??

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?

On Sun, 24 Dec 2006 18:53:00 -0800, EZ KEY
wrote:

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]

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" wrote:

On Sun, 24 Dec 2006 18:53:00 -0800, EZ KEY
wrote:

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]

On Tue, 26 Dec 2006 07:22:00 -0800, EZ KEY
wrote:

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]

John:

I did get this to work. I did as you suggested and it worked out fine.

Thanks!

"John Vinson" wrote:

On Tue, 26 Dec 2006 07:22:00 -0800, EZ KEY
wrote:

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]