Recent content by LSTC018

Hi Minty, Thank you for your help, but its looking beyond my capability and complicated working with an established database and tables. My knowledge in Excel is a little better so I'll have a go with that - thanks again

Hi Minty Just read your reply and your comment ' you know it's been inspected from the fact it has an inspection date?' I'm looking for the possibility a single report can be produced showing all the inspectors names and the outstanding number of units to be inspected for each circuit...

Hi, Thank you for your reply - we are talking 2 x tables. This set up has been in place for the past 6 - 7 yr. I can't change this. Combining wouldn’t be a problem but the two separate tables would have to stay, Cheers

Hi, Hopefully I can explain my task that I have taken on:- I have two Data bases A & B A – gives details of work issued for inspection B – records the returned results of the work issued The main column heading are :- DataBase – A (issued Details of work to be...

Hi Gasman, Good feeling when it works - Thanks again for your support and advice. I'm sure I'll be back, Cheers

Hi, Completed my Form - and used a query using UNION ALL and got the 3 table results in to one Table, I have copied the SQL from the form that works fine, and it is looking at a Table it’s now looking at a Query table (not sure if that's the correct terminology) and it doesn't work. I’ve...

ok - I'll have a go with that - I may be asking for help !!!

Hi, More than happy to go with whatever is the best way - I'm very new to all this, I'm doing it off my own back, making reporting easier at work (making me look good). I want one table to interrogate. With help from yourselves I now have a form that I can search by dates (between two...

Hi, The tables have been set up for 6/7 years each relating to specific returned inspection details – the three columns I require ‘Date’ (Date of inspection) – ‘InsType’ (Inspection Type) – Inspector (Inspectors name) If I can Append them and have the new table updated everytime new...

Hi, I have three tables I would like to combine into one new table, the new table will be updated when any of the separate three are changed, the columns I want from each of the tables have the same column headings. Can you help? Cheers

Sorted thanks Gasman. Also, much appreciated input and help from everyone, Cheers

Hi, This takes me through the criteria but shows no results (Sorry). When I debug it shows :- : strCriteria : "([Order Date] >Date() #01/09/2019# And "([Order Date] <=Date()+7#" : Variant/String : task : "Select * from Table1 where (([Order Date] >Date() #01/09/2019# And "([Order Date]...

Hi, Ive managed to get this query shown below to work (lots of help from people on this site) it gives me results of record between two dates from a 'Search Button'. I'm now trying to use the same query set up, to get records for 7 days from the date I input into OrderDateFrom on the Form...

Bingo - Thats done the job I've been working on that for two days - Cheers

Hi, Unfortunately all the tables I’m looking at to get reports from are already set up with DD/MM/YYYY and can't be changed, Cheers