records won't show on report??

  • Thread starter Thread starter Melanie
  • Start date Start date
M

Melanie

Hello,

I am having a problem with my report that I can't figure
out. I have a report that is based on a query. The form
where I enter all my data is based on a table. The data
enters fine on the form, and shows up on the underlying
table. The problem is, when I go to run a report on a
record I have entered, I get no data on my report, just
errors. I don't understand what is happening, since the
query that my report is coming off of has the table with
all the information in it. And the information won't show
up on the query either. It just shows up in the form and
the table. Can anyone help? I probably did something
really dumb......Thanks for any help!
I am at a standstill on this.
melanie
 
-----Original Message-----
Hello,

I am having a problem with my report that I can't figure
out. I have a report that is based on a query. The form
where I enter all my data is based on a table. The data
enters fine on the form, and shows up on the underlying
table. The problem is, when I go to run a report on a
record I have entered, I get no data on my report, just
errors. I don't understand what is happening, since the
query that my report is coming off of has the table with
all the information in it. And the information won't show
up on the query either. It just shows up in the form and
the table. Can anyone help? I probably did something
really dumb......Thanks for any help!
I am at a standstill on this.
melanie

.
Click to expand...
 
Melanie it sounds as if you have some criterea set in the
underlying query that returns no records.
Mike
 
-----Original Message-----
Hello,

I am having a problem with my report that I can't figure
out. I have a report that is based on a query. The form
where I enter all my data is based on a table. The data
enters fine on the form, and shows up on the underlying
table. The problem is, when I go to run a report on a
record I have entered, I get no data on my report, just
errors. I don't understand what is happening, since the
query that my report is coming off of has the table with
all the information in it. And the information won't show
up on the query either. It just shows up in the form and
the table. Can anyone help? I probably did something
really dumb......Thanks for any help!
I am at a standstill on this.
melanie

.
Click to expand...
you aren't specific on the nature of the query. If the
record is missing entirely, and the query has an inner
join with another table, possibly there is no matching
record in the other table (switch to outer join). If
record does show up, but a certain field in blank, is
that a computed result of the query? (fix computation)
If the field is not computed and there is no join, I am
at a loss for why a field which shows in the table
doesn't show in the query. Database corruption?

Kip
 
Hello,
Thanks for your help, I looked further into it, and the
problem is in my two subforms on my main form. The two
subforms hold data on wires and tubing. The problem comes
in when I don't enter ay data in these two subforms for a
particular record (sometimes there is no data for these
subforms in some records). When I enter data in both of
the subforms, the report for that record prints out fine.
If I don't enter data in both of them, I get a report that
just has errors on it. Any ideas? Did I set up the
subforms wrong?
Thanks for any further help!
Melanie
 
Back
Top