Record summary on the form itself

janith

CPA
Local time
Today, 07:44
Joined
Apr 11, 2012
Messages
65
Hi,

I've a form with some data input control. what I want is a window on the form itself, which acts as a counter on the no. of volumes I've entered. eg: my combo box contains values like Card Queries, Charge back, Authorization, etc. when ever I select the value and hit save. it should show like:

Card Queries 12
Charge back 17
Authorization 08

This to ensure that I don't have to go back to table to check for these details and they should immediately reflect on the form where I'm keying this data.

Thank you in advance....
 
Hi,

This should be possible by creating a subform based on a totals query, or by VBA code that calculates the totals using DSum and displaying them on the form.

Could you possibly upload a sample database and I'll take a look for you.
 
well.. as of now its only on paper, can you please advise me how that can be achieved by simple steps... so that I can carry it out... sparks80 do you have a gmail id so that i can contact you directly...thanks
 
I'll try and knock up an example of what I mean, it might be easier than trying to explain in words.
 
Hi,

Have a look at the attached file.

It is a bit of a meaningless example (well made up anyway) but it should show you how to create a subform based on a totals query.
 

Attachments

well..that good but what i was looking was like

ham 25
cheese 1
chicken 1

etc... instead of a total count... !!!
 
Hi,

When you use a totals query you can group by a certain field. In this example you can group by the object and then sum the quantities for each object.

I have modified the sample database so you can see.
 

Attachments

Users who are viewing this thread

Back
Top Bottom