How do I get the time to show in my report?

G

Guest

I am running Access 2000-2003 and designed a databass for our call-center.
When adding a new record in the forms moduel the time is automaticaly filled
in. When I run my report at the end of each day, the time when the call came
in does show up on the report for each call-in request. How do i get the
time to show up in the report for each call-in request?
 
F

fredg

I am running Access 2000-2003 and designed a databass for our call-center.
When adding a new record in the forms moduel the time is automaticaly filled
in. When I run my report at the end of each day, the time when the call came
in does show up on the report for each call-in request. How do i get the
time to show up in the report for each call-in request?

Regarding...
the time when the call came in does show up on the report for each call-in request.
How do i get the time to show up in the report for each call-in request?

Am I missing something here?
 
G

Guest

samatwork said:
I am running Access 2000-2003 and designed a databass for our call-center.
When adding a new record in the forms moduel the time is automaticaly filled
in. When I run my report at the end of each day, the time when the call came
in does not show up on the report for each call-in request. How do i get the
time to show up in the report for each call-in request?
 
F

fredg

Thank you for clarifying you message.

If the Time control on the Form is bound to a field in your table (not
just displayed in the form), then include that field in the report. In
Report Design View, click on the Field List tool button and click on
and drag the field onto the report.

If a Query is the record source for the report, add that Time field
from the table to the query. Then the Time field will show up in the
Report's Field List tool button. Click and drag it onto the report.
 

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

Top