Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Retrieving wrong values from the db

Status
Not open for further replies.

lizw

Programmer
Oct 30, 2000
1
US
I have a report that is referencing an access database. The top of the report has some customer information (name, address, etc). I have two fields,

Customer_Report.Address_Line_3_s
Customer_Report.Address_Line_4_s

that are included in the address information. I have confirmed that there is data in these fields but when I run the report these fields are blank on the report. I went back and filled in every field in the database to see where that information would show up on the report. When I run the report again I get address information in the 2 spots that are referenced above but it's coming from these two database fields:
Address_Line_1_s
Address_Line_2_s

The fields on the report say Address_Line_3_s and Address_Line_4_s so I don't understand how it's
getting data from two other db fields. If anyone has seen this before or know what it could be I would appreciate any suggestions.

Thanks,
Liz


 
Did you try to click on the "Set Location" option? Maybe it's not looking at those fields even though it says that its pointing to the address_line_3_s and address_line_4_s. Hope this helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top