Never mind. I was missing the "E" on the very end of the last "DATE" Now it
works

Thanks

--
MNJoe


"MNJoe" wrote:

If I enter the line below. It prompts me to enter in the
"SYSADM_PURC_ORDER_LINE.DESIRED_RECV_DAT"

DueDate:
IIf(IsNull(SYSADM_PURC_ORDER_LINE.DESIRED_RECV_DAT ),SYSADM_PURCHASE_ORDER.DESIRED_RECV_DATE,SYSADM_P URC_ORDER_LINE.DESIRED_RECV_DAT)


If I bracket the field for the isnull statement I get an error "Invalid
bracketing of name "[SYSADM_PURC_ORDER_LINE.DESIRED_RECV_DAT]"

DueDate:
IIf(IsNull([SYSADM_PURC_ORDER_LINE.DESIRED_RECV_DAT]),SYSADM_PURCHASE_ORDER.DESIRED_RECV_DATE,SYSADM_P URC_ORDER_LINE.DESIRED_RECV_DAT)


If I try to bracket the first part [SYSADM_PURC_ORDER_LINE] then the second
part. It automatically drops the brackets and then prompts me to enter in the
value the same as the first example.

Thanks for your help

--
MNJoe


"Steve" wrote:

Put the following expression in the first blank field in your query:
DueDate:IIF(IsNull(LineDueDate),POHeaderDueDate,Li neDueDate)

Then where you have line due date in your report, change its control source
to DueDate.

Be sure to use YOUR field names in the expression in the query.

Steve



"MNJoe" wrote in message
...
I have a report with GroupHeader0 and GroupHeader1. The data source of the
report is a query. In the GroupHeader0 I have the Purchase Order Header
info
which includes the Purchase Order due date. In the GroupHeader1 I have the
Purchase Order line info which includes the line due date. What I need is
if
the line due date is Null or blank to default to the PO header due date.
How
can I assign the header due date to the line due date. Can I change the
control source of the text box in VB programming.

--
MNJoe


.