Open an Query and save to Table

[Jass7869]

Hello,

I have a query that I dump into a table...via Macro. I made changes in the table (User Input in some fields) ..can I requery and not overwrite the inputs? I am new to Access not sure if this is possible? Please help and let me know if you need more info.

 

[plog]

I've rewritten this first sentence 7 times trying not to come off as an ahole. So, keep that in mind when I still do (it's not my intent).

You need to read some introduction books about how database are to work. Your fundamental idea of them is flawed. You don't need to move data from queries into tables--that's where data exists in the first place.

If you'd like to give a high level view of what you are trying to do, I'd be happy to suggest some options, but at a fundamental level your understanding of how they are to work is really wrong.

 

[Jass7869]

Yes..I know that is where the data exist in the first place. And no you don't sound like an a***ole. So the query has data from two different tables pulled into a query...now the query needs to go into another table so the user an input numbers into some fields. I got it to where the query goes into a table "C" and from there I am wondering if the user does thier input saves ..it let's say the same query is ran again..will over ride the user input?

 

[plog]

...now the query needs to go into another table so the user an input numbers into some fields

No, no it doesn't. The user can edit the data in the tables the data is actually in. Ideally, you would provide forms so users aren't directly working with tables.

You're really losing me with Table 1 and Table 2 making up Query 1 which creates table C, which feeds back into god knows where. Data in a database shouldn't move around, it stays in the table and gets edited if needed.

I suggest some reading.

 

[Jass7869]

Unfortunately, I inherit this DB...table 1 has info that I need that table 2 doesn't...thus creating a query to make table 3. Also, I am taking a class for Access..if that soothes you a little bit. (haha). I was pushed into doing this from my boss. After the query, I did make a form..but she wants a button to pull up table 3 so that users can make inputs there. Any suggestions...