Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Help please!!? (In Access)

Dec 1, 2003 7:15PM PST

In access after I create a report by using wizard, I had an empty report. I mean a report without details or informaition. I face the same problem with the query as well .help please. It's my IT project

Discussion is locked

- Collapse -
Re:Help please!!? (In Access)
Dec 1, 2003 7:58PM PST

"It's my IT project"

There are too many missing details. Why not talk with your other team members at work and see if they see the issue?

Bob

- Collapse -
Re:Re:Help please!!? (In Access)
Dec 1, 2003 10:10PM PST

I'm working on this project by my own. I think the problem is with the relation ships between the tables 'couse when I change the relations ships some columns show up in the query.

- Collapse -
You write an IT project.
Dec 1, 2003 11:32PM PST

I've yet to find an IT staffer that lasts long if they don't work with their team. Surely there is someone at your work that you can consult one-on-one with this.

I'd love to help, but details are too sparse for me to comment here.

Bob

- Collapse -
Re:You write an IT project.
Dec 2, 2003 6:23AM PST

True you have given limited information but let me try to help...

It sounds like your relationships are indeed incorrect. If you have 2 or more tables, you will need a common field in both tables to build a relationship. For instance SSN in Tbl1 ties to SSN in Tbl2. If your relationship is built like SSN in Tbl1 tied to DL# in Tbl2, you will not get any records because SSN should never be the same as DL#. If you have a primary key that was created by access (usually numbers from 1 to whatever), I would not build a relationship on this field. Build the relationship on a value that you create or type in because the access created primary key is a consecutive number.

You might want to build the relationship as showing all records from Tbl1 - or your main table - and show only those that match from Tbl2. Of course this is if you have more than one table you are connecting in a query.

If you have one table, you should not have any problem having values shown unless you created a criteria in your query.

- Collapse -
Imagine this is their homework or IT class assignment.
Dec 2, 2003 6:28AM PST

Would you give them the answer?

Bob