Search results

I'm trying to use the date picker on my form but it won't appear in form view. I understand that the attribute exists at both table and form level and I've tried all combinations: removing the attribute from the table, from the form and keeping them both present. Oddly, I've written another...

I have a query that takes 2 junction tables and uses a calculated field to come up with an on-hand count. Unfortunately, I'm getting multiple values for each product code when I simply want one count listed for each product ID. Here is what I'm using for my calculated field: On Hand: [tbl...

Hello all, I am a new Access user and I have a form that uses a junction table within the form as a subform or perhaps a subtable. In this subtable, I would like to autofill one field (description) based on the value chosen from another field (part number). The part number field is a drop-down...