Displaying information associated with an ID number

[Nova_C]

Unfortunately, I've been given a half completed database and told to finish it. Unfortunately, I've never used Access before, and I'm having trouble getting it to display some info in a report. The info in a table is in two columns, an ID number in the first, and then the description in the second. This occurs in two tables and I need to display the text of one, then the text of another in the same expression. The first will only display the ID number, but the second displays the text properly. I can't see any difference between the two, so I have no idea what to do. btw, here's the statement :
=[qryTown Assets.Department ID] & ", " & [qryTown Assets.Location]

 

[David R]

Probably what's happened is if you go to look at the Design view of the Query "qryTown Assets", the 'lookup' table is missing. Is there a table called tblDepartments or something similar?
If so, right-click in the grey top part of the query and Show Table: tblDepartments. Hopefully a relationship line will appear between [Department ID] in one table and [Department ID] in the other. If not, draw a line joining them. Then in the bottom part of your query remove the field called [Department ID] and drag down or double-click the tblDepartments.DepartmentDesc field. (I may have the name wrong, but it'll be the column of the table with the text you actually want).
Look at the other query (the one that works properly and shows text) to see an example of what it should end up looking like.

Finally, change your statement in the report to =[qryTown Assets.DepartmentDesc] & ", " & [qryTown Assets.Location]

Hopefully that helps. Database maintenance on someone else's project can be a real bear, and from the looks of things your predecessor was no Einstein at building databases in the first place.

[This message has been edited by David R (edited 04-25-2002).]

 

[Nova_C]

Hey, thanks David. While that solution didn't exactly fit, it pointed me in the right direction. Much appreciated.