Programming a report in excell??

[basstbone]

Is it possible to have access create a report in excell and then delete some
characters out of the excell report? I'd like to get a 2 colomn report from
a couple of inventory databases. One database has information on lost
equipment, another for repaired equipment. I'd like the finished report to
look like this below:

Repaired staplers Missing Staplers
1 mollys mollys first
2 bills bills second
3 daves daves fifth

For whatever reseaon I needed a serial autonumber in the database design to
tie the databases together to get any kind of report...so one missing stapler
record would have "x" as default values for the repair fields and the correct
information for the missing fields (and visa versa), making the report appear
as below

Repaired staplers Missing Staplers
1 x mollys first
2 x bills second
3 daves x

How do tell excell, from access to find & replace all the "x's" with nothing
and then move the other information up so the above report looks more like:
Repaired staplers Missing Staplers
1 daves Mollys first
2 Bills second

Thanks in advance!!

 

[Clifford Bass]

Hi,

Some basic questions: Why are there two inventory databases? Better
to use a shared database if possible. Is there duplication of data between
the databases? Some? Complete? None? With different databases, an
autonumber field will not provide any way to associate data in one database
with data in another. If Molly's stapler is added first in one and Bill's is
add first in the other, both would have the number 1. You would really need
to use an inventory number or something similar. Why are missing staplers
listed with repaired staplers in the same table in parallel columns? Is the
value that indicates that the repaired or missing stapler column does not
apply always an "x"? What if some stapler has been damaged and repaired more
than once--how is that recorded? Likewise, if Molly loses and finds her
stapler on a regular basis, how is that recorded? Finally, why do you need
it to be in Excel? How about a report in Access that that has two
side-by-side subreports? One reporting the repaired staplers and the other
the missing staplers. If you can modify the design, it really needs a
staplers table that uniquely identifies a particular stapler (stapler ID,
brand, model, type, purchase date, etc.). And maybe a stapler status table.
In it you would have a the stapler ID, a date and a status (damaged,
repaired, lost, found). Another table maybe needed to record the current
owner of the stapler (stapler ID, owner ID, start date, end date).

Some thoughts that I hope will be of help,

Clifford Bass