Autofill table cell

[Brian62]

I want a cell in the table to automatically insert a specific text in the cell but I am unable to do this. I am pulling information from different tables to create a report off of a SQL Query but 3 out of 4 do not have the customers name in those tables because those tables were specifically designed for those customers so there is no need to have the column at the time. I now created a column for customers in those tables now but would like to have the customers name show in the table automatically. I even have tried SQL statements but I can not figure this one out.

I hope this make sense.

Thanks, Brian

[NeoPa]

Not really Brian.

Are you intending to update the records of the table in place? That can be done with an UPDATE query.

We could probably be more helpful with a clearer question.

[Brian62]

The update query helped great by filling in the empty cells. Now I want the table cell to automatically fill the cell with one customer name.... lets say APS. When I run my reports off the query I need to have the customer APS pulled in the report which means the talbe would need to have APS in the cell to pull.

I'm not sure if I can do this in the Query by automatically filling in the cell with APS when a new record is created.

I hope this explanation is better.

Thanks, Brian

[NeoPa]

I'm afraid not Brian.

When talking to someone it's possible to be very lazy in one's speech and get away with it - and many people do that. There are generally reams of other information, clues, available to help the listener catch up with the meaning. The human brain works extremely well at that task.

Unfortunately, in written text most of these clues are not there. When I get half way through a sentence and find it doesn't actually read correctly - I have nothing to fall back on to guess what you actually mean.

In technical text this is further complicated by the nature of the task. Far more information needs to be available if the information is to be used to base decisions on. If this is unclear then we can't even make first base.

[NeoPa]

This sounds as if I may be trying to insult you, which is not my intention.

It is a sad fact that most people struggle to express themselves clearly in text. Mainly because expressing in speech is so much easier and people don't see the benefit of learning to be clear. You are simply suffering from being "normal" in this respect.

Unfortunately, that doesn't make it any easier for me to interpret what you mean late in the evening, so if you would like to be clearer then I can help you.