Need parameter assistance AGAIN!

[vbaInet]

There's another way of handling Null on a single line.

So those two fields were created to handle the null cases AND to pull in the matching records? Or in addition the OP also wanted separate clock in and clock out fields?

Sorry, just trying to understand what's going on.

 

[vbaInet]

So if you removed the DateValue function, then what did you do to turn it to a DATE ONLY field so that you could not use the time elements?

If you give a Date/Time field a date range it will ignore the time element. But I'm still in the process of understanding what's going on

 

[boblarson]

There's another way of handling Null on a single line.

So those two fields were created to handle the null cases AND to pull in the matching records? Or in addition the OP also wanted separate clock in and clock out fields?

Sorry, just trying to understand what's going on.

Those two fields were initially created so we could pass input from parameter prompts which were DATE ONLY (no time element) as the regular fields were stored with time. So, the other way would have been to concatenate on a 12:00:00 AM and an 11:59:59 PM to the parameter prompt values to handle the time element. I went with the datevalue way. But nulls complicated things because it would return #ERROR if there was a null.

 

[boblarson]

If you give a Date/Time field a date range it will ignore the time element.

Umm, no that is NOT completely correct. If you pass a date range it will assume this the starting date is mm/dd/yyyy 12:00:00 AM but the END date is also mm/dd/yyyy 12:00:00 AM so you would have to add an extra day in order for it to pull correctly on that last day.

 

[vbaInet]

Umm, no that is NOT completely correct. If you pass a date range it will assume this the starting date is mm/dd/yyyy 12:00:00 AM but the END date is also mm/dd/yyyy 12:00:00 AM so you would have to add an extra day in order for it to pull correctly on that last day.

Ah, yes. I forgot about that complexity.

 

[vbaInet]

Hey Bob, so is the OP not worried if either one (or none) of the parameters was not filled in?

 

[boblarson]

Hey Bob, so is the OP not worried if either one (or none) of the parameters was not filled in?

Nope, apparently the people are supposed to click it if they come to work EARLY or stay LATE. The requirement isn't to click it regardless.

 

[vbaInet]

Nope, apparently the people are supposed to click it if they come to work EARLY or stay LATE. The requirement isn't to click it regardless.

They could do it just for the fun of it. I know I would

 

[fhs]

Actually, the condition is this: these employees have chosen to work a four-day work week of ten hours per day. Therefore the requirement is for each of them to show that they came in early or stayed late. Thanks again for all your assistance.