?
Solved

Microsoft Access - Report - adding more information to one field

Posted on 2014-07-10
1
Medium Priority
?
371 Views
Last Modified: 2014-07-16
I have a report that was auto-generated with Access. One of my fields contains a timekeeper ID. However, the table that holds that info also has a first name and a last name field as well. When looking at the Row Source for this combo box in the report, I have the following query


 Select ELITETimekeeper.ID, ELITETimekeeper.TimeKeeper, ELITETimeKeeper,Lastname, ELITETimeKeeper.Firstname
From ELITETimeKeeper.

The Report shows the ELITETimekeeper.TimeKeeper field, which is just a time keeper number.

I'd love for it to show the last name and first name as well, but I cannot figure out how to do it in the Report. I have it working in the Form, by modifying the Column Count and column width properties, but this does not seem to be working with the Report.

Can anyone help?
0
Comment
Question by:anglandp
1 Comment
 
LVL 31

Accepted Solution

by:
hnasr earned 2000 total points
ID: 40189572
In a report, just use text boxes to display the required fields for the record.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question