N
Nigel
I've got a table downloaded from a company's MRP system but I need to have a
3 letter code to identify the company which is the first 3 characters from
the company name field. I created a query and used the Left function to
create this. However, when I tried then to create another query based upon
the query to give me the 3 character code, and another query which gives me
comapny deatils, it will not allow me to add any more records, the add new
record button is greyed out.
Any help appreiated.
Thanks
3 letter code to identify the company which is the first 3 characters from
the company name field. I created a query and used the Left function to
create this. However, when I tried then to create another query based upon
the query to give me the 3 character code, and another query which gives me
comapny deatils, it will not allow me to add any more records, the add new
record button is greyed out.
Any help appreiated.
Thanks