adding to notes column

[Eskimo]

Hi, I have a table created from multiple steps to end up roughly like this....

LAT LON PTT DATE NOTES
60 90 123 01/10/2010 blank
61 90 123 01/11/2010 blank
65 90 155 01/10/2010 blank
66 91 155 01/11/2010 blank

The above is very vague, there are about 13 columns that do a lot to
describe the PTT (Caribou Collar Number) and their location data for each
day. most of the spaces in the notes column are blank.

However, I would like to add certain characters such as "S" for start and
"E" for End in the notes column automatically based on the following criteria.

For every collar (PTT), I would like to place an S in the notes column where
the date equals #such and such a day# and if that such day is not available,
then go to the next day for that collar. I would also like to place an E in
the last or max day for each collar.

Here is the twist, I have a table that list all of the active PTTs and it is
these active ptts that are the only ones I want to update.

Thanks in advance.

 

[Steve]

Eskimo,

Before you go any further, you need to resdign your tables:
TblPTT
PTTID
PTT description fields>

TblPTTLocation
PTTLocationID
PTTID
LocationDate
Lat
Lon

If you need help with your database, I can help you. I provide help with
Access, Excel and Word applications for a small fee. If you want my help
contact me.

Steve
(e-mail address removed)

 

[John... Visio MVP]

If you need help with your database, I can help you. I provide help with
Access, Excel and Word applications for a small fee. If you want my help
contact me.

Steve

Only two weeks into the decade and our personal troll stevie is up to his
old tricks.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

John... Visio MVP

 

[Gina Whipp]

Eskimo,

I'm going to suggest an update query BUT, i don't see the column that
indicates which PTT is current or are they all in the same table? Also,
where are you getting the *DAY* value?

As a side note, here the help is FREE! 99.9% of us charge NOTHING, NADA,
NIL for our advice. Either I or one of the other volunteers will get back
to you with a FREE answer.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John W. Vinson]

Hi, I have a table created from multiple steps to end up roughly like this....

LAT LON PTT DATE NOTES
60 90 123 01/10/2010 blank
61 90 123 01/11/2010 blank
65 90 155 01/10/2010 blank
66 91 155 01/11/2010 blank

The above is very vague, there are about 13 columns that do a lot to
describe the PTT (Caribou Collar Number) and their location data for each
day. most of the spaces in the notes column are blank.

However, I would like to add certain characters such as "S" for start and
"E" for End in the notes column automatically based on the following criteria.

For every collar (PTT), I would like to place an S in the notes column where
the date equals #such and such a day# and if that such day is not available,
then go to the next day for that collar. I would also like to place an E in
the last or max day for each collar.

Here is the twist, I have a table that list all of the active PTTs and it is
these active ptts that are the only ones I want to update.

Thanks in advance.

You really, really DON'T want to store this kind of derived information in a
table!

And you don't need to do so. A Query can easily find PTTs and dates, and even
generate a string of S and E; and doing so would prevent problems if new data
is added.

You'll need to explain what makes a PTT "active" - is that based on other
information in the table?