Search results

Brian could you help me step by step if you have time! To start with i have a customer table on the database The CUSTOMER table contains >customer ID >name >address >postcode So if i create a new table first for example called: table name: REGION 1 POSTCODES - as the field name (and paste...

I have a database with 3000 + records all with customers from all over the UK. The CUSTOMER table contains >customer ID >name >address >postcode I have been asked to produce reports from the database. These reports should group all customers into postcodes regions and then display...

Can anyone else help me?

Hi i really need help! i need to be able to use "lookup", i have a set of postcodes from 3000 customers, i need to extract these and compare them to lists i have of postcodes, which make up a region. And run queries from these e.g a customer on my database has the postcode BD21 7KK On my...

Neileg do you have msn messenger? is it possible i could chat 2 u on msn later this evening about this postcode dilema im very stuck at the moment and my job depend on it. would appriciate it if possible.

Ok i have the lists of postcodes at hand per region, these will not change. They are about 80 per region. Are there any simpler methods? All i need to do is pull out the postcodes...categorise them and make a simple report. Its just the categorising im having trouble with, not sure on the best...

So could "lookup" solve this? How would i do this?

I have a database with 3000 + records all with customers from all over the UK. The CUSTOMER table contains >customer ID >name >address >postcode I have been asked to produce reports from the database. These reports should group all customers into postcodes regions and then display...

Hi i did what u said but it wont match them? it seems to conflict? :( any idea of what to do? Thanks

thanks James i shall try this

Hi I was wondering if any one could help me. I have a database at work with 5500 records, how ever the first 1000 have been lost. There remains records for each customer but the first 1000 records showing what they ordered have disapeared. I have back ups of the database going back with the...

Yes Col im physically puting the postcodes in the query e.g criteria: Like "hu1 *" Or Like "hu2 *" Or Like "hu3*" Or Like "ls1" etc

Thank you ever so much mate, its worked! p.s if i used the code u suggsted where would i place it?

hu1*" Or Like "hu2*" Or Like "hu3*" It has returned the correct information but i have a problem because not all is wanted. For example hu1* i wanted a list of postcodes e.g HU1 4th HU1 8IK this is the type of information i...

I do apologise for the title! Im no good with code and wouldnt no where to place it? Could you provide me with an example which i could paste in? Ive placed this in the criteria section: Like "hu1*" Or Like "hu2*" Or Like "hu3*" This has grouped all the postcodes beginning with hu1, hu2...

as in criteria: (hu1*) (hu2*) It doesnt work Col, could you provide me an example

Hi If i wanted to run a query from customer records in my database and wanted a list of specific postcodes that matched the criteria how would i do this? For example each customer records has a postcode BD4 4KL, LS9 7YH ETC I want to categorise each postcode set to see for example all the...

thank you very much!

thanks for the advice

Hi I would like some advice or opinions from people who have worked with access and mysql. Currently we run a large database in access which holds around 3500 records. It is actually running quite slow at the moment. What would you suggest to speed it up? ive heard running it on a sql server...