Recent content by BigBuedro

Good morning guys, I'm not deliberately ignoring anyone's advice and I don't WANT to store the data more than once (certainly if it's going to be a problem), it's just that i'm clearly not understanding what i'm supposed to be doing. I've clearly misunderstood where i'm supposed to put the...

Just figured out how to attach a screenshot of my query (I think)

Thanks David, I now have a query as such: Field:___InputPart_______ModuleIDNo______Location Table:__TestRecords_____TestRecords_____TestRecords Sort: Show: Criteria: Left("SerielNo",2) Mid("SerielNo",3,9) Right("SerielNo",1) I'm gonna sound thick (but hey i can't help it), how do i now...

DCrake - thanks for your help, however (at the risk of sounding really thick) i don't know where to enter the info you've given me :confused: (my knowledge really is that limited)! John Big Booty - the seriel number is made up of a 2 letter PART NUMBER, a 9 character Unique Identifying Number...

Apologies if this is one that gets asked ALL of the time (i can't find an answer if it is). I'm using Access 2010 but my knowledge is VERY limited. I have a form based on a table, with a field where I have to input a 12 character long alphanumeric seriel number (via a bar code scan) It is...

Hello, I've been given the task of creating what my boss refers to as a 'simple' database but desperately need help. We manufacture products that require testing with keys during the assembly process and the number of different keys is in the hundreds. They are stored in various places...

Hello everyone, 1st time poster! I've not been using Crystal reports long and subsequently don't know much and need help. The company i work for uses Crystal Reports 7 as the report generator/writer. We generate a works order/schedule that is sent out onto the shop floor to specify what...