ddskorupski
Registered User.
- Local time
- Yesterday, 17:52
- Joined
- Apr 29, 2009
- Messages
- 44
Hello. Can you help me figure out how to get this append query to show data that is null?
I have three tables: tblbasetable, tbltransformationtable and tblhistory.
The query looks at tblbasetable joined to the tbltransformationtable. It appends to the tblhistory table.
The criteria is under the field "UAT Start Date Change" from the tbltransformation table and is comparing the dates to the tblbasetable field Baseline UAT Start Date field. I am asking the query to look at the dates and record any changes to the dates and then append it to the history table. Here is the criteria:
<>[tblBaseTable].[Baseline UAT Start Date]
This is working great except it is not looking at dates that are null. For example, if the [tblBaseTable].[Baseline UAT Start Date] is empty, I want the criteria to look at that empty field and add the new date in the tbltransformation table it to the history table showing the Baseline UAT Start Date as empty and the UAT Start Date Change with the new date . But so far it is only looking at dates that don't match.
I figure I need an iif statement or something to add the null criteria but cannot figure it out.
Can anyone help?
I have three tables: tblbasetable, tbltransformationtable and tblhistory.
The query looks at tblbasetable joined to the tbltransformationtable. It appends to the tblhistory table.
The criteria is under the field "UAT Start Date Change" from the tbltransformation table and is comparing the dates to the tblbasetable field Baseline UAT Start Date field. I am asking the query to look at the dates and record any changes to the dates and then append it to the history table. Here is the criteria:
<>[tblBaseTable].[Baseline UAT Start Date]
This is working great except it is not looking at dates that are null. For example, if the [tblBaseTable].[Baseline UAT Start Date] is empty, I want the criteria to look at that empty field and add the new date in the tbltransformation table it to the history table showing the Baseline UAT Start Date as empty and the UAT Start Date Change with the new date . But so far it is only looking at dates that don't match.
I figure I need an iif statement or something to add the null criteria but cannot figure it out.
Can anyone help?