Syntax for code

[spacepro]

Hi All,

I'm very tired and this is probably stating the obvious but I want to assign a value if the time is between 6am and 2pm. What is the syntax in VBA?

if time = >#06:00# or <#14:00# Then
'assign value here
end if

Not quite there. Anyone help, gone a bit rusty.

Thanks

Andy

 

[namliam]

How about:

if time = >#06:00# and Time <#14:00# Then
'assign value here
end if

Greetz

 

[Mile-O]

Is there a date as part of this field?

 

[namliam]

I assumed he was using the Access function Time....

 

[Mile-O]

You both have your mathematical operators wrong:

Greater than or equal to is >= and not =>

if time >= #06:00:00# and Time < #14:00:00# Then
    'assign value here
end if

 

[spacepro]

Thanks namliam,

I knew it was something like that

Yes I am using the time function.


The artist formerly known as Mile-O,
I know it was 1am when I wrote the post.

Thanks

Andy

 

[namliam]

You both have your mathematical operators wrong:

Greater than or equal to is >= and not =>

I just took his example, didnt look at much else...