Map

J

Jeff Clarke

I'm attempting to create map that will populate with data, however, I'm not sure how to create the crosstab query. I have 100 records, each record contains a state field ... I also have a separate table containing all the states. However, when I join the two together on state, I've created a query which on has two fields (the state) and the total. I need to somehow convert that to a query where each state is its own field ... that way on the map (report) I've create I can drop each field (state) onto the map.

Thanks in advance

Jeff
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Program a Search field 2
Copy previous record into form field 0
How to build a "reach around" query? 5
Help with update query and unbound combobox 4
Special characters 3
Clearing Fields in a Word Form 5
import problems 0

Top