How to Create Filter by date Query for access using Data base connectivity tool

[salimo]

Hello,

I had started my project by reading Access datas, by using an UDL connection,

but now i want to create an access filter using a query that would permit to select two dates, and to obtain all corresponding datas, how to do it using the Parmetrized SQL query?

Best regards,

Remark: i dont know the SQL language

[MikeS81]

Hi salim_mjs,

see the attached picture.

You should also see this or a similar link:

http://www.sqlcommands.net/

Mike

[salimo]

Hi mike,

I want to thank you for your help, i really appreciate it,

i tried to make the code as ur picture, i had no problem to execute it, but i have no data's in the output

i changed the date format, because i suppose that its a short date format in the database.

can you just look at it, and tell me if you can find the problem,

thank you again for your help

Best regards,

[MikeS81 · Accepted solution]

Hi salim_mjs,

you have to use the date format i used. It's independent from the format in your database. It has to be "month/day/year".

Mike

[salimo]

Thank you very much MIKE

you are my hero, my problem have been solved

🙂

[salimo]

hello again,

i have a little problem,

my program is working perfectly when im running it, but when im creating the EXE, when i try it and saving the file to EXCEL i have this error

Get LV Class

Default value.vi<APPEND>

<b>Chaine d'appel complete: </b>

Get LV Class

Default Value.vi

NI_report.lvclass:New Report.vi

Main.vi

can you help me solving this problem?

thank you in advance

[MikeS81]

Hi Salim,

see this link. It should help.

http://digital.ni.com/public.nsf/allkb/2AE85CF95217E60786257540000D818C

Mike