Select by Date Range

16 01 2009

I think I may be on the right track!

I have edited the SpR Details Form and Table to include a Start and End Date.  The Summary Forms will contain data regarding procedures between these dates (inclusive) only.  This is obviously important for the RITA process, when a “12-month” and “duration of training” summary is necessary to expedite the process.

Each of the initial Queries needs to be edited to include DateOfProcedure as a field.  Furthermore, StartDate and EndDate also need to be added as fields; StartDate and EndDate need to be assigned aliases (Start and End respectively).

Then, the query criteria for DateOfProcedure needs to be done in SQL mode, since OO doesn’t allow it in the Design View.  I am not sure whether this is a universal function, or purely HSQL dependent.

The following WHERE criteria needs to be added (using parentheses with AND if necessary):

WHERE “AngioTable”.”DateOfProcedure” BETWEEN “Start” AND “End”

I am still experimenting a little, but am hopeful this will work.

EDIT: Turns out you can do it in Design View… The CRITERIA is entered as

BETWEEN [Start] AND [End]




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: