Search results

Thats actually not being used. I was going to store the Balance amounts in that field but everyone said that was a bad idea, so that Balance field is inactive.

Ok here it is, I hope you can make some sense of it. SELECT Inventory.[UPC#], Inventory.[Product Code], Inventory.Brand, Inventory.Size, Inventory.Flavor, Inventory.Type, Inventory.Casing, Inventory.[Extra Info], [Inventory Entry].[Quantity-In], [Inventory Entry].[Quantity-Out], [Inventory...

Do I put that in the Querie or in VB Code. Sorry Im not very good at this

I tried that and I couldn't get it to work. If anyone could help, Id really appreciate it. thanks again

Hi everyone! Im trying to make a report that only shows products whose inventory is lower than 20,000. Now I know this sounds like a simple querie, but I dont have a "Balance" field in any of my tables. I use a calculated field that subtracts the "Quanity-Out" from the "Quantity-In". This works...

Actually, It is already grouped by Label name. The problem is that every inventory transaction for every label is being shown. I only want one Line per label, showing only the current balance. I know there must be a way! thanks for your help

Hi there, Im currently working on a report that will give a complete inventory of all the Labels that I deal with. I have an inventory Form with all the different labels we have, and then a subform for entering the Inventory transactions. Now in my report, I have it set up to calulate the...

You're a genius! I have no idea how that works, but I just did a little cut and paste, and now Im all set Thanks again

I have a report which calulates various Label amounts for production runs. The labels come in bundles of 1000, so I need to Round up to the nearest 1000 in one of my Calcultions. Here is the Calculation that needs to be rounded up: =[# of Cases]*[Case Count]+1000 Another problem may be that...

Is there anyway to download better format styles?, (You know like Sandstone, and International) I've recently made a nice database and though I dont want it to be too "busy", I would like it to look like it's worth the effort I've put into it. Those default formats are just so... blah. Any...

Doesn't it feel wierd to reply to post from 1999? It's like jumping into a time portal

Try upgrading Your version of Access to 2002, You may find the Help section has an answer to your question

Hi Everyone I have a form in my DB that has a subform that holds all of the Inventory transactions for the labels I keep track of. Everything works fine except every time I open the form and go to a product with more than one transaction, I notice all the records are all jumbled up. I need...

Think about how great you'd feel if you sent that Code to me too! Thanks

Thanks for the warning, I definatly wont do that then.

Im making a form for my DB at work that needs a lot of calculated fields. So I write the calculation as the control and it works fine, but none of the numbers are being stored in there respective tables and I need them to be for analysis purposes later. Is there anyway to save these calculations?

Thank you, I know it would be something obvious.

While basing a Report on a query, how can I have it recognize only those records with NO value in a certain field? Thanks!

I work at a vinegar factory and Im trying to make a form that will print out Production Schedules on a daily basis. This is really difficult and I dont know where to start. This is what I have and need: -I have two tables, one called "Label Inventory" that stores all of the info about the...

Im trying to learn how to use VBA for Access 2002 so that I can make a more advanced DB for my company. I've searched the internet for hours for tutorials but all I've gotten is a headache. If anyone knows any Websites or other media offering free tutorials for begginers (and I do mean...