lovas
07-02-2003, 07:51 AM
I am pulling data from a database. I am pulling data from three tables; a header (A), an item table (B) and outer join table (C) that is pulling information also. I have developed a Sub onRead file and it works except for this part. Sub onRead means, this file gets read every time there is a search query performed.
Question:
Example
I need the data from the shipped date column in table (B) to be compared with the shipped date column in table (C). If there is a date in the shipped date column of table (C), then I need the data in that column to show in the report, instead of showing the shipped date coming from the column in table (B).
Different Terms:
If table.column (C) is not null then
table.column (B) needs to set the data from (C) to it.
And display that data from (C) in the results.
Does anyone know the correct if / then statement?
This is the one i have tried.
If table.column (C) <> null then
table.column (B) = table.column (C)???
Question:
Example
I need the data from the shipped date column in table (B) to be compared with the shipped date column in table (C). If there is a date in the shipped date column of table (C), then I need the data in that column to show in the report, instead of showing the shipped date coming from the column in table (B).
Different Terms:
If table.column (C) is not null then
table.column (B) needs to set the data from (C) to it.
And display that data from (C) in the results.
Does anyone know the correct if / then statement?
This is the one i have tried.
If table.column (C) <> null then
table.column (B) = table.column (C)???