Hello
I am exporting dynamic queries from Access to a word document, by means of replacing the bookmark text
The query I want to export would display in the following format when opened normally in Access
[FieldCategory], [count]
category1 3
category2 2
category3 1
I am building another SQL query in VBA, using the data from the query and linking with the original table, in order to get the data as following:
[FieldCategory], [memo]
category1 "text"
category1 "text2"
category1 "text3"
category2 "Text0"
category2 "Text05"
category3 "Text stuff"
I want to output into word as the following:
[FieldCategory]
category1
"text"
"text2"
"text3"
category2
"text0"
"text05"
category3
"text stuff"
1) Without setting multiple bookmarks, would this be possible?
2) How can I extract the unique "categories" value from a query for each unique value?
I am exporting dynamic queries from Access to a word document, by means of replacing the bookmark text
Code:
.Bookmarks("FieldCategory" & i).Range.Text
.Bookmarks("memo" & i).Range.Text = VerbatimQryTable
The query I want to export would display in the following format when opened normally in Access
[FieldCategory], [count]
category1 3
category2 2
category3 1
I am building another SQL query in VBA, using the data from the query and linking with the original table, in order to get the data as following:
[FieldCategory], [memo]
category1 "text"
category1 "text2"
category1 "text3"
category2 "Text0"
category2 "Text05"
category3 "Text stuff"
I want to output into word as the following:
[FieldCategory]
category1
"text"
"text2"
"text3"
category2
"text0"
"text05"
category3
"text stuff"
1) Without setting multiple bookmarks, would this be possible?
2) How can I extract the unique "categories" value from a query for each unique value?