I'm sure that this is an easy question 
Author Message
 I'm sure that this is an easy question

The easy way would be to create a table that contains the counties and

Then you could run an update query or simply link the two tables together in
your queries.

In the update query.
Link the tblCountySalesmen to the tblSales by their County fields.
Then set the tblSales.Salesman equal to tblCountySalesmen.Salesman


> I have a table with five columns the first column is titled "County," and
> the second column is titled "Date," the third column is titled "Product,"
> the fourth column is titled "Dollar Amount," and the fifth column is titled
> "Salesman."  I append this table once a month to enter new data.  The append
> adds approximately 1600 new rows, but does not include any data for the
> column "Salesman."

> What I need is this.  I need to create an action query that will look at a
> county name under the column "County" and will create a salesman's name
> under the column "Salesman."  For example, if row number 1, 5, 15, 48, etc.
> contains the name Mecklenburg under the column "County," I would like to
> create a criteria that would say "If the column 'County' contains
> 'Mecklenburg' then enter 'Mark Arcilesi' under the column 'Salesman.'"  When
> I run the query, the name Mark Arcilesi would be added under the column
> "Salesman" on every row where Mecklenburg is listed under the column
> "County."

> Please help me if you can.

Mon, 14 Apr 2003 23:58:17 GMT  
 [ 1 post ] 

 Relevant Pages 

1. A very easy question - I'm sure

2. A very easy question - I'm sure

3. Easy question I'm sure - never written vbscript before

4. Really easy I'm sure...

5. silly newbie question i am sure

6. EASY QUESTION but i am a newbie

7. AN EEEAAASSY question I'm sure

8. A Simple Question I'm sure

9. I am sure this is an easy question: How do I copy a file to a storage card from the PC

10. Help please with a simple problem I am sure for an experienced programmer

11. Easy Question 'F' keys

12. EASY EASY EASY question


Powered by phpBB® Forum Software