If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report Field Problem
I can't get the Price field to fill in the information for the price of the
Item number.I created a query using the Defectivie Supply Table which has item number fro a filed. I also used the Item NUmber table,linked the 2 tables and added Price to the query. The query runs fine,I get the price for each item number,but when I run the report I get nothing for the Price. What I am I doing wrong? The Item number field in the Dective Supplies table does no reference the Item number Table as a Lookup. This is the way the table was setup. |
#2
|
|||
|
|||
Have you linked the text field in the report to the field in the query?
Check the control source of the field in the report, to see if it linked to any field. -- I hope that helped Good luck "CyndyG" wrote: I can't get the Price field to fill in the information for the price of the Item number.I created a query using the Defectivie Supply Table which has item number fro a filed. I also used the Item NUmber table,linked the 2 tables and added Price to the query. The query runs fine,I get the price for each item number,but when I run the report I get nothing for the Price. What I am I doing wrong? The Item number field in the Dective Supplies table does no reference the Item number Table as a Lookup. This is the way the table was setup. |
#3
|
|||
|
|||
Thanks for responding Ofer.
Are you saying that the field on the report should be a bound field. The Item Number field is coming from the Defective Supply table,the Price field is coming from the Item Number table. The query is using the Price field which is the control source on the report. "Ofer" wrote: Have you linked the text field in the report to the field in the query? Check the control source of the field in the report, to see if it linked to any field. -- I hope that helped Good luck "CyndyG" wrote: I can't get the Price field to fill in the information for the price of the Item number.I created a query using the Defectivie Supply Table which has item number fro a filed. I also used the Item NUmber table,linked the 2 tables and added Price to the query. The query runs fine,I get the price for each item number,but when I run the report I get nothing for the Price. What I am I doing wrong? The Item number field in the Dective Supplies table does no reference the Item number Table as a Lookup. This is the way the table was setup. |
#4
|
|||
|
|||
Open the report in design view, and select in the control source of the price
field, the price field name from the query that the report is bound to. -- I hope that helped Good luck "CyndyG" wrote: Thanks for responding Ofer. Are you saying that the field on the report should be a bound field. The Item Number field is coming from the Defective Supply table,the Price field is coming from the Item Number table. The query is using the Price field which is the control source on the report. "Ofer" wrote: Have you linked the text field in the report to the field in the query? Check the control source of the field in the report, to see if it linked to any field. -- I hope that helped Good luck "CyndyG" wrote: I can't get the Price field to fill in the information for the price of the Item number.I created a query using the Defectivie Supply Table which has item number fro a filed. I also used the Item NUmber table,linked the 2 tables and added Price to the query. The query runs fine,I get the price for each item number,but when I run the report I get nothing for the Price. What I am I doing wrong? The Item number field in the Dective Supplies table does no reference the Item number Table as a Lookup. This is the way the table was setup. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Report blank field problem | rsfreiheit | Setting Up & Running Reports | 16 | September 27th, 2005 04:25 AM |
No current record 3021 | hughess7 | General Discussion | 30 | August 19th, 2005 04:39 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |