1

In access it is very easy to use it: BETWEEN [minimum] AND [maximum]

But what is the syntax in openoffice base?

petie
  • 77
  • 3
  • 13

1 Answers1

1

There are two ways to do this. First is to have the query ask for user input. Colons are used to indicate user-input parameters, like this:

BETWEEN :MINIMUM AND :MAXIMUM

Second is to use a one-row filter table. Tie the user's form to this one row by making the form source something like SELECT * FROM "Filter" WHERE "FilterID" = 1. Then the user will enter the dates into the filter table, and the query will have a join to the filter table to determine the dates.

Lyrl
  • 925
  • 6
  • 16