Printable View
i know that this question probably doesnt apply to this forum but im hopiing someone might be able to help me anyway! my question is:
i am creating a report in access and im trying to show a value in a textbox by using the expression builder. the value that i want to show in the textbox is a value that is in a table with only one row and one column! can anyone please help me out here?
Do you need other information from another table ?
If not then use the properties>Data Source for the report. Select the table you need (the one with only one record) then close it (say yes to save it). Then drop in a text box, select it, Properties>Data Source change the drop down to the fiel you want to display.
If you are pulling other info and connot link the table in any way, drop it in and see if you can make a valid Sql statement to retrieve the results, then do as above.
Lastly if all else fails, then you'll need to code into the report format section to pull the data from the table and place it in a textbox on the report.
Vince
thanks man for solving my problem Ecniv