Creation of a Suspense Date

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

Guest

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?
 
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?

KARL DEWEY said:
Suspense Date: [Completion Date] - 90

bertc said:
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?
Click to expand...
Click to expand...
 
Open your query in design view and add to the FIELD row of the grid.

bertc said:
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?

KARL DEWEY said:
Suspense Date: [Completion Date] - 90

bertc said:
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?
Click to expand...
Click to expand...
Click to expand...
 
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


bertc said:
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?

KARL DEWEY said:
Suspense Date: [Completion Date] - 90

bertc said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top