Append Query Value to one cell of a specific table

[Arlmachado]

I have done a couple of sums of some data with a Totals Query, but would like that, each one could be appended to a cell of a table of my choosing.

Is that possible? Can I append the value (which I got from a Query) to a specific cell?

 

[sxschech]

You can by using an UPDATE query and have common items to filter on. You would use a WHERE clause in your query. Something like WHERE Year = '2017' AND ProductName='MyCell' AND CellToUpdate Is Null. If the row containing the cell has a unique ID, then it is much simpler, you can then say WHERE ID=12345. If you aren't able to define a specific where clause, you may end up needing to copy and paste.

I reread your post, you mentioned Append. Are you asking to add a new row to your table and want to specify which field in the new row gets the data, if so, the Append query does allow you to specify which field the data should be mapped to. So if you source field is Quantity and your destination is SummaryTotal, you would specify that in the query.

 

[plog]

That post reeks of Excel thinking. I fear you may not be doing things right.

Access has tables, tables contain records and records contain fields. You need to think of your data in that hierarchy, not a collection of individual cells. Relationships are key in Access. All the fields of a record go together, all records of a table are independent to each other, but share the same format (field names and data types).

Also, APPEND queries are sign that you haven't structurred your tables correctly. In a database you don't usually store totals--instead you calculate them when you need them. You do this witha query and reference the query when you need that total value.

Perhaps you can better explain what you ultimately want to achieve and demonstrate it with some sample data.

 

[Arlmachado]

Thanks, you are right, I am going to try to explain myself better, however after a bit of considerations I thought it would be better to asked this question in the Forms forum.