Design by Sue
Registered User.
- Local time
- Today, 15:31
- Joined
- Jul 16, 2010
- Messages
- 816
I am creating an append query based on a form. I have results in 3 of the fields but for DateCompleted and Completion Time the fields are blank when I view the query. I am totally stumped as to why this is happening. Has anyone had this experience and can you point me to what might be causing it. I have double and triple checked the names of the controls (I know there may be some there that will go against the grain for naming but that is what I have been given to work with and don't want to change them and cause other problems) Date completed is bound and Completion Time is unbound. Here is the SQL.
INSERT INTO [SOP Time Table] ( [SOP Number], SOPVersion, DateCompleted, [Employee Number], CompletionTime )
SELECT [Forms]![Add by SOP FRM]![ComboSOPNo] AS SOPNumber, [Forms]![Add by SOP FRM]![Text85] AS Version, [Forms]![Add by SOP FRM]![DateCombo] AS DateCompleted, [Forms]![Add by SOP FRM]![ComboEmpName] AS EmpNumber, [Forms]![Add by SOP FRM]![Completion Time] AS completionTime
FROM [SOP Time Table];
I know this is so easy for many of you but this is not easy for me and I have to get this completed so if I made a mistake in my wording please forgive me and if this seems like a stupid question, again forgive me. I am doing the best I can to ask the question. Thanks.
INSERT INTO [SOP Time Table] ( [SOP Number], SOPVersion, DateCompleted, [Employee Number], CompletionTime )
SELECT [Forms]![Add by SOP FRM]![ComboSOPNo] AS SOPNumber, [Forms]![Add by SOP FRM]![Text85] AS Version, [Forms]![Add by SOP FRM]![DateCombo] AS DateCompleted, [Forms]![Add by SOP FRM]![ComboEmpName] AS EmpNumber, [Forms]![Add by SOP FRM]![Completion Time] AS completionTime
FROM [SOP Time Table];
I know this is so easy for many of you but this is not easy for me and I have to get this completed so if I made a mistake in my wording please forgive me and if this seems like a stupid question, again forgive me. I am doing the best I can to ask the question. Thanks.