Re: How to write an IF statement in VBA
From: Rose (anonymous_at_discussions.microsoft.com)
Date: 05/24/04
- Next message: Rose: "Re: How to write an IF statement in VBA"
- Previous message: Rose: "Re: How to write an IF statement in VBA"
- In reply to: Ted Allen: "Re: How to write an IF statement in VBA"
- Next in thread: personalIT[Really John Sanders]: "Re: How to write an IF statement in VBA"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 24 May 2004 06:57:44 -0700
I might have not been clear earlier. The companies *are*
the customers...I should have used the same term
throughout. They will only show up once in the Company table.
I 'port the company data from MAS (an accounting system)
about once a week. I have to run a query to prepare my data
for the rest of my queries, and it made sense to add
GroupName at this point, since I don't really need it in my
table and I don't add companies in manually. Furthermore, I
have hundreds of customers, but these 15 companies need to
be treated differently than the rest. Several people's
suggestion of a Select Case was what I needed.
>-----Original Message-----
>Hi Rose,
>
>I think that what Tim is referring to is that it appears
>that you are creating this field in a table where each
>company appears numerous times (otherwise why automate
>it). Tim is suggesting that if this is the case it is
>not the preferred way of handling data in a normalized
>database (to add another field that is a constant based
>on the company name).
>
>Instead, you would normally have a company lookup table
>that would list various data about the company, such as
>the name and the group. Then, the customer table would
>relate to the company just by storing the company ID.
>Queries would then be used to relate the customer data
>and any of the company data (including the group) from
>the lookup table.
>
>HTH, Ted Allen
>
>>-----Original Message-----
>>I *am* creating the new field GroupName. It's populating
>it
>>that requires a If statement, or similar.
>>.
>>
>.
>
- Next message: Rose: "Re: How to write an IF statement in VBA"
- Previous message: Rose: "Re: How to write an IF statement in VBA"
- In reply to: Ted Allen: "Re: How to write an IF statement in VBA"
- Next in thread: personalIT[Really John Sanders]: "Re: How to write an IF statement in VBA"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
