Phantom Number on a Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am assisting a colleague with an inherited payroll type database with one
report that keeps showing phantom data twice. We have deleted all instances
of the data on all the tables that feed the report and the numbers go away,
but when we add the data, it show up twice.

This only happens for one employee. We have ran a detect and repair utility
on the database with no luck.

Any suggestions on what to do next?
 
I can't see the datasheet view of the query - I am asked to:

Enter Parameter Value
Forms!frm_Parameters!Employee_Menu

The "Forms!frm_Parameters!Employee_Menu" is under Criteria in the Layout
view under the Employee Field.

When I look at the tables that make up the query, there are two weeks of
payroll data. When we run the report, the two weeks print twice.
 
ok, open your report, then minimize it and open underlying query (it will
have the parameters then). Do you see double data? I'm trying to figure out
if the problem is with a query or the report. If you see double data in the
query you can go to query propertise and change Unique Values to yes.

Barb
 
I did what you said and was able to see double data! I went to query
properties, changed Unique Values to yes, but the report did not change. The
report is a payroll report that lists the employees wages for week one and
week two of the pay period. (It can also include their bonus and
reimbursements.) The report I am looking at is a "temp report" that is used
until the payroll is finalized by the payroll company, then the final numbers
are entered and the final numbers are moved to the employees' permanent
record. It is so weird the data is appearing twice only for this employee.
 
If query with unique values is showing like double data, values are unique.
In that query where you have employee parameters there is a name of the table
which generates that (looks like Table:"Name"), open that table and check for
this employee, It's probably typed twice but with two different Id numbers -
thus creating two records. If it's a query not a table follow it.

Barb
 
There were two tables in the query, one with payroll data, one with bank
info. I kept focusing on the payroll data - but took a look at the bank info
upon your suggestion. We had an extra record in the bank info table! After
deleting it the report ran correctly. Thank you for your patience and
assistance.

Lynne
 
Back
Top