Pivot tables in Access - Conditional Formatting?

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

HI

I'm currently converting a spreadsheets that over grown,
into an Access database. Ont he old XLS, there was a
report that had names across the top, products down the
side, then the corresponding cell was coloured for a
given status (ie blue for complete, red for work in
progress etc).

I can re-create most of this report without problems -
with exception of colouring the cells (which was done
manually previously). How can it be done? Ideally, it'd
be like applying conditional formatting to a cell in
excel, but not sure how to do this in acces. I have got
he data into a pivot table, but with numbers not colours.
Any idea of how to change it (ie if no. =1, blue, if =2,
yellow etc)??

Thoughts appreciated as evver
tim
 
Tim said:
HI

I'm currently converting a spreadsheets that over grown,
into an Access database.
Click to expand...

No need to re-invent the wheel. Keep the Excel workbooks. Move the
data to Jet database tables. Use a data access (small 'a') technology
on the Excel side to fetch the data as and when required. The popular
data access choices in Excel are MS Query (GUI tools) and ADO (VBA
code).

--
 
Hi Tim,

I missed your original post but I would qualify Onedaywhen's response as
follows:

Yes, import your data into an Access database. If you or your users need to
muck about at a low level in Excel then do as Onedaywhen suggested.
However, if your pivot table will always be of the same form factor then I'd
try doing it in Access. This is especially true if you're generating
reports ... so much easier to fire off a report in Access than to manually
process and fire off many reports in Excel.

Note that you can provide a much more user friendly and much less error
prone data entry form in Access than you normally would in Excel.

HTH
 
Tim said:
Both answers about as helpful as a good kick in the
balls. Thank you both.
Click to expand...

Tim: Hey Boss, the Excel report tool has 'over grown'. Can I do a
total re-write using another app?

Tim's boss: Can you really re-create all of this report without
problems?

Tim: Sure can!

--
 
Back
Top