Query

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I have a query that has two fields. field A and field B.
Field A has many of Field B. This causes many
duplicates. I want to be able to have Field B go across
for the one value of field A. I know this can be done in
a report but my Boss wants to see this in query
form..Typical

-thanks, Alex
 
Hi Alex,

Try to use the crosstab query. The wizard should help you to get there. Do
not know if it will give you the result that you are looking for.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dcount returning no results!!! 0
Count text values in a Access Field 0
multiple one to many 2
Help with expression builder in a select Query 2
Need a query to get rid of duplicates using two tables 1
Eliminating Duplicates from a Query Access 2007 6
Split data in field on character return 0
Use field values as names names? 5

Back
Top