bring up date/numbers in querie or report in access

[Guest]

help could someone please advise of how to bring up numbers or dates within a
querie and a report and the moment it's bringing up numbers as blank and
dates as num#?

 

[John Vinson]

help could someone please advise of how to bring up numbers or dates within a
querie and a report and the moment it's bringing up numbers as blank and
dates as num#?

Base the Report on a query which retrieves the fields that you want to
see, and set the Control Source property of the textboxes on the
report to the name of the field you want to see.

Bear in mind: we cannot see your database, and do not have any way to
know how your current report is set up. Evidently there's an error of
some sort, but we can't even guess what it might be. Care to give us
some help?

John W. Vinson[MVP]

 

[Guest]

when trying to bring up date and telephone numbers on the querie which the
report is based on they are coming up as blank. I am aware i need to set the
criteria to show numeric values but can't remeber what command to use within
the criteria for these fields !! help me!!!

 

[Guest]

when trying to bring up date and telephone numbers on the querie which the
report is based on they are coming up as blank. I am aware i need to set the
criteria to show numeric values but can't remeber what command to use within
the criteria for these fields !! help me!!!

 

[John Vinson]

when trying to bring up date and telephone numbers on the querie which the
report is based on they are coming up as blank. I am aware i need to set the
criteria to show numeric values but can't remeber what command to use within
the criteria for these fields !! help me!!!

Since you chose not to post any details of your table structure, or
the SQL of the query, or what criteria you want to apply... as much as
I'd like to, I can't help you. My telepathy is definitely on the blink
today.

Again... PLEASE... post some information about your database and about
your problem. The name of your table; the names and datatypes of the
fields; the SQL of the query that you now have; an explanation of what
"numeric values" you want to see (dates and telephone numbers are
Date/Time and Text datatypes, typically, not numeric values);
*something* that would let a person who is not familiar with your
database come up with an answer.


John W. Vinson[MVP]