5 replies
by nelson.b.garcia Accepted solution
by absolutely Accepted solution
Would need to know more about the control
source. From what you've provided, it just
looks like the reports are retrieving
different data because the tables hold
different data. Have you looked in
Datasheet View at the tables and confirmed
that they hold the same number of records?
by nelson.b.garcia Accepted solution
Everyone uses the same database from the same file on the same network. Yet the computer updated with sp2 will show just zero's on certain field in certain reports.
For example, the database in one case pulls up a list of current construction contracts. One fields displays number of modications done to that contract, Now I ran the database on a laptop running sp1 simultaneously while running it on desktop updated with sp2 and on the laptop it shows the correct number of mods, on the desktop it just shows a bunch of zero's
This is the case throughout the database and with different reports. I can't figure out why.
by absolutely Accepted solution
It sounds like the field is being
identified as a number OK, but the value is
not being retrieved. Probably one of the
queries that retrieves for the form used by
clients to the shared database needs to be
reset. Without a lot more detail about the
table structures, it's impossible to be
more specific.
by absolutely Accepted solution
This discussion is closed to new replies.
Trending Software posts
Sort by Trending