access query using greater than function

[jlawanda]

hi,
I inherited a query I use in Access 2010. Currently it identifies >4 entries. however I would like the entries to be listed. How can I achieve this? thanks

[zmbd]

jlawanda
You do not mention if this is a form, report, or query.

Forms and reports:
There are several ways to limit the data shown in either object. This can be done by on the fly filters via the ribbon by the user, in vba, macro, or by design. Then there is the actual underlying record set, usually a query, that can be the root cause of the limited records. You will have to provide much more detail.

Because most forms and reports start with either a table or query as the record source, let us look for the query that you are either using or is being used by the object you are using:

+ always make a backup of your active database before making any modifications. In fact, this is best practice to always have a backup of your files. The more critical the data - the more often you should backup the file!

+ Open your database.
++ if it's not visible already, [F11] to open the Database objects navigation pane
+++ find the query that is returning only the ">4" entries. Select (left-click once), <ctrl><c>, <ctrl><v>, rename the new query or leave it as "copy of ..." default. Personally I rename these so that I can tell what they do.
++++ Open the COPY of query you just made in design view. You will see two section top with the underlying data source and the bottom table. Within that table is an entry with the ">4" in the criteria row delete the entry in the row... NOT the column.
+++++ Save this new query and run.
You can now use this to either alter your form/report or better yet, modify a copy of these or build a new one.