Search results

Does anybody know if it's possible to create "something" in Access to save files from local folder to FTP folder? Thanks in advance

Thanks to all

and by the way, why does the query ask me to enter myDate?

but it gives "Aug", I need "8"

Could you tell where I should use this statement? In a query?

Does anybody know how to take out a month from the current date?

Oh Yeahhh! Thanks Man. You are good! Really goood! That's exactly what I need. Thanks a lot!!!

I think I got it why it's not working in my case. As it's turned out, there are some styles without "-" like 92456.

it works when I type this SELECT Left([TableName].[Style],4) AS Style But unfortunately I have styles like LV7856 Shooot, please help!!

just tried to do that but... Invalid procedure call

I have a table with three fields. The first field with furniture styles. The second field with quantity and the third one with dollars value. It looks like that: Style Qty Dollars 1020-10 1 20 1020-20 1 30 1020-40 2 50...