Recent content by ps2328h

Hi, Thank you for the promp response and suggestion. I'm not sure i understand what you mean by splitting the clinet and address? As client would always have to have a address and the site could be client address or another address? Much appreaciate your help and guidance on how to set the...

Hi There, I have been asked to design and develope a nww access database to enter all the nw projects the company receives so we can report on it and tract the costs and fees. The information they require is client information with their address details and site details and also the county the...

Thanks I'll give a go... The Id's come from another system, I get a csv file and then have to import and sort the data.

Hi Yes, I have on my first table one field called ID with data such as 123456Aberdeen 345765Manchester 765987Aberdeen Now i want a list so it only shows me Aberdeen or Manchester on a separate column and then i can link that to another table which has 3 fields ID, Branch 123456, Aberdeen...

Hi There, I am new to this site and Access as well. I have two tables i need to link and and get the data. Can anyone help me on how to set the query so it shows me results after the first 6 numbers? Thanks in advance