Search results for query: *

thanks very much! excellent!

thanks guys, to be honest i was trying not to code this and use just one query - i am not sure if it is possible. the structure of the table is as follows: FIELD ONE FIELD TWO ALL OTHER DATA (SYSTEM NO) (LIFE CYCLE) 445566 10345678 445566 10345679 ** 436574...

Good Morning, I have a table of data where the same system number may occur more than once. I would like to select only the rows which have the highest life-cycle reference for each system number. Is this possible?

Hi, I am gong to import an excel spreadsheet on a daily basis as per the instructions in thread181-946762. My problem is that the name of the spreadsheet changes on a daily basis - to include todays date - so the file is called c:xxxxddmmyy.csv. Is there any way to adapt the code to account...

Good Afternoon everyone, I have a database that uses files provided by my clients as the source data - they are either .txt, .csv or .xls. I need to be able to show the date the file was produced next to the data within my database - is there an easy way to extract this information? thanks...

thanks to all for the help here - i really appreciate it

appreciate it Carl - I will be looking to run the append query each day - i will have a play with the code and look forward to your post tommorrow! thanks again.

of course, basically i have 6 tables that i want to pull two fields from and append all the data into one large table. I want to identify which underlying table each line of data came from - so i would like to put the original table name as a field in the new table - I hope this is clearer, thanks!

Hi all, is it possible to insert text cut from a table name into a field in a query - to identify the source of the data in it?

hi - thanks for any help you can give!

Hi all, is there any way to remove all menubars from the top of an access database - i want to get rid of the bar that starts FILE EDIT etc etc. but don't seem to be able to - thanks in advance