Information is not supposed to show in report

[Guest]

I have a database that has a column called "project number", where obviously
we enter projects by their number, and it's sorted ascending with criteria
from another column called "status", to only show those entries with the word
"pending" in the status column.
The way this was set up was when we needed to log a project number, but
didnt want it to show in a report, we put a peroid after the number, and it
would stay in the database, but not show in the report. Suddenly, last week,
these items started appearing in the report. Does anybody know what the
creator of this database did when creating this, or how to get back to not
showing?

Thanks,
Kevin

 

[Joseph Meehan]

I have a database that has a column called "project number", where
obviously we enter projects by their number, and it's sorted
ascending with criteria from another column called "status", to only
show those entries with the word "pending" in the status column.
The way this was set up was when we needed to log a project number,
but didnt want it to show in a report, we put a peroid after the
number, and it would stay in the database, but not show in the
report. Suddenly, last week, these items started appearing in the
report. Does anybody know what the creator of this database did when
creating this, or how to get back to not showing?

Thanks,
Kevin

Somewhere I would guess there is a filter limiting what is shown.
Typically that could be in a query or in the report itself or maybe in some
code. Do you know where this filter is and could you tell us more about
it? What exactly does it say?

Is that field called "status" a number field, a text field what? Is it a
required field?

Since there are so many ways of doing this, we could only guess what the
"creator" did. It might be best to ask the "creator".

However, just for fun, try doing a create and repair (do you know how?)
That sometimes fixes problems that seem to come from nowhere.

 

[Guest]

Thanks for the response. The repair did not work, and unfortunately, the
database creator is no longer with us.
Criteria:
status is a text entry field. It can say pending, in progress, awarded,
lost, on hold. In this specific report, it is only to show those project
numbers which status' read pending or in progress, which it does.
Project Number column is a numerical entry field, not to exceed 6 numbers.
Currently, no numbers exceed 6 numbers.
Example: One entry 06416 pending
06416. pending

The second entry used to not show in the report because of the period, but
it started to as of late, and I cannot figure out why.

 

[Joseph Meehan]

Thanks for the response. The repair did not work, and unfortunately,
the database creator is no longer with us.
Criteria:
status is a text entry field. It can say pending, in progress,
awarded, lost, on hold. In this specific report, it is only to show
those project numbers which status' read pending or in progress,
which it does.
Project Number column is a numerical entry field, not to exceed 6
numbers. Currently, no numbers exceed 6 numbers.
Example: One entry 06416 pending
06416. pending

The second entry used to not show in the report because of the
period, but it started to as of late, and I cannot figure out why.

A numeric field does have a period. It does have a decimal point. In a
numeric field there is no difference between 6416 06416 6416. or 06416.
No matter how you would enter them they would all be stored as the number
6416

All those numbers are numerically the same.

If that were a text field then they all would be different.

I am not sure how they would help, but something in your assumptions is
wrong.

 

[Bill Mosca, MS Access MVP]

There are many ways to filter what shows in the report so you will have to
look at the code that opens the report or maybe the query for the report or
the report itself.

Just off the top of my head I'm assuming that the filter is looking at a
specific character in the project number and that number has grown so that
the character being tested is now another numeric instead of a period.

How are you opening the report? Is it by clicking a button on a form?

 

[Guest]

My apologies, the field in the table is marked as text, 6 characters. I
thought it was numeric, but it's actually text.

 

[Guest]

The report itself is opened in the database window, which prompts you to
enter a beginnig date and ending date as its supposed to. But there is a form
that was made to input the criteria for our staff. It is in that entry form
where the staff member would enter the period if he didnt want that entry to
show on the printed weekly report.

 

[Bill Mosca, MS Access MVP]

Kevin

The problem might lie within the report's code (if it has any). If you poen
the report in design view and then click on the code icon, the VBA editor
will open and display the report's code.

Do you get the right records if you just run the query that the report uses?

 

[Bill Mosca, MS Access MVP]

I'm glad I could point you in the right direction.