Formatting Date Cell with No Values
Im using the TransferSpreadsheet Action in my access macro db to
automatically transfer data to an Excel spreadsheet. The data gets
transferred to the worksheet €śqryRequirement _Status_NotComp_b€ť (Sheet 1).
In my adjacent worksheet €śNot Completed Requirement€ť (Sheet 2), have
formulated cells to copy data from Sheet 1. One column heading is €śDate
Completed€ť. The following formula is in the date cell of Sheet 2:
=+qryRequirement_Status_NotComp_b!F2; formatted as date fields. Excel 2003
In Sheet 1, not all the cells under the DateCompleted contain values. When
the data gets copied to Sheet 2, those date values that are empty in Sheet 1
result in a 0 (zero) in Sheet 2; resulting in 1/0/00. I want those cells
with no values to remain empty in Sheet 2. I havent used any coding in
Excel, and was wondering if there is a way to get this accomplished. Any
suggestions would be helpful.
|