variable column in query

  • Thread starter Thread starter leon
  • Start date Start date
L

leon

I need to build a qury in which one of the columns is a variable which
either can be filled in by hand when running the query or the query
should pick up the name of the variable column from a form. Yhe qury
should look like this:

Select account, balance, [varaiable]
from tbl_accountbalance.

Is this possible at all?? I don't mind if it has to be written in VBA
 
There is no way to specify a field in the field list with a parameter. You
will have to create the query programmatically. On my website (see sig
below) is a small sample database called "CreateQueries2.mdb" which
illustrates how.
 
I need to build a qury in which one of the columns is a variable which
either can be filled in by hand when running the query or the query
should pick up the name of the variable column from a form. Yhe qury
should look like this:

Select account, balance, [varaiable]
from tbl_accountbalance.

Is this possible at all?? I don't mind if it has to be written in VBA
Click to expand...

Answered, twice, in your previous thread with the same subject.
 
Back
Top