General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>>
>>>>>lol forgive my lazy internet lingo i meant to work. you're using the year 2000 i really didnt wanna hard code a year
>>>>
>>>>Alternative solution would be
>>>>
>>>>year(date) = thisform.Spinner1.value
>>>>
>>>>this solution is worse if you have an index on date field. Otherwise it doesn't matter and shorter to use.
>>>
>>>
>>>would i hav to write it like (1,1,year) if im using the british date in my tableS?
>>
>>date function accepts year, month, day parameters. Check Help.
>
>yea i kno...but im wondering why its selecting nothing not even if i hard code a year
oh i figure it out...i had to change the months for the end date
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only