Search results

Thanks Plog, that is what I wound up doing. I created a linked table and each time I download the inventory information I save it over the old inventory sheet

Also, I am wanting the field to show 3 decimal places... No matter how much I play in design view and change the field type, or decimal # it always displays as .03 .04 etc instead of .033 or .041

Paul, Thanks for your reply, what is the easier way to show you the SQL? Do you want to see it for each table? Also, for the calculation how do I specify the amount field? Chris

Thanks for your reply, so just I am clear, there is no way to prepopulate a table?

Hello all, I have another newb question :cool: I have a sheet of inventory I am working on creating. The price for storage for an item is determined by 2 things. 1. the type of material and 2. the size of that material. I have created a table with the material types and sizes. Is there a...

That makes sense, how could I check and make sure it is multiplying by the value and not the ID?

Hey all, I am fairly new to access and still feeling my way around. I am currently working on a project and teaching myself access again after 10+ years of not working with it :) I have our primary web based inventory system that I am exporting to Excel and using this as an import to Access...

Hello All, Hoping someone can help with a problem I cannot figure out. I have a table with inventory items, a separate table with storage charges per day (ex .03, .04, .05 per day/per item) I have created some queries where I take the items & # of days they have been in storage and when I...

Thanks for your reply, after some playing around I got it to work. I started with the unmatched query as you suggested and then used those results for a delete query. Appreciate it!

Hello all, I am pretty new to Access and self taught and hoping you guys can help me out with a project I have taken on at work. I am creating a database of inventory, services performed, pricing etc. I have 2 tables. 1 table is being imported from our current system via Excel to update...