Share via

How to display data query in textbox on MS Access.

Anonymous
2020-02-27T02:42:38+00:00

Dear All,

   I have price data and I created query sum price (NET_Query). I want to show NET_Query in textbox on form. How to do it??

   I try do this. It's not work.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-02-27T03:30:22+00:00

    You need to make a subform based on the Net_Query table/query, then place it on the main form. Link the subform to the main form using the [PR No].

    The subform will list all the records associated with that [PR No] field.

    0 comments
  2. Tom van Stiphout 40,091 Reputation points MVP Volunteer Moderator
    2020-02-27T03:52:06+00:00

    Try this: have the access wizard create a datasheet form based on your query. Save that form. then drop it on the main form. Voila, a subform with that data.

    there are finer points; post back if you need more.

    0 comments
  3. Anonymous
    2020-02-27T04:27:35+00:00

    Thank you for your advice. I have a question, If I add field Total1 in Table EHT_PR. Can I get data from Query into it???

    0 comments
  4. Anonymous
    2020-02-27T04:27:48+00:00

    Thank you for your advice. I have a question, If I add field Total1 in Table EHT_PR. Can I get data from Query into it???

    0 comments
  5. Tom van Stiphout 40,091 Reputation points MVP Volunteer Moderator
    2020-02-27T15:57:07+00:00

    In most cases we discourage storing totals in the database: that's what we have queries for. The SQL language is optimized to calculate on the fly.

    0 comments