Re: Huge Database - Need help with query please
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 16 Nov 2005 10:32:31 -0700
On Wed, 16 Nov 2005 08:29:10 -0800, "Ari Gold"
<AriGold@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>I need to setup a database query on all the items we stock in our warehouse.
>We have 88,000 part numbers and right now I just have everything in 2 tables,
>but I know I will have to change that in order for a query to work.
>
>What we use is a 3 digit code for the mfg., the part number, and a
>description, however, none of those fields are uninque. For example - we
>would have an AC Delco spark plug part number 44 in our system as: ACD (mfg
>code) 44 (part number) spark plug (description) everything else we have in AC
>Delco will also have the ACD mfg code and every other spark plug we sell will
>have 'spark plug' for the description and with 88,000 part numbers there is
>bound to be more than one part number 44 under some other mfg code. The
>ultimate goal is to have web users filter the db by those 3 fields. If they
>want to see everything we have in ACD, or everything we have in spark plugs,
>etc. My access is very rusty, I haven't used it in more than 2 years and my
>books from college are no help. Anyone have any advice? Suggestions? Links
>to more information?
>
>Thanks in advance.
>
I'm not at all sure what the problem is. First off, 88,000 rows is a
rather modest table - ten times that is getting a bit large, 8 million
rows is probably getting a bit too big to be comfortable.
Secondly, an Access query can use any (well, hundreds) of criteria. If
I understand aright, you have three numeric (? or text?) fields for
Manufacturer, Part Number, and Description; you can query any of these
fields, individually or in combination.
What specific problem are you having?
And why do you have TWO tables? You've described one. What's the
other?
John W. Vinson[MVP]
.
- Prev by Date: Re: I need help with a SQL statement
- Next by Date: Re: Please help!
- Previous by thread: Re: I need help with a SQL statement
- Next by thread: Re: Huge Database - Need help with query please
- Index(es):
Relevant Pages
|
