Sorry, but that does not seem to work.
N2 always has a QTY.
I changed "N" to "Q" because that number shows only when the part number changes, but when I include the rest of the formula, I get that QTY +1, not QTY + QTY from the row above. Maybe I do not understand something...
Anymore help is appreciated.
Thank you,
jball
Last Activity: Mar 20 '08, 02:37 PM
Joined: Oct 31 '07
Location:
-
Help - VB Code for excel QTY Sum
I am working in excel and I am new to visual basic, but I think there is a simple code for my problem.
In column "J" I have Part Number
In column "N" I have QTY
In column "Q" I have an "=if(mid)" statement that displays Part number for only the first part number in column "J" where the part number is different from the previous part number. this column is sorted.... -
Duplicate record error
Hey Guys.
New problem. I have a duplicate record button on my form, but when I click the button, it says "The 'Copy' RunCommand cannot be run in disabled mode." How do I enable it?
Thanks,... -
I started over from scratch and that does work. Thank you! I must have messed up my settings on the original file.Leave a comment:
-
No, that does not work.Leave a comment:
-
Switchboard
Hi Guys,
I am working in 2007 Access. I have created switchboards in 2007 before, but now when I create a switchboard I get a page with only a title, no buttons and no other words. Is there an update for access that I need or is there a setting change for this problem? I have a feeling it may be in my property sheet. Is there anyway to reset it?
Thank you -
I have a 2 tables: Finished goods and Purchased Parts.
Finished goods unit price is comprised of processing costs & purchased parts costs. Finished goods table has the following information:
Product number
Product Name
Unit Price
Effective Date
PP1 (purchased parts part number)
QTY1
PP2
QTY2
PP3
QTY3
Purchased parts table has all the different...Leave a comment:
-
Autofill rows of data
Thanks for the answers to my last question.
I am not sure of a good title for this question.
My project is basically an inventory with purchased parts and finished goods.
Question:
When I update my purchased parts prices, I want my finished goods table to keep the history and automatically insert new rows of data for all finished goods that have the "new" purchased parts price.
... -
Using a wildcard in a query.
Hi guys,
I have a simple questions I think.
I have a report based on a query.
The query has an input box that says [input basic part number].
If the number is exact, the report runs great. My question is how do I add a wildcard to this criteria?
Example
[input basic part number]
Enter "aaa-11-ddd" and all entries are on the report.
I want
"aaa-11*"...
No activity results to display
Leave a comment: