Have an application in ACCESS that I want to move to EXCEL, but I can't figure out how to do things in the EXCEL QBE grid. Need to create several alias fields from a date field, such as Year, Month Number, Day of week Number, etc. Trying to add new column using the following to create alias and the year: Year:Date.Year( but I can't enter the column name that contains the date. If I try to use the drop down menu to get the date field it just replaces everything I've entered. And I can't manually enter it. (Note that the date field is a date field, not text) I have combed the web and can't find any tutorial that really explains the EXCEL QBE Grid. Been using ACCESS for a number of years and there is information all over the place for that. I can connect to the proper database, do a join and get the columns I need, I just can't create the 7 or so date fields I need. The data will be loaded into a Pivot Table on open.
Thanks
jpl3
Thanks
jpl3