Search results

Good morning, Rain! In reference to your cost question, each item's cost should likely be a stored value and then I would use the query from CJ to calculate the transaction cost (one supervisor can request several items on a single date) to create a quarterly report. While there are...

Good morning, Rain. Can you help me understand a few things regarding your template? *How does one create a new stock take? I understand, from reading the link, that these are done by date, and your sample has "demo" dates put in to show example stock takes - what I dont see is how to get a new...

Rain, I didnt mean to offend or anything, I do appreciate the sample database, and of course I know it wasn't built for me. I had successfully imported basic product info (description and my item id), but that messed up the stock on hand field for everything. I dont mean to be a pain, you're...

Morning, Rain! I will correct the naming conventions today - it was a holiday here in the states so I was off work. :) The purpose of the database is simply to track supplies - to see stock levels and to see what each department is ordering at the end of a quarter. It is pretty basic. I want a...

Sure, Rain! Here's what I've got.

Ah that makes SO much more sense - I tried deciphering that table to no avail. Before you answered, I just switched "factor" to "transaction value" and got it to work! :D

Wow completely overlooked that. Derp. So you're replacing what I have as "transaction type value" (1 or -1) as factor?

CJ: What is "[factor]" supposed to represent? Rain: Thank you for the sample database. I'm not quite sure how to get my data to fit into your model.

This is meant to be a pretty straightforward, simple database. Its to manage the stock of supplies and track departmental requests, basically. There will be no bulk - we're talking giving employees pens and scissors etc. The current formula that I was trying to use was item cost * item quantity...

I'd love them to be together, but it was suggested that they be in a separate table. If there's no wrong with it being in my transaction table, I'd much prefer it be there.

I've enclosed my database to date. I will be adding in some transactions this morning. Feel free to tear it apart.

Please see this thread in regards to the tables etc I've got so far: (I cant link yet) Theory and Practice - "Database Dummy - design help?" According to plog's suggestion, I've written a query on my tbl_transactions to calculate the current stock field. I'm not sure that I've done my...

Eirman, thanks - I'll check it out. :) plog: Alright man, I've gotten to the point where I'm trying to do your suggest query for quantity purposes. I'm not quite sure that I've done it correctly, however. I have added into tbl_transactions all of my inventory, using the transactiontypeID for...

I feel really silly for asking that now, because you went into much more detail at the bottom of that post, I guess I just overlooked it. Sorry! Thanks for answering.

Well this is going to be an awkward question because I'm sure I'm supposed to know this...but, where do you put the 1/-1?

Alrighty, yes, I should've added in a date and quantity field in tbl_transactions - thanks for pointing that out. And you're right, in order to calculate changes I would have to choose if the item is coming or going. Can you elaborate on how to do the calculation for current stock if it...

Alrighty, yes, I should've added in a date and quantity field in tbl_transactions - thanks for pointing that out. And you're right, in order to calculate changes I would have to choose if the item is coming or going. Can you elaborate on how to do the calculation for current stock if it...

Hi yall! I'm trying to build a database at work for inventory purposes. I've been working on it for a few weeks now and have gained little ground, so I'm reaching out. My knowledge of access is relatively basic - I understand tables and relationships and queries and forms and creating reports...