Query Help

  • Thread starter Thread starter gmayeaux
  • Start date Start date
G

gmayeaux

I currently have to run three seperate queries to get my data because
duplicate rows are created otherwise. I know which tables to use and
the criteria but I would like to be able to run one query to get the
information. Is it possible to have the results put into columns
instead of rows to prevent the duplications? If so how would I go
about this? Or if there are any other thoughts on how to accomplish
this I am open to trying anything at this point.

Thanks!

Gerald
 
It should be possible to produce the one query to do all of that, although I
like using several queries so that debugging is easier. That doesn't mean you
have to run them separately, though, as you should be able to use queries on
top of queries. You will need to post your tables, fields and what you want
to get for us to be any more specific...
 
Back
Top