Search results

Hello again, After many frustrating hours of messing around with the query(inc Group By), I gave up and had a think. I added in a new "Status" field to the transaction table with values Active or Inactive, when a transaction takes place, the serials previous transactions go to...

Thanks for the reply, I have been messing about with it for a while using design view, with no luck, not that I fully understand what I'm doing anyway, my knowledge is fairly limited. How do I modify the relation in that way? The join properties? Also unsure how to use group by properly, :p...

Hi there, Looking for some help regarding a query I am trying to create. I have a group of tables that manage and track hardware spares which contains the following; Information on each unique device, PK is Serial Number Information on each model type of hardware, PK is Part Number...

Hey there, Been using access on and off for the past few years, but with only basic understanding. starting work experience recently so I am trying to increase my knowledge as i find it very useful for what i do. I hope to learn from your tutorials and seek some advice. See you around the...