Re: report returns Field ID instead of value

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Yep, Lookup Fields are bad for many reasons. Check on your report
that the item is a combo box and not a text box. If it's not, put the
field on again.

On Jul 4, 3:56 pm, Gerry H <Ger...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Thanks Steve, I see where you are talking about. But this is the situation I
have

tbl_Projects
Proj no
Proj Name
Client
Proj Descrip
etc

tbl_Client
Name
Address
Contact
etc

tbl client is already linked to tbl project via a combo box.

when I run the query normally, the datasheet returns the correct name so I
feel that the link is correct. it is only when i generate a report from it
that the report returns the ID value aghhhhhh

Gerry



"Steve" wrote:
You probably have something like this:

TblCustomer
CustomerID
Customername
etc

TblOrder
OrderID
OrderDate
CustomerID
etc

On your form where you enter orders you enter the customer with a combobox.
The combobox uses TblCustomer as the row source. The combobox has Bound
Column set to 1 and Column Width set to 0;2. The combobox displays the
customer name but when you make your selection, CustomerID is recorded in
TblOrder. CustomerID is a number. If you look at TblOrder, you will see all
numbers in the CustomerID field. If you create a query based only on
TblOrder for the recordsource of a report, and expect to see the customer
name in the CustomerID field, all you are going to see are numbers where you
expect to see customer names. The fix is simple. Include TblCustomer in your
query and join CustomerID to CustomerID. Include CustomerName from
TblCustomer in your query then include CustomerName in the fields for your
report. Now you will see the customer name where you expect to see the
customer name.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resou...@xxxxxxxxxxxxxxx

"Gerry H" <Ger...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:05DE4C5A-DE93-4B91-A906-6A2C1D77D8FF@xxxxxxxxxxxxxxxx
This has probably been answered before

I have a query that when i run, it returns exactly as i need if not
linked
to anything (input form or report). The query is a parameter query that is
linked to a form (the form is a series of combo boxes). i have also
constructed a report for it to populate.

the problem i have is that one of my fields returns the Field ID in the
report and dispite my endevours to trace the offending link, I fail to
find
it.

Any suggestions would be much appreciated. (I can post any SQL if needed)- Hide quoted text -

- Show quoted text -


.

Relevant Pages

  • Re: subquery results
    ... A report writer might be more useful here, since the ot value in each row ... where CustomerID < 'BL' ... > a way for my sub query to return the OT for only the first detail ... sunday) so calcing the OT and totaling the OT across the ...
    (microsoft.public.sqlserver.programming)
  • Re: How do I use a list box to open a report based on a single record
    ... make sure that the CustomerID is the bound column of the listbox. ... open the query in design view. ... with an OpenReport action that opens the report. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: drop down list within a query?
    ... I have done as suggested and i now get this message "The command or action ... When the code window opens the cursor will be flashing between 2 ... Let's assume it is a CustomerID number you need as criteria. ... Run the Report. ...
    (microsoft.public.access.queries)
  • Re: Exclude unique records
    ... You can use the Find Duplicates Query Wizard to build a query to find ... Source for your report. ... WHERE (((CustomerID) In (SELECT CustomerID FROM MyTable As Tmp GROUP BY ... orders from stores who have ordered from me multiple times on this report. ...
    (microsoft.public.access.queries)
  • RE: Create report with three rows of data representing years
    ... I would scratch your current monster query and build a union ... SELECT CustomerID, Jan05 as Sales, #1/1/2005# as SalesDate ... table with a union query and then create a crosstab based on your union query. ... I have a fairly complex report that I am trying to design. ...
    (microsoft.public.access.reports)