neutralizate culomn in a query

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

Hi all,
I'm trying to make a global query that will be changing dinamicly from
form to form but in order to do this,i need to making some of the
culomns to loose their effect

any ideas?
 
Hi all,
I'm trying to make a global query that will be changing dinamicly from
form to form but in order to do this,i need to making some of the
culomns to loose their effect

any ideas?
Click to expand...

Well... WHY?

It sounds like a faulty database design. What do you mean by "lose
their effect"?? Could you give an example of the data, and what effect
you want to see?

John W. Vinson[MVP]
 
lets say i have in a query fields:
field1....field10

now i'm using modular form so for modular form switch 1
it will be
field1,field2,field3,of course that the sum will be for the last
field(field3) if we are doing group by

now modular form switch 2 will be
field1,field2,field3,field4,now the sum will be on field4
i would like to make dynamicly some of the fields in the query to be
not in use so it will not effect the summing
John Vinson ëúá:
 
lets say i have in a query fields:
field1....field10

now i'm using modular form so for modular form switch 1
it will be
field1,field2,field3,of course that the sum will be for the last
field(field3) if we are doing group by

now modular form switch 2 will be
field1,field2,field3,field4,now the sum will be on field4
i would like to make dynamicly some of the fields in the query to be
not in use so it will not effect the summing
Click to expand...

I'm sorry, this doesn't make it any clearer to me. Maybe I need
another cup of coffee.

Rather than an abstract field1, field2, field3 could you describe the
ACTUAL table structure, and the actual business problem you are trying
to solve?

Are you trying to store sums across fields into another field - as if
you were using a spreadsheet? If so, you're on the wrong track!

John W. Vinson[MVP]
 
By "global query" I think he means he wants a generic query that he can use
on multiple tables without having to actually name fields, and that will work
even if the number of fields in the query and table don't match! It sounds
like another case of waiting for the next generation Access, Access version
ESP!
 
Back
Top