Creation of a Suspense Date

[bertc]

Part of database is a column for a completion date and another column for the
suspense date which will be 90 days proir to the completion date. How do I
create a suspense date automatically calculated from the completion date?

 

[KARL DEWEY]

Suspense Date: [Completion Date] - 90

 

[bertc]

Where does this data go in the design? Should the SuspenseDate be a date or
text? I've tried using it as a date but I keep getting a mismatch error?

Suspense Date: [Completion Date] - 90

Part of database is a column for a completion date and another column for the
suspense date which will be 90 days proir to the completion date. How do I
create a suspense date automatically calculated from the completion date?

 

[KARL DEWEY]

Open your query in design view and add to the FIELD row of the grid.

Where does this data go in the design? Should the SuspenseDate be a date or
text? I've tried using it as a date but I keep getting a mismatch error?

Suspense Date: [Completion Date] - 90

Part of database is a column for a completion date and another column for the
suspense date which will be 90 days proir to the completion date. How do I
create a suspense date automatically calculated from the completion date?

 

[PC Datasheet]

If you go to your next post you'll get a solution where you don't get this
error!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Where does this data go in the design? Should the SuspenseDate be a date
or
text? I've tried using it as a date but I keep getting a mismatch error?

Suspense Date: [Completion Date] - 90

Part of database is a column for a completion date and another column
for the
suspense date which will be 90 days proir to the completion date. How
do I
create a suspense date automatically calculated from the completion
date?