Add Extra Field to SQL Syntax

[burrina]

I need to add HolDte and make it also use HolidayDate as it's criteria.

strSQL = "INSERT INTO tblHour (WorkDate,Hours,HolDay,EmployeeID) " _
          & " VALUES  (#" & Me.HolidayDate & "#," & Me.txtHrs & ",True," & Me.EmployeeID & ")"

 

[JHB]

You insert one new record, (so what should the criteria be)!

 

[burrina]

To Make HolDte (a Date) match HolidayDate since that is a field in which I have a Composite Key.

 

[JHB]

Sorry what, (can you show some sample data + how you want it)?

 

[burrina]

Here is a Screenshot. HolDte should equal HolidayDate

 

[JHB]

Hmm - would the below not do that?

[COLOR=#000000][COLOR=#0000BB]strSQL [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#DD0000]"INSERT INTO tblHour (WorkDate,Hours,HolDay,EmployeeID, [/COLOR][/COLOR][COLOR=#000000][COLOR=#DD0000]HolDte) " [/COLOR][COLOR=#0000BB]_ 
          [/COLOR][COLOR=#007700]& [/COLOR][COLOR=#DD0000]" VALUES  (#" [/COLOR][COLOR=#007700]& [/COLOR][COLOR=#0000BB]Me[/COLOR][COLOR=#007700].[/COLOR][COLOR=#0000BB]HolidayDate [/COLOR][COLOR=#007700]& [/COLOR][COLOR=#DD0000]"#," [/COLOR][COLOR=#007700]& [/COLOR][COLOR=#0000BB]Me[/COLOR][COLOR=#007700].[/COLOR][COLOR=#0000BB]txtHrs [/COLOR][COLOR=#007700]& [/COLOR][COLOR=#DD0000]",True," [/COLOR][COLOR=#007700]& [/COLOR][COLOR=#0000BB]Me[/COLOR][COLOR=#007700].[/COLOR][COLOR=#0000BB]EmployeeID [/COLOR][COLOR=#007700]& [/COLOR][COLOR=#DD0000]", [/COLOR][/COLOR][COLOR=#000000][COLOR=#DD0000][COLOR=#000000][COLOR=#DD0000]#" [/COLOR][COLOR=#007700]& [/COLOR][COLOR=#0000BB]Me[/COLOR][COLOR=#007700].[/COLOR][COLOR=#0000BB]HolidayDate [/COLOR][COLOR=#007700]& [/COLOR][COLOR=#DD0000]"#[/COLOR][/COLOR])"[/COLOR][/COLOR]

 

[burrina]

Yes, Thanks Again. I'm learning. I appreciate the help.
Just what I needed.

 

[JHB]

You're welcome, (it was so straightforward so I thought it couldn't be what you were after).