Thanks Onedtent! This did the trick. I also had to manipulate the formula for different formats. Is there a book of formulas for Excel? What is the title?
I would like to change the data, but if you know how to just change the display/view, then that would be useful as well. Otherwise, I can just make a copy of the original .mdb and change the original.
Thanks!
I've converted several Excel sheets with our product id's that we received from our distributors into Access. The problem is that the naming convention is not formatted exactly like ours. I can change it, but there's just too many entries (about 2500 product id's per worksheet).
For example...
I received several Excel sheets w/ our product id's. The problem is that the naming convention is not formatted exactly like ours. I can change it, but there's just too many entries (about 2500 product id's per worksheet).
For example: Our distributors worksheet has a column that displays our...
I have Crystal Reports v 8.0.1.0. I'm creating an Order Fill Percentage where I need to show the percentage of Sales Orders(SO) filled. FYI: Each SO has at least one packing slip id, but some have 2 or more. In order to get an accurate percentage of Sales Orders filled, I need to create a...
I have Crystal Reports v 8.0.1.0. I'm creating an Order Fill Percentage where I need to show the percentage of Sales Orders(SO) filled. FYI: Each SO has at least one packing slip id, but some have 2 or more. In order to get an accurate percentage of Sales Orders filled, I need to create a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.