Data into Report Textbox

[Emon]

I'm trying to put a single value from a table into a text box of a report.

This table has only one record with several fields. (There are many other tables in the db)

I've tried the following query but aint getin anywhere.


SELECT User.Date FROM User WHERE (((User.Date)<>" "));

[JHausmann]

Try checking for null:

select date from user where date is not null