RE: Set Values in Access w/o Query

[BIGTONE559]

RE: Set Values in Access w/o Query

Not Sure if my terminology is correct. Nevertheless i created a query with the following criteria:

Trim([FIRST_NAME]) & " " & Trim([LAST_NAME]) & " " & Right([ID_NUM],2)

It created a column of data that was exactly what i wanted. My question is. in the table itself. Is it possible to include the criteria that i stated above so that when the values are entered in the first 3 columns that it will fill the fourth in without having to run an update query (fill in Automatically basically).

Thanks in advance!

 

[HiTechCoach]

Re: Set Values in Access w/o Query

Understandable. . . so i guess my question would be is it possible to run queries when a record is added without having the database open? if that makes any sense.

Once we input data into our software providers program. The data is copied to the access database. All this is done "Behind the scenes". What i'm finding is that i have to actually "Run" The query by opening the db. is there a way to have the table updated without going through the aforementioned steps?

That does not make sense. What we have been recommending is select queries with calculated columns.

Select queries pull the current data every thine they are opened. Even by Excel. If you have calculated columns then they get recalculated every time the select query is opened. This avoid the ned to run any action (update) queries.

You only have to execute or "run" action queries since they modify data. Until they are executed the changes are reflected in the data or other select queries that read the same data.

 

[BIGTONE559]

Re: Set Values in Access w/o Query

That does not make sense. What we have been recommending is select queries with calculated columns.

Select queries pull the current data every thine they are opened. Even by Excel. If you have calculated columns then they get recalculated every time the select query is opened. This avoid the ned to run any action (update) queries.

You only have to execute or "run" action queries since they modify data. Until they are executed the changes are reflected in the data or other select queries that read the same data.

After reading what you wrote. . . and after having created calculated fields. . . i can say that didn't make sense. I haven't worked in excel in a while and i always have issues with syntax but i got it working perfectly and i appreciate all your help.

 

[HiTechCoach]

Re: Set Values in Access w/o Query

You're welcome.

Glad to hear you have to working.