Sikh Philosophy Network - View Single Post - Access 2000 view Outlook 2000 Inbox error

#3 (**permalink**) 01-Nov-2005, 13:40 PM

Hi Graham
Thanks for taking the time to help me. The SQL of this query is a s
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6295-access-2000-view-outlook-2000-inbox.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6295
follows:

SELECT CDbl(Format([Received],"yymmddnnss")) AS InboxID, ([Created]) AS
CreatedDate, ([Created]) AS CreatedTime, Inbox.From, Inbox.To,
Inbox.Subject, Inbox.Contents, NumbersOnly([Subject]) AS
NumbersInSubjectField, Right([NumbersInSubjectField],10) AS
ListingEbayNumber, Day([received])+10 AS IDDay, Hour([received])+10 AS
IDTimeHour, Minute([received])+10 AS IDTimeMinute,
Second([received])+10 AS IDTimeSecond
FROM Inbox
WHERE (((NumbersOnly([Subject])) Is Not Null) AND ((Day([received])+10)
Is Not Null) AND ((Hour([received])+10) Is Not Null) AND
((Minute([received])+10) Is Not Null) AND ((Second([received])+10) Is
Not Null))
ORDER BY Inbox.Subject;