Form Design

I am a complete rookie when it comes to Access but I have managed to create a
database with 2.2 million entries. I would like to design a form using the
Symbol for the company [enter symbol:], the Date, and the Low Rate Price
[enter low rate:]. The problem I am encountering is the low rate as I would
like to be able to use < or > in the form. I know the info can be provided
by way of a query but with this many entries in the database, a form would be
so much easier rather than opening the query and changing criteria all the
time.

I'm sure you can tell I'm new to this.. I just hope I have explained
properly what I'm trying to do. Any help and assistance would be greatly
appreciated.
.

Relevant Pages

  • Re: [PHP] Problem with SELECT statement and reference material wanted..
    ... echo you query and then run it on mysql and see u getting the desired ... I'm having trouble retrieving a selection of my database contents. ... ..I will get all entries from the database, ... required to be named as the column names in the MySQL table, ...
    (php.general)
  • Re: Access Table Sorting/Query Last Function
    ... I've put in a number of test entries to ensure it works, ... of the Lastin your totals query. ... I've been designing a database that basically works off two tables. ... I've done this so that I can pull the last entered ...
    (microsoft.public.access.tablesdbdesign)
  • SQL Server - Very long query time with OpenJPA and Hibernate
    ... I have a table with close to a million entries. ... Query Analyzer to obtain results within say 3 seconds. ... That's on a production server, ... that the program is the only thing accessing the database server. ...
    (comp.lang.java.databases)
  • Re: SQL Server - Very long query time with OpenJPA and Hibernate
    ... I have a table with close to a million entries. ... Query Analyzer to obtain results within say 3 seconds. ... That's on a production server, ... that the program is the only thing accessing the database server. ...
    (comp.lang.java.databases)
  • RE: Form Design
    ... in to the query criteria boxes so you never have to open up the query. ... database with 2.2 million entries. ... Symbol for the company, the Date, and the Low Rate Price ...
    (microsoft.public.access.forms)