Good Afternoon,
I'm really new at Microsoft Access, so I'm using a super basic contact
database template to store contact information for sales leads for my
business. All I need is a report that will pull from three tables:
-Contact Info (Name, Address, Phone #, referred by, etc)
-Contact Type (Residential, Commercial)
-Call Info (Call Date, Call Time, Call Notes, etc)

I use the report wizard, which clearly states I can pull info from more than
one table, and go through the formatting. But when I preview the report it
shows the header, field titles, but then does not populate the field. Please
help, I'm at my wits end with Access!!! Could the problem be I'm trying to
pull too much info?

Hi Vanessa,

I think you need a query to pull your information from the tables and then
use that query to feed your report. Now I noticed you said you have three
tables. Unfortunately, I don't do relational databases so that is beyond my
knowledge. However, if you are looking to make it simple, do a flat sheet
database which is all the fields on one main table but leave the Residential
and commercial table. Put the field on the main table but tie the res./comm.
table to a drop down box on your form. When completed, everything is stored
in one table and the queries are much more simple to create and reports are a
breeze. The people on this forum are very knowledgable and would recommend a
relational database but a flatsheet is also acceptable if you are not looking
for something complex.

Hope this helps!

"Vanessa" wrote:

> Good Afternoon,
> I'm really new at Microsoft Access, so I'm using a super basic contact
> database template to store contact information for sales leads for my
> business. All I need is a report that will pull from three tables:
> -Contact Info (Name, Address, Phone #, referred by, etc)
> -Contact Type (Residential, Commercial)
> -Call Info (Call Date, Call Time, Call Notes, etc)
>
> I use the report wizard, which clearly states I can pull info from more than
> one table, and go through the formatting. But when I preview the report it
> shows the header, field titles, but then does not populate the field. Please
> help, I'm at my wits end with Access!!! Could the problem be I'm trying to
> pull too much info?

On Fri, 22 Feb 2008 11:07:09 -0800, Vanessa wrote:

> Good Afternoon,
> I'm really new at Microsoft Access, so I'm using a super basic contact
> database template to store contact information for sales leads for my
> business. All I need is a report that will pull from three tables:
> -Contact Info (Name, Address, Phone #, referred by, etc)
> -Contact Type (Residential, Commercial)
> -Call Info (Call Date, Call Time, Call Notes, etc)
>
> I use the report wizard, which clearly states I can pull info from more than
> one table, and go through the formatting. But when I preview the report it
> shows the header, field titles, but then does not populate the field. Please
> help, I'm at my wits end with Access!!! Could the problem be I'm trying to
> pull too much info?

If you are attempting to get the report data from 3 tables, before you
do so you must first create a query that combines all the data. You'll
need to make sure all of the correct relationships are created. Then
create a new report, using the wizard, and use the query as the
report's record source when prompted.

If you have already done this step, then open and run the query. Do
you get all of the correct data shown?
If so, then make sure the query is actually the reports's record
source.

By the way, if one of your table fields is really named "Name" I would
strongly suggest you change it to something else, perhaps ClientName.
Name is a reserved Access keyword and should not be used as a field
name.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

"Vanessa" <(E-Mail Removed)> wrote in message
news:82F7C63B-0D14-4C8E-81EF-(E-Mail Removed)...
> Good Afternoon,
> I'm really new at Microsoft Access, so I'm using a super basic contact
> database template to store contact information for sales leads for my
> business. All I need is a report that will pull from three tables:
> -Contact Info (Name, Address, Phone #, referred by, etc)
> -Contact Type (Residential, Commercial)
> -Call Info (Call Date, Call Time, Call Notes, etc)
>
> I use the report wizard, which clearly states I can pull info from more
than
> one table, and go through the formatting. But when I preview the report it
> shows the header, field titles, but then does not populate the field.
Please
> help, I'm at my wits end with Access!!! Could the problem be I'm trying to
> pull too much info?

Are your tables actually linked together in the Relationships window,
Vanessa?
Evi