Nicole1023
New Member
- Joined
- Sep 7, 2013
- Messages
- 35
Hi,
I have a vba query that i would like to create a column for date. May I ask any idea on how to do this in my query. thanks.
below is my query: i wanted to include the todaydate as field column.
I have a vba query that i would like to create a column for date. May I ask any idea on how to do this in my query. thanks.
below is my query: i wanted to include the todaydate as field column.
Code:
TodayDate = Format(Date, "dd-mmm")
sqlstr = "SELECT e.DAX_ITEMTYPE, e.DAX_WHSE, e.DAX_LOCATION "
sqlstr = sqlstr & "FROM [1.reference$] e "
sqlstr = sqlstr & "WHERE isnull(e.Location) "
sqlstr = sqlstr & "GROUP BY e.DAX_ITEMTYPE, e.DAX_WHSE, e.DAX_LOCATION"