Excel assignment
sbsiemens
go_a01_grader_h3_construction.accdb| ID | Title | Start Time | End Time | Location | Description | Attachments | mSysRowId |
|---|
| ID | Object Type | Object Name | Filter Name | Filter String | Sort String | Default | Description | mSysRowId |
|---|---|---|---|---|---|---|---|---|
| 1 | 2 | Event List | Start Time = Today | (Year([Current Events].[Start Time])=Year(Date()) AND Month([Current Events].[Start Time])=Month(Date()) AND Day([Current Events].[Start Time])=Day(Date())) | false | ybN+E2+Vunx6dZqStzal/hRLvxi74FJA1lAxxEWj7jQ=-~+FUg6pwHQHxxpvSPsk3mkg== | ||
| 2 | 2 | Event List | Start Time = This Week | (Year([Current Events].[Start Time])=Year(Date()) AND DatePart("ww",[Current Events].[Start Time],0)=DatePart("ww",Date(),0)) | false | b8PzGHwDKowV8qvJ4QOGnWN4j5EPKYjL6esRCPVCIJk=-~//oMWW0DcivuNQDXgNDqJQ== |
| ID | mSysRowId |
|---|---|
| 1 | tHL4zn3WsYPHFUXGe+YnlEWkzarJzOECe2I2AHBTick=-~RN8AyUQbpdtK99n6Z62E9w== |
SELECT "-1" as [ID], "(Manage Filters)" as [Filter Name] FROM Filters UNION SELECT "0" as [ID], "(Clear Filter)" as [Filter Name] FROM Filters
UNION SELECT ID, [Filter Name] FROM Filters WHERE ((([Object Name])=[Application].[CurrentObjectName]))
ORDER BY [Filter Name];
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "*Subreport*") AND ((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;
SELECT Filters.ID, Filters.[Object Name], Filters.[Filter Name]
FROM Filters
WHERE (((Filters.ID)<>Nz([Form]![ID],0)))
ORDER BY Filters.[Object Name], Filters.[Filter Name];
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32768))
ORDER BY MSysObjects.Name;
SELECT DISTINCTROW *
FROM Filters;
SELECT *
FROM Events
WHERE (((Events.[End Time])>=(DateAdd("h",-24,Now())) Or (Events.[End Time]) Is Null));
