Topics Search

Count the number of records in a subform

Count the number of records in a subform
Views: 119
I have designed a booking detail form for hotel database. It contains a sub form which displays Room_No (text), Available(yes/no field) columns.

Requirement: I want to count the selected Room_No in the sub form and display it in the text box placed on main form.

For this, I used a Dcount function which is assigned in the control source of a text box. =Dcount("*", "{nameofsubform]")
But it is not working.
Also, the count for selected rooms should keep on changing as per the selection done in the sub form.

Kindly help me with a solution for counting the selected rooms on the sub form.
Sponsored Links:

Similar posts...


Update Multiple Records With A Check Number

Update Multiple Records With A Check Number Icon
I have a form. Let's call it frmPayments. It would have a subform named frmPaymentsSub. The subform is made up of line items to be paid. Each record (line item) has an invoice number. I enter the check number in a field for each record.

Sometimes multiple records have the same invoice number. I added two queries to count the records for each invoice number and can display that on the screen, if needed. Here is what I need to know. Is there a way to make the following work?

If there are two or more records (line items) with the same invoice number, and I enter the check number in one of the records, can that check number be inserted automatically into theremaining records with the same invoice number?

MS Access 2007: Calculated field based on subform:

MS Access 2007: Calculated field based on subform: Icon
As part of a review assignment, I have been tasked with adding a calculated field to a form that will count the number of items listed in the associated subform. The subform is based on the table "tblProduct", and is a subform named "frmProductSubform". The Parent table is named "tblCompany".

The tables are related by ProductID, and CustomerID fields. The fields included in the subform a ProductID, ProductType, Price, and Unit.

I am trying to create a calculated field based on the subform that will count the number of line items in the subform for the Parent table Customer record. I have added a text field to the Parent table's detail section named "Number of Products", and attempted to build an expression "=Count([ProductID])" to count the records in the related subform, but all I get is "error".

Counting the records in a subform

Counting the records in a subform Icon
I have a form that is used to receive Items. When an item is received it already has a material code and a unique serial number. the form has a subform where the serial numbers are scanned in.

there may be multiple items received therefore multiple serial number listed on the subform. I need a way to count the records.

subtracing the count values between to count queries

subtracing the count values between to count queries Icon
I have an access database where I have multiple queries that I have created in SQL view to produce a count number, more particularly, a count of the number of records meeting a certain criteria. One of the queries looks like the following in SQL view:

SELECT Count(*) As [Count Test]
FROM [Count Test]

My question is how do I created another query that will subtract the values produced by two queries? For instance Count Test1 - Count Test2 = Count Test3

Calculation based on count of records in a query

Calculation based on count of records in a query Icon
I'm trying to create report that will have calculated values based on the number of returned records for a query. The query returns records based on the date, so the number of records returned will change day to day.

The calculations in the report should reflect the fluctuating number of records in the query.

So in the report, I have a text box with the Control Source:


Access seems to like the context okay (no error messages in Design View), but I get an error when I go to Report View. Is there some other way I should be telling it to count the number ofrecords in the query?

Countif count the number o records

Countif count the number o records Icon
I am trying to count the number of records that have criteria of FSL = 0, 1, 2, 3 and 4. After research this I found a way to do this was make a calculating IIf field then have a separate field do the count. This is what I've done but it is not working.

=IIf([FSL]=0,1,0) (named this field 0CountCal)

Used the same formulas for 1,2,3 and 4

unbound search field

unbound search field Icon
All, I am working in a 2003 database. I have a form with a subform. There is an unbound field to select a tracking number that pulls up all the cooresponding records in the subform. I created an alternative search on the sales number to pull up the cooresponding records in the subform if I didn't have a tracking number.

It's not working and I've been trying for two hours to get this right.

When I search google on "searching the field, I only get help when the subform is already populated with records and just need filtering.

Why does the combo box work for the tracking number and not the sales number? The tracking number is used as a link child for the subform but it's also an unbound field to search. I cantfigure this out and I know its really simple.

Counting 0 records in a report

Counting 0 records in a report Icon
For one report I am doing I need to count the number of records on the report and I need to show "0" if there are no records. the standard Count( ) method does not work with zero records. I have not been able to come up with a satisfactory approach.

I need to count the field "LNFN"

The no Data Event is not appropriate for what I need to do.

Count Results

Count Results Icon
I have a table with a list of suggestions in it, When I open the main screen, I have a subform in there linked to the table for the suggestions and have a text box in the form.

it checks a field called "activesuggestion", which I have as a yes/no box in the table.

In the text box in the form, I have used the =count to try and return the
number of new records added since last viewing the database


This returns all records in the table, but I would like to limit it to those which have the activesuggestion box checked. I tried the following, but this continues to return a "0" figure


Total Control Value in SubForm

Total Control Value in SubForm Icon
I have a two controls on a continuous subform the row source for both is a query and Column(2) is a Name, Column(3) is a number.

These are displayed by setting Column Count and Column widths to suit. The whole picture is - the Main Form will have a Calculated Value I want to enter a number of entries in the subform and depending on the value allocated to each Name (location) I will then allocate a portion of the Total Cost to each name.

It's taken me ages to get a cascading combos where the 1st is on the Main and the Second is on the subform now I cannot total this value on my subform so until I can do this I cannot get apercent to allocate each Location Cost (does this make sense)

I'd hoped this might work but I don't think Column count can be used in an expression
Also the subform record source is not the table where the values are stored which I feel is part of the problem