Search results for query: *

Hi, I have the following 2 tables; Table1: Products (ID, Customer, ProductName, Price) Table2: Orders (ID, Customers, ProductName, Price, Quantity) I want to create a query that selects all the records from the Products table and also any matching records from the Orders table for a given...

Worked a treat! Thank you very much I had spent hours tring to work that one out on my own!

Hi, my appologies for not replying but called away on work. Thank you for both the answers given. I am having a small problem with the getrows method in that it does not seem to pick up the first line in the txt file! The seconds method using the split function does recognise the first line but...

Hi, can somebody point me in the right direction - I have a csv files of the following format; "HDR","1","1","STORE NAME" "LNE","1","M6-T" "LNE","2","L6-T" "HDR","2","1","STORE NAME" "LNE","1","M6-T" "EOF" The HDR field represent a header, whilst the LNE fields represents lines/records. EOF...

Thanks - I will give it a go!

I have a small network consisting of three computers - one running Win XP Pro and two XP Home editions. I need to be able to access an asp/html application that I created from all three computers, which I currently do by accessing it through the Internet. Rather than accessing it over the...

Thank you - the solution by anotherhiggins worked a treat!!!

I have two worksheets in the same workbook. In worksheet one I have a number of records that populate about 9 rows each with each record representing one week. I have copied and pasted the original record (9 rows) to display a whole year. In worksheet two I want to be able to reference the last...

Sorry for the delay in my getting back to you, but thank you for your response. I think you are right suggesting that I use a MS Query. The application will only need to hold around 600 non relational records - would I be best storing these in access or an excel worksheet? My next problem is...

Could somebody help point me in the right direction for the following; I am creating an excel application (using vba if necessary) whereby I have a table of data with a date field, customer_name and quantity field on worksheet1. On a seperate worksheet (worksheet2) I have created a userform...