I am very new to Access so please excuse me if it's too obvious: can I add a non existing field to a query? It's not calculated or anything just a new field. Or do I need to make a new table first? Thanks in advance!
I am very new to Access so please excuse me if it's too obvious: can I add a non existing field to a query? It's not calculated or anything just a new field. Or do I need to make a new table first? Thanks in advance!
Fields are in tables. Queries pull data from tables. Queries can do calculations with table fields and those calculated 'fields' can then be referenced in forms and reports.
Why would you need to make a new table?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks. I figured it out. I had to make the query make table then requery.
The reason is the new field can't be added to any existing tables.
Why can't you modify table design? This is a split db and you do not have direct access to the backend? What is the backend?
And why would you build a MakeTable query as opposed to just opening the table designer?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I have two (or 3 tables) and then I had to make a query to get some fields from them. Then I need to add some new info based on the datasets in the query.
I am not familiar with backend functions. I only have one database right now.
If all the tables are local to the database and not links to another database file, then you should be able to do any edits you wish.
If you want to save calculated data - why?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.