sorting imported data in Visio

[Guest]

I am working with Visio. I have created a Bill of Material generator that
will collect information from a page and will use information that is in the
Access Database to insert that info into a shape on the open page. I would
like to sort this info in a specific way. I now use tables for this but would
like to know if I can use a query and how would I do this?

As far as I understand the Query will sort the data so that things are in
the correct order then I can suck that info out into my drawing.

I am really unsure as to what the syntax would be and what variables I would
have to declare.

Thanks,

Derek

 

[John Nurick]

I haven't tried this with Visio for years, but as far as I can remember
you just create a query in Access and then tell Visio to use it in
exactly the same way you'd tell it to use a table.

 

[Guest]

John,

Thanks for the info. I did try this. I basically changed all references for
"table" to "query" and I have not been able to make it work yet. Anyone have
any other ideas? Do I have to delare a specific type of page or something?

TIA, Derek