need help creating a report from 2 tables

[MTulloch]

I created a database in access 2013 (I am not that good).


Created 4 tables as shown
in inventory table the (username field is only an ID#)
in Users table,( username column is a name.)

so I tried report wizard and added
UserTable:Building #, UserName
and then
InventoryTable: Equipment Type, Make, Model, SN

I grouped them by Building#
then sorted by equipment type

I kind of expected to see a report with all the data in those fields but the report comes out empty except the headers.



I wished to see a report with the actual UserName rather than just a user #


any ideas? either the design problem or whatever I need to do to get data from more than one table


thanksInventory-try-form.docInventory-try-form.doc

[NTC]

I don't completely follow your post; but make a query that joins the tables. This way you will have the name as part of the record set. Save that query with a name. Then create a Report and select that query as its bound source rather than a table.

[MTulloch]

I will try that....
except the entire report returns NO data in any field. I suspect I am doing something else wrong.

[ssanfu]

My $0.02.......

in inventory table the (username field is only an ID#)
in Users table,( username column is a name.)

It looks like Users.username is a text field and inventory.username is a number field and they are linked. This will never return any records.
Linked field MUST be the same type.

There is a reason for having primary key fields and foreign key fields. Your tables are not linked by PK/FK.


Looking at the doc, there are several things that I would suggest changing.
All PK field are named identical - "ID".
There are spaces in field names.
There are special characters in field names

Object names should be letters and numbers, NO spaces, No punctuation, No special characters (exception is the underscore).

[MTulloch]

Ok. will try that. actually even though the userID# was a number, I changed that to a text field so both were text fields.

I have some work to do on the tables and have no idea how actually