-1
Is it possible to view a new column in MS-access with simple operations?
eg: my database has 2 columns
- A: arrival time
- B: departure time
I want to view C column with (B-A)
Ale
Posted 2014-01-24T17:10:52.383
Reputation: 704
Operation in MS-Access?
Answers
4
You would typically achieve that by creating a view on the data in your table as there is no need to physically store data which can be derived directly from data you already have.
In Access terms, you are creating a new Query.
Use your table for data entry and your view to read the information out.
sahmeepee
Posted 2014-01-24T17:10:52.383
Reputation: 1 589
1+1 for "no need to physically store data which can be derived directly from data you already have" (true in almost all cases). – Hennes – 2014-01-24T17:30:11.137
How can I view results data using a query? What is the header of the "temporary" column? – Ale – 2014-01-24T20:07:59.793
How can I display results without creating a new column? – Ale – 2014-02-06T17:09:22.227