I have created a database application that compares bids on items from multiple companys vs. the current
info for each item. As this tool is used for each analysis, it starts out completely empty. One of the
main reporting features is a monster crosstab query that shows every current item in the analysis vs. every
received bid. Looks like:
[CURRENT INFO] [BID 1 INFO] [BID 2 INFO] [BID 3 INFO] [etc]
Each bid is made up of 13 seperate crosstab queries. Due to this application always starting out
blank & the company info that is loaded is always changing with each run, when it comes time to run this
query, the only way I can get my results is to manually add each of the crosstab queries in the order that
I want.
I'm not sure if this is even possible but I'm looking for a way to make Access automatically add
these crosstabs (1-13 for company 1, then add 1-13 for company 2, etc) in an effort to try & remove this
manual step.
I've attached a Word document with the SQL of the query. Anyone have any ideas?
Thanks..
info for each item. As this tool is used for each analysis, it starts out completely empty. One of the
main reporting features is a monster crosstab query that shows every current item in the analysis vs. every
received bid. Looks like:
[CURRENT INFO] [BID 1 INFO] [BID 2 INFO] [BID 3 INFO] [etc]
Each bid is made up of 13 seperate crosstab queries. Due to this application always starting out
blank & the company info that is loaded is always changing with each run, when it comes time to run this
query, the only way I can get my results is to manually add each of the crosstab queries in the order that
I want.
I'm not sure if this is even possible but I'm looking for a way to make Access automatically add
these crosstabs (1-13 for company 1, then add 1-13 for company 2, etc) in an effort to try & remove this
manual step.
I've attached a Word document with the SQL of the query. Anyone have any ideas?
Thanks..
