Recent content by LoveBard

Yes, I am realizing my errors in the tables - I watched a 4 hour series today on setting up Access/beginner intro, which helped me get a better grasp of the database 'rules'. I think I will start from scratch, rather than the template, since it might help me set up only what I need. Thank you...

Thanks, sorry, I was trying to keep the question specific. I have a furniture refinishing business. I need to track inventory purchases such as paint, decor items (jewelry boxes I refinish, as an example), furniture (before it is painted), hardware, transfer (images that are added to the...

The Assemble Asset form is the one I am working on. Ignore the popups, I have to remove them. They are part of the template.

I am not sure this is quite what I want. I want to open the form, enter the data and calculate the COGS, then save the form and have the calculated field enter into the table. I think running a query is a separate task - I do not know enough about setting it up, but each asset would need to...

I have a form to assemble assets. It calculates the cost of goods line items and then a total COGS combo box tallies the individual line item amounts. I want to update the Asset table's COGS and Consumables field with the calculated total COGS amount (when the form is saved). I have the...

Thank you, that worked :)

Sorry, but I don't really know how to write that. I tried: =[TCPI1]+[TCPI2]+[TCPI3]+[TCPI4]+[TCPI5]+[TCPI6]+[TCPI7]+[TCPI8]+[TCPI9]+[TCPI10]+[TCPI11]+[TCPI12]+[TCPI13]+[TCPI14]+[TCPI15]+[TCPI16]=Nz(0,0) And it only returns zero as the answer when all rows are filled in and does not help with...

Hi, to start, let me start by qualifying this query with the fact that I have very rudimentary Access skills (any other Microsoft application I am fine with). I am using a template from Microsoft in Access to create an asset/inventory database. I have an assemble asset form in which I have...