I have a tabular form with lots of rows against a similar ID. But when I build a query either in update query or union query it shows multiple rows against same ID and one field is in the last row against that ID. Now I want how to solve this or how to build a union query based on a tabular form
hi Satyaban, without seeing your data structure and your query, I'm not sure how to help. A suggestion: if you want just ONE record for an ID, you can use a Group/Totals query or criteria under the ID to just get the latest value
@@LearnAccessByCrystal Thanks for your prompt response Sir. I'm from suc a place where scope for MS Access learning is very low. So whatever assistance i am getting is from kind helpers from youtube. Therefore, It might not be prudent on my part to approach further. Still I want to mean it is a single table database with two forms where most of the formulas are applied in the subform. In the main form there is a field where Name has to be given and other data to be collected from the subform. I created a query including the name and other fields those are in the tabular form. But when I run the query name is displayed only once and that too at the bottom. I tried Union Query but same output I am getting. Still if you don't mind to get my database for having a look to detect the problems, can mail it. Still shall try group/totals query as advised. Thnx and regards.
@@satyabanukil779. This video was made before Access got enhanced to turn on a Total line with the user interface. When you are looking at results of your query, click Σ in the Records group on the Home ribbon. This adds a row to the bottom of the query where you can choose what to show for each column ... Sum, Count, Max, Min, etc
I have a tabular form with lots of rows against a similar ID. But when I build a query either in update query or union query it shows multiple rows against same ID and one field is in the last row against that ID. Now I want how to solve this or how to build a union query based on a tabular form
hi Satyaban, without seeing your data structure and your query, I'm not sure how to help. A suggestion: if you want just ONE record for an ID, you can use a Group/Totals query or criteria under the ID to just get the latest value
@@LearnAccessByCrystal Thanks for your prompt response Sir. I'm from suc a place where scope for MS Access learning is very low. So whatever assistance i am getting is from kind helpers from youtube. Therefore, It might not be prudent on my part to approach further. Still I want to mean it is a single table database with two forms where most of the formulas are applied in the subform. In the main form there is a field where Name has to be given and other data to be collected from the subform. I created a query including the name and other fields those are in the tabular form. But when I run the query name is displayed only once and that too at the bottom. I tried Union Query but same output I am getting. Still if you don't mind to get my database for having a look to detect the problems, can mail it. Still shall try group/totals query as advised. Thnx and regards.
@@satyabanukil779. This video was made before Access got enhanced to turn on a Total line with the user interface. When you are looking at results of your query, click Σ in the Records group on the Home ribbon. This adds a row to the bottom of the query where you can choose what to show for each column ... Sum, Count, Max, Min, etc