Ken-
You can check for "missing" dates like this:
SELECT R1.RcdDate - 1 As DateMissing
FROM MyTable As R1
LEFT JOIN MyTable As R2
ON R2.RcdDate = (R1.RcdDate - 1)
WHERE R2.RcdDate IS NULL;
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jun 6, 2015, at 4:06 PM, statmanbp@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Thanks John,
I guess I could create both queries and have the report check for record dates and if a date is missing run the old query if they exist run the new query. Just feels like creating databases I spend more time on how the user can screw up than on what information I want. Oh well Thanks for the advise.
Ken
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (10) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar