Create inventory-like database?

[Ratedr]

I want to be able to create an inventory database for the weights of
items that I have in stock. I keep items in stock in 2 different
sizes so I would need to keep both of them in the database. I already
have it broken down in an excel sheet so if there is a way to just
import it...that would be great. Lastly, I would want to be able to
search the style #, and then it would give me the resulting Weight in
size 6 and 10. My excel sheet currently looks like this:

Style # Weight Size 6 Weight Size 10
abc 1.1 1.5
def 1.5 2.2
ghi 2.3 2.9
jkl 1.6 2.2

and so on. Any help would be greatly appreciated.

Thank you in advance
Scott

 

[Al Campagna]

Scott,
I would suggest this more "normalized" table structure...

(AutoNum)
|
ItemID StyleNo Size Weight
1 abc 6 1.1
2 abc 10 1.5
3 def 6 1.5
4 def 10 2.2 etc...

If the resulting recordset were filtered by "abc", 2 records would be returned... the 6
and the 10
You have to imagine what would happen if a 3rd size were ever added. You'd have to add
that size to your table, and uipdate all your forms, queries and reports.
Using my setup... just start adding your new data for the new sizes... nothing else
would have to be changed.

ItemID StyleNo Size Weight
1 abc 6 1.1
2 abc 10 1.5
3 def 6 1.5
4 def 10 2.2
5 def 12 3.1
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Ratedr]

thanks so much. now what I would need to know is: is there a function
of access, or a third-party addon/program that would let me make a
sort of search box, where I can search by any of the column headings,
and it would give me all of the resulting answers. Like in the
example below, I could search style# = abc, and it would only give me
those 2 style #s, OR I could search size = 6 and it would give me
THOSE 2...and so on.

..

 

[Al Campagna]

Rated,
See Filter by Form, a built in function, in Access Help.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Ratedr]

This is SORT of what I am looking for in essence, but not the way I
wanted it. First off, lets say I have a bunch of styles like so: abc,
dbc, aba, abv, bcg, ghi, and so on. and I wanted to run a search for
all styles containing "bc" . the result would give me the abc, dbc,
and bcg. however, in the filter by form..I would have to type in
exactly the style I need, not partial. ALSO...I am more interested in
the possibility of a function of access or third party add on (maybe a
sql program or something) that would have some sort of GUI that just
gives me choices of search possibilities, and I either choose from a
dropdown menu or type it in, and in the background it searches my
database. Does anyone know of such a program?

 

[Al Campagna]

RatedR,
You wrote...

however, in the filter by form..I would have to type in
exactly the style I need, not partial.

Not true...
Right clicking on a form field will bring up a submenu, with several filtering
options, such as Filter By Selection, Filter For, Filter Excluding, as well as Filter By
Form. You have all normal global filtering capabilities with those built in functions.
Using abc would only return "abc"
Using *bc as a filter would return both "dbc" and "abc" as well as "wbc", or even
"xyabc"
Using ???bc would return only "xyabc" from the results above.

But, it appears as though you are set on an add-in or 3rd party utility to do
esssentialy the same thing.

I'm not aware of any such an add-in, although one may exist. And I would imagine, that
some customizing/configuring would be needed for any such add-in.

Try a new post with just that question... this thread may be a bit "buried"
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[i_takeuti]

I want to be able to create an inventory database for the weights of
items that I have in stock. I keep items in stock in 2 different
sizes so I would need to keep both of them in the database. I already
have it broken down in an excel sheet so if there is a way to just
import it...that would be great. Lastly, I would want to be able to
search the style #, and then it would give me the resulting Weight in
size 6 and 10. My excel sheet currently looks like this:

Style # Weight Size 6 Weight Size 10
abc 1.1 1.5
def 1.5 2.2
ghi 2.3 2.9
jkl 1.6 2.2

and so on. Any help would be greatly appreciated.

Thank you in advance
Scott