Recent content by mudstone

Thanks John I have managed to get the query working OK from data stored in the "Grade Control" table. The fields concatenate in the correct format, to produce the BlockID field, and filtered. However, I have just discovered that I cannot use this field in the query as a primary key field (one...

I have just made the transition from Excel to Access. I have created the tables for my database. The database includes two tables: 1. Mining 2. Grade Control I have created a query to generate a calculated field called BlockID. This field is populated with the concatenation of three fields...