Pivot table formats

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

Guest

I have created a pivot table that has three fields; Date, raingauge and rainfall. I want to export the output of this table into an Access database. However the table produced only lists date as a single entry instead of listing the date for each raingauge. Therefore I have to manually fill in the missing date data to export it to Access. Is there any way of formating the date field so that it is listed all the way down the table

thank

Alan
 
What you can do is copy the pivot table and paste special
value over itself. Select the entire range with the
Click to expand...
gaps, press F5 > Special > Blanks > OK. Now press "=" and
click the first entry in that column and press
<ctrl><enter>. Copy and paste special > value over the
column to eliminate the formulas.

HTH
Jason
Atlanta, GA


-----Original Message-----
I have created a pivot table that has three fields; Date,
Click to expand...
raingauge and rainfall. I want to export the output of
this table into an Access database. However the table
produced only lists date as a single entry instead of
listing the date for each raingauge. Therefore I have to
manually fill in the missing date data to export it to
Access. Is there any way of formating the date field so
that it is listed all the way down the table?
 
Back
Top