I am trying to figure out, for my small business in generating reports, how
to make the report generate with only a specific range within a certain
field. The most important one is with dates, I want it to come up and ask me
which date range I would like to show, based upon my report which gets all of
its information from one single table. The report works great to show the
information, but it shows everything in the table. My first thought was to
apply a filter, which will limit what is shown in the desired table, but when
I run the report, the filter no longer functions to only show the desired
dates, and shows all information. I used Access help and it point me how to
create a query which prompts for a specific date range, and it did prompt me,
and I applied the query just to the date field range on the report, which did
not work at all, all of the records came up and this time instead of showing
the date, it read "error". My next step was in Access help when I searched
for "date query in reports". One of the results on this directed me to create
a query as a "recordsource for a report" where I created a query from the
Property Sheet --> Data Tab --> Record Source, and again selected the date
field from the desired table and then put in the query prompt perameters for
the date. The date field is the ONLY field that I indicated in this query,
saved it, then ran the report. This time, it prompted me for the desired
start date and end date (WHICH IS EXACTLY WHAT I WANTED AND IT WORKED
PERFECTLY TO ONLY INPUT THE DESIRED DATES) but then it prompted me for
information on every other field in the entire table, which is definitely
what I did not want. I tried just hitting enter, leaving each field blank,
but that screwed it up because then it would only bring back the exact values
that I type in, and I want it to bring up EVERY VALUE within the desired date
range. The next thing I thought about doing was to go back to my source value
query, bring up all the report fields, and attempt to make it show all
values. In order to do this, you have to have appropriate expressions, which
there is not one to show all fields, the closest one is IS NOT NULL, which
shows anything that has a value entered, but I often have one or two fields
per entry with no value. I don't care if I have to alter one of these
methods, or try a totally different one, how to I get a report to show only a
range of desired values of a field. I have been working on this report with
date values, but the next task is to work on a different report that will
filter out to show a desired customer based upon customer ID/account number.
How do I do this?