B
Bonnie
Hi,
I have two tables: AllTitles and TitlesHistory. AllTitles contains the
total of the titles that I update monthly and the TitleHistory has a record
appended each time I update a title and includes the date. I am trying to
create a query that will show me all Titles that have not been updated yet
for the current month. Here's the SQL I have started with:
SELECT AllLists.List, AllLists.[Total Count], AllLists.LastUpdate,
AllLists.DateSent, ListHistory.DateSent,
MonthName(DatePart("m",[listhistory].[datesent])) AS MonthName
FROM ListHistory INNER JOIN AllLists ON ListHistory.List = AllLists.List
WHERE
(((MonthName(DatePart("m",[listhistory].[datesent])))<>MonthName(DatePart("m",Now()))))
ORDER BY MonthName(DatePart("m",[listhistory].[datesent]));
Can anyone give suggestions on the best way to do this?
Thanks in advance.
I have two tables: AllTitles and TitlesHistory. AllTitles contains the
total of the titles that I update monthly and the TitleHistory has a record
appended each time I update a title and includes the date. I am trying to
create a query that will show me all Titles that have not been updated yet
for the current month. Here's the SQL I have started with:
SELECT AllLists.List, AllLists.[Total Count], AllLists.LastUpdate,
AllLists.DateSent, ListHistory.DateSent,
MonthName(DatePart("m",[listhistory].[datesent])) AS MonthName
FROM ListHistory INNER JOIN AllLists ON ListHistory.List = AllLists.List
WHERE
(((MonthName(DatePart("m",[listhistory].[datesent])))<>MonthName(DatePart("m",Now()))))
ORDER BY MonthName(DatePart("m",[listhistory].[datesent]));
Can anyone give suggestions on the best way to do this?
Thanks in advance.