trying to count bats: log transit times and direction

[cmp20]

If you store a long date in there like what is output by the Now() function, I believe getting an exact value from a WHERE clause in a query is impossible. but again, just guessing.

hi thenet2,

I set the Events table input mask on Event Time to 00/00/0000 00:00:00 and repopulated the table but he query still does not work- does that mean your thinking is wrong on this?
however, I did get it to work by using same mask but changing the field type to "text" and the module also appears to work now as well
horray! Im only 1/2 as stupid as I was worried I was getting in my old age.

 

[cmp20]

Edit: I just re-read your post. I don't think you can use triggers and maybe not stored procedures either with SQL express. I have never used SQL Express so I am not sure.

Hi ChipperT,

I just checked and found this:
http://www.microsoft.com/sqlserver/2008/en/us/express.aspx

Microsoft SQL Server 2008 R2 Express is a free edition of SQL Server that is ideal for learning, developing ..... Supports stored procedures, triggers, functions, and views

 

[the_net_2.0]

hi thenet2,

I set the Events table input mask on Event Time to 00/00/0000 00:00:00 and repopulated the table but he query still does not work- does that mean your thinking is wrong on this?
however, I did get it to work by using same mask but changing the field type to "text" and the module also appears to work now as well
horray! Im only 1/2 as stupid as I was worried I was getting in my old age.

yippiiieee! 62 replies later and you've take a step forward. that's a lot faster than the government turn its wheels, if that makes you feel better!

if anything though, you've learned that you can't count on technology. do anything to make it work, and don't worry about why it didn't. as long as you know that, you're ready to graduate to the next program.

well....if you continue with the access side, I'd be glad to help. gl with it!

 

[ChrisO]

This could be the problem: -

cmp20 is running the system where dates are in dd/mm/yyyy format.

the net 2.0 is running the system where dates are in mm/dd/yyyy format.


change...
"WHERE [EventTime] = #" & udays(0, i) & "#" & _
to
"WHERE [EventTime] = #" & Format(udays(0, i), "mm\/dd\/yyyy") & "#" & _

Hope that helps.

Chris.

 

[cmp20]

This could be the problem: -

cmp20 is running the system where dates are in dd/mm/yyyy format.

the net 2.0 is running the system where dates are in mm/dd/yyyy format.


change...
"WHERE [EventTime] = #" & udays(0, i) & "#" & _
to
"WHERE [EventTime] = #" & Format(udays(0, i), "mm\/dd\/yyyy") & "#" & _

Hope that helps.

Chris.

thanks for that Chris, been caught out by this one before -now I remember...