Creating Crosstab Query

B

Bob Ewers

I've got a form that sets query parameters and creates the following SQL statement

SQLstmt = strSelect & " [SELECT " & strUnionSelect1 &
" WHERE rpm_date >= " & Format(startdate, "\#mm/dd/yyyy\#") &
" AND rpm_date <= " & Format(EndDate, "\#mm/dd/yyyy\#") &
" UNION SELECT " & strUnionSelect2 &
" WHERE trade_date >= " & Format(startdate, "\#mm/dd/yyyy\#") &
" AND trade_date <= " & Format(EndDate, "\#mm/dd/yyyy\#") &
"]. AS [%$##@_Alias]" &
" WHERE " & strWhere &
" ORDER BY " & strOrde

How can I make a crosstab query from this?
Thanks in advance.
 

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

Output Problems 0
String Variables in SQL statements 2
VBA Select query with date range format issue 3
SQL statement with dates/times 2
Formatting date gives bad results in query 2
Display billing month based on start date and end date 5
Slow processing 3
Calculation Problem 1

Top