I posted a few weeks ago about trying to set up a way to order by unit number (http://bytes.com/topic/access/answer...-ordering-unit)
I'm trying to use a similar structure to what OldBirdman suggested in my previous post, but I'm a bit stuck.
Here is what I've set up:
tbl_Orders
Order_Number
Order_Date
tbl_Units_Order ed...
ajhayes
Last Activity: Mar 19 '09, 01:26 PM
Joined: Feb 20 '09
Location: Northwest Arkansas
-
How to sum multiple occurences of same item number.
-
Are you saying as long as the group of items that make up a unit don't change? I can't really see any reason why they would change, but I suppose there's the possibility that they might want to change to a different brand of insulator or something like that in the future, which would be assigned a new part number when it came into our warehouse. -
These are my initial thoughts:
Table: tbl_unit_items
Fields:
Item Number
Unit Number
Qty Per Unit
Table: tbl_units_order ed
Fields:
Order Number (auto number)
Unit Number
Qty of Units
Then I thought I would set up a query with the two tables and then multiply the qty of units times the qty per unit for each item in the unit.
Is this...Leave a comment:
-
They are okay with having the option of "order by part number" where all items within that order are by part number and then a separate option of "order by unit" where all items within that order are done by unit number. As long as the two different orders can still be linked back to the project. For instance, the guy who does the metering portion may want to order his stuff by order number, where the guys who build the line...Leave a comment:
-
Thanks for that link, that will be a big help in the future.
Printing that out for my stash of references.Leave a comment:
-
Need help setting up table structure for ordering by unit.
I posted a question here last week about an ordering database I'm trying to set up, and got some excellent help. So I'm hoping some of you might be able to get me on the right track with another question I've got on the same project.
Here's some general info on what I've done so far (For the record, I'm quite a novice at this.):
The database I'm setting up is for a small electric utility company to submit orders to... -
Okay, I just cheered out loud in the middle of my super quiet office... everyone is wondering what the heck I'm up to now. :-)
That was exactly the fix. I've googled it a billion times and couldn't find the right syntax.
Thank you SO much!!Leave a comment:
-
Having a problem with query criteria coming from a subform
Hello everyone,
This is my first time posting here and I'm hoping someone can help me out. I'm a relative newbie to Access and am pretty much learning as I go along, so please bear with me.
Here is what I am trying to do. I'm building a simple database that will allow our engineering staff to enter in the items from the inventory warehouse that will be required for a project. Each inventory item has a unique part...
No activity results to display
Leave a comment: