Help with converting number to name...

[drblackard]

I have a table with contactID, LastName, MiddleName,
FirstName, and Membership Dues Paid (check box) on it. When I use the query to separate the paid from the unpaid, all works well. But when I print the report I only get the contactIDs on the report, no names. So I went back and made a lookup combo box for the names using LastName, MiddleName, and Firstname...all show up in the box but the first name is the only name that prints on the report now...how can I get First, Middle, and Last names on the report. Thanks in advance..

 

[lespaul]

if the source of the report is a query, then only the fields in the query will be listed on the report. Change the query to have all the information you want in the report.

When you say you

went back and made a lookup combo box for the names

do you mean you added a lookup field in the TABLE?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[randy700]

Base your reports on queries such as...

SELECT LastName & ", " & FirstName & " " & MiddleName AS FullName, DuesPaid
FROM tblMembership
WHERE DuesPaid = 0

SELECT LastName & ", " & FirstName & " " & MiddleName AS FullName, DuesPaid
FROM tblMembership
WHERE DuesPaid = -1

or, maybe...

SELECT LastName & ", " & FirstName & " " & MiddleName AS FullName, iif(DuesPaid = -1,"YES","NO") AS [Dues Paid?}
FROM tblMembership

Randy

 

[drblackard]

I don't think I made myself clear, my fault...when I open the report, instead of having a name under the name heading, I have a contactID number and only my first name...I know there is a way of converting the contactID on the report to the persons name but it's been a while since I've done it...can you please help...Thanks

 

[lespaul]

what is the source of the report?

 

[randy700]

How about.... DLookup

Randy

 

[drblackard]

It is a query but the lookup box is in the table created for the membership...this way I can get the same spelling everytime for the members...Maybe this is where my problem is because it selects contactID, Lastname, middlename, and firstname...the reason I did the names individually (Lastname, middlename, firstname) is because I have a search feature that searches for last names and this was the easiest solution..however I did create a text box on the form that puts all the names together for one complete name...I think this is where my problem is though, maybe I need to do something different with the table or names..I'm lost at this point...my report will only show the contactID number and the first name on the reports...

 

[randy700]

Have you tried any of the suggestions I've all ready posted? If so, what problems did you encounter?


Randy

 

[lespaul]

according to this:

I have a table with contactID, LastName, MiddleName,
FirstName, and Membership Dues Paid (check box) on it

I would assume that you have a single table, but you keep mentioning the 'Lookup Box' with the names (agiain, do you mean you have a lookup field in the table? If so you need to check out The Evils of Lookup Fields in Tables. Do you have more than one table as noted above?

Do you really have two tables, one with Members and another with the Dues information?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[drblackard]

I went another route and figured something out...it's working now...Thanks