make a calculated date appear in a datasheet/report

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

Guest

I have a database that is tracking re-inspection dates according to
regulations. the calculation works well, but doesn't appear in the datasheet
(or any reports that I run from the data) doesn anyone know how to make a
caculated date appear in the datasheet or reports?

Thanks
K
 
K,
Not sure what you mean by that, but...

Place the same calculation you used to determine the Re-Inspect date in
the first place..in the query behind your datasheet, or report.
Ex. Price * Qty = LineTotal

In a query with Price and Qty fields create a calculated column like
this...
LineTotal : Price * Qty
will create a calculated field that will appear on your datsheet, or be
placed on your report.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Datasheet Total Row 3
Displaying a calculated value 2
Total Row in datasheet view has problems if using ADP / SQL 4
How to see a report in a form 3
Resize textbox in a datasheet 4
Is there a way to view a checkbox in my calculated query field? 3
Access 2007: How to clear sort on column in query data sheet view? 2
Access2007 show hide columns in datasheet 6

Back
Top