Recent content by Andy Ralph-Kineteco

  1. A

    Text criteria in Query

    Perfect! It was the percentage sign % rather than the asterisk * that I needed to use! I did not understand the significance of ANSI92 - I'd better go look it up now! :)
  2. A

    Text criteria in Query

    Hi all, Having a senior moment I presume... I am using Access 2013 under Windows 7. I have a table (tblStock) with a field called "Description". Some 25% of the records hold the following data - "DNU - ....." (meaning "Do Not Use - ....) the others hold data such as "Spring" or "Plunger". In...
  3. A

    Variables as field names in recordset

    Sorry but I think you are going a little too far. That is exactly what I am trying to do! Take the data from this pile of .... and create a useful normalised table. The data is generated and constantly updated by an external system that I have no control over. As to why do I persist in using...
  4. A

    Variables as field names in recordset

    Sorted this! Need to use the Fields Collection rather than the field names. This way I can define the value of the fields as rcdStock.Fields(intEye).Value (!)
  5. A

    Variables as field names in recordset

    Unfortunately, I have no control over the tblStock table. What I am trying to do is take the data from a single flat record in tblStock and create a new table (tblTempBOM) with individual single records for each component. Any thoughts?
  6. A

    Variables as field names in recordset

    Sorry but I have tried to find answers for this but I guess I don't recognise the terminology. Very much a Newbie! I am using Access 2013 under Windows 7. In my database I have a table, tblStock, with field names Module, Component_1, Component_2, etc. up to Component_50. I also have fields...
See more
Top Bottom