I have a table of which the data is im****ted from Excel. I receive the
Excel
file from my colleague only if she has activity on that day, in other
words,
the activity data will append to the existing table.
One of the field in my table is "ChangeDate".
There may be a couple of rows (more than one customer) for one ChangeDate.
All the fields' name of the table:
custcd, changeDate, creditLimitY, creditLimitN, userID
I need to run a query to show day 1 till the last day of the month (i.e.
1st
till 30th or 31st). The format of the "changeDate" is mm/dd/yy. Since
the
"changeDate" does not cover all the "dates" of the month in the table,
can I
still run a query with the following requirement:
(1) add the no-activity day's "date" in the "changeDate" field;
(2) the words "Nul change" in the "custcd" field.
I have already created 2 extra fields "Month" and "Year" in the query
using
the "changeDate" field to pull the relevant month and year.
Reason for running the query, I need to ex****t to Excel. My colleague
doesn't want to have the re****t but Excel worksheet that he needs to work
on.
Please help.
thanks
Karen
|
