Run time error 3075
Syntax error in date in query expression '#8.10.2008 13:48:04'
When I use msgbox do display my query string it looks like this:
INSERT INTO TimeExecution (Broj,Liga,Vrijeme) VALUES (1,'Albanian 1st league 1999/200',#8.10.2008 13:48:04#)
which looks like properly formed query string to me!
So, WHAT'S WRONG?
Why is it working on my old Access, why is runSQL command ignoring properly closed date string and keeps omitting closing #?
Has something changed in Access 2007 regarding using dates in queries?
I had a set of 170 000 records representing results of historic soccer matches, I simply wanted to calculate stats that describe each clubs performance before playing that particular match, for example after 7 games in English Premier League Aston Villa has 4 1 2 record and goal record 12:10!
I wanted to create queries that calculate that! IT'S ACHIEVED! I'm just not very happy with the amount of time it takes to calculate that! The original question is answered, so I had no particular point to make apart from philosophical mumbling about wheter the speed of the new computer is adequate!
[QUOTE=gvee;6361486]There's nothing wrong with striving for improvements
But hey, if you're happy...
Can anyone help me to filter my crystal report using one textbox for the MEM_CODES field and two datetimepicker for my SDATE field.
I need to filter the report by entering member's codes and date from , date to using datetime picker.
My current codes are :
Dim fechadel As String = Format(DateTimePicker1.Value, "M/dd/yyyy H:mm:ss")
Dim fechal As String = Format(DateTimePicker2.Value, "M/dd/yyyy H:mm:ss")
report("SELECT * FROM DTR_REC WHERE SDATE >='#" & fechadel & "#'AND SDATE <= '#" & fechal & "#' ", "CrystalReport1")
i've encounter this error: " Data type mismatch in criteria expression."
SDATE is datetime datatype
I hope you can help me guys with my errors... Thanks