Recent content by jquickuk

Hi everyone, I wonder if someone can help me. I have a database that imports product files from suppliers. It is a string of 96 characters and I want to be able to vaildate the length of certain fields. I import the file with no problems but I want to be able to vaildate the length of the...

Right well I'll be honest feel a bit of a tit now. Did the Group By and Sum query then linked it to the table and by using DISTNICT it work fine!! That will clear about half a million lines from the table!!!!

Afternoon all, I have a problem that I hope you guys can help with. I recieve a stock extract each morning and could contain mulitple lines of the same item but with different stock levels. What I need to be able to do using a either a query of using VB is to get one line per item but with...

Oh yeah forgot about that. i did change it but the file name is still not picking up the date that I enter into the query. I still get file name: Cancellations Cancellations#Cancel_date.csv

i forgot to metion when i do try it with above the file name comes out as Cancellations Cancellations#Cancel_date.csv

Afternoon all, my Database is nearlly all finished just one thing needs doing. I have a query that I run in VB, then it exports it into a CSV file to a folder on the C drive. When you run the code it goes to the query where it asks for the date and the CSV file is based on that. What I...

Just one thing i have noticed. This query used to call another query and i think that was to create the join. does that make sense? I'm trying to do it all in one. Is it possible to create to seprate queries in VB just like it would be in the query builder. This is the SQL from the SQL...

I took this sql from the query builder and most prob why it look naff. Thanks for this but still same error :(

Oh sorry No

Done! Not sure where I got them from. Haven't used them anywhere else.

Could you guys take a look at this query please. Doing ym head in now. posts say it is down to the brackets not being the wrong place but i'm sure i've tried every way possible!! I keep getting join expression not support. I also know that the whole syntax could be wrong but someone can help...

Evening all, I have a problem importing a file into access. I have a large .txt file which have fixed widths which looks like this 000004945ORDERTRACK 20081001080042 A51200180018190200001OK248601SA00120080930222807 A51200180018190200002RX991601SA00120080930222807...