Re: Access report



On Feb 28, 10:37 am, Salad <o...@xxxxxxxxxxx> wrote:
zufie wrote:
I added all the tables, forms, reports and cmd buttons concerning an
addition to a database.

I entered data for Q1 in order to produce a report but received no
output on my report.

I tried the same thing for an addition that was fully functional and
that I used as a template.

Probably something in the qry for my report? Any ideas?

I am in my 28 month at my job and there is SO much I still do not
know!

Thanks!

Zuf

There's one thing you could check.  In the Reports OnNoData event, enter
        msgbox "No Data"

Now run the report.  Do you get that message?

If so, open the Report's property ***, click on data tab, and
dbl-click on the ... button for the Recordsource.  Try to run the query.
    I would think something is wrong with the recordsource...perhaps the
links.  For example, you have have two tables with a link line (Inner
Join) between the two.  Maybe one of those tables don't return any
records.  If you dbl-click on the link line, you can change it so all
records from the main table are returned and matching records from the
secondary table.  Maybe you have a filter that needs to be removed.

Who Knewhttp://www.youtube.com/watch?v=cJmghwq7k2I- Hide quoted text -

- Show quoted text -

Thanks. The copy of the database I was working on was corrupted as I
received a healthy copy of it from the end user.

I will have to repeat all my work, but I learned a lot and thank you
for your help!

Zuf
.


Quantcast