S
SharonInGeorgia
My Imported table includes the following columns. Each of the month's
column's contain financial data. The column header is a string and not in
date format.
Store# AcctType Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Nov Dec
I need the user to be able to select one of any of the months. So, If the
user selects February, the query will show only three columns. Store#
AcctType Feb
Currently, I am manually deleted all of the months from my query with the
exception of the month needed. Then I run my crosstab query and all is
wonderful.
How do I automate this process for my users? (Code sample would be
appreciated!)
#1. To prompt the user to select a specific month.
#2. To have the query's outcome contain the month selected.
column's contain financial data. The column header is a string and not in
date format.
Store# AcctType Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Nov Dec
I need the user to be able to select one of any of the months. So, If the
user selects February, the query will show only three columns. Store#
AcctType Feb
Currently, I am manually deleted all of the months from my query with the
exception of the month needed. Then I run my crosstab query and all is
wonderful.
How do I automate this process for my users? (Code sample would be
appreciated!)
#1. To prompt the user to select a specific month.
#2. To have the query's outcome contain the month selected.