phowarso wrote:
But I get for 18/3/08, error format
phowarso wrote:
Date Field Format in the table is 'Short Date'. ( month, day, year) Date format from ComboBox is ( day, month, year).
Well, that's obviously the issue then.
phowarso wrote:
DisplayReport("SELECT * FROM tblSave WHERE Date=" & dt & " ORDER BY Name ASC")
Don't do this. Parameterise your query, then this sort of thing will take care of itself.
Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )