I want to be able to count the number of fields in a table and for it to generate a number

[jactheblock]

I have created a form that shows the members and how many bookings they have made. I just want to make a box that shows how many bookings have been made in numerical form, because at the minute, it is just shown in a sub-form table. I am a newbie with Access so i believe this is actually quite simple but i do not know how to do this. Thanks for any help!

[ranman256]

The # of fields in a table should have nothing to do with # of bookings.
you should count the bookings in 1 single field via query. Booking Date field?

[jactheblock]

So there is no way to count the number of data added to a sub-form? I have 2 inputted data, surely there's a way to just count that up without making a query. I am incapable of making queries so i try to avoid them as much as possible

[CJ_London]

in your subform design, show the navigation bar?

in your subform header of footer you can have a textbox with the sourceobject set to

=Count([BookingID])

change BookingID to a name of one of your fields (not controlname) in your subform

[ranman256]

Do you mean count the values in a field?
yes, run a count query.

[jactheblock]

I have ran a count query and it now counts the number of values in a field, but i dont understand how to get this value into a form now....

[CJ_London]

your reluctance to share basic information or to comment on the suggestions already makes it very difficult to help you. There is no 'standard way' of doing things so we are guessing at what you might actually have at the moment.

Providing some example data, the outcome required from that example data, a screenshot of your form will go a long way towards enabling people to help you

[jactheblock]

I'm sorry, its just very difficult to explain because im doing this in Welsh, and hardly understand what i am doing at the moment anyway...

I am making a database for a made-up gym, and for this task i need to record and update class credits purchased by making a Form. I have set up the form to show the members of the gym, and to show how many of the class credits that they have purchased in a sub-form. I need a simple way of showing how many class credits have been used in a number on that form. From this, the members will know how many class credits they have left. What else do you need to know?

[CJ_London]

descriptions help us understand the context of what you are trying to do, but not how you are doing it so I repeat - show some data/screenshots etc. You say you have a form - so show it with some example data and what the outcome is required from that sample data. At the moment the information we have is the equivalent of you saying to a garage 'I have a green car, it has some wheels but it won't start'

Also please comment on the potential solutions posted in post #4

And just out of curiosity, why are you doing this in welsh?

[jactheblock]

Here's some screenshots. What else do you want to see? I am a bit confused to what Comment 4 means. what is 'sourceobject' and 'controlname'? I have tried =Count([TanysgrifiadFisol_ID]), but that only comes up with an Error. I am doing this project in Welsh because those are the rules that have been set by the examiner

[CJ_London]

per post #4, your 'count' control needs to be in the subform header or footer. If you want to see it in the main form, then you need to reference it

so copy the control to the header section of your subform - give it a name, suggest "ctlCount"

then in your main form, create a new control and put this in the controlsource

=tbl_an????.form.cltCount

(sorry, can't read the name of your subform but that is what tbl_an???? is supposed to be

I am a bit confused to what Comment 4 means. what is 'sourceobject' and 'controlname'?

these are properties. In the ribbon, click on properties to display them for whatever object has the focus at the time - an object might be form, section (header/footer/detail etc) or a control. Controlname speaks for itself. Sourceobject only applies to a subform and is the name of a form, report, table or query. My bad, I meant controlsource which will be the name of a field from your form recordsource or a calculation such as used in your count control.

As far as using Welsh is concerned - interesting challenge, but the principles are exactly the same.

[jactheblock]

Right, sorry for taking awhile to relpy...

Can you simplify what you previously said in post #11? I really dont understand Access whatsoever.
What are controls?
How do i reference it?
Am i giving a name to the subform, so it replaces tbl_tanysgrifiadfisol, or is the name going somewhere else?
Where is the control source?
How do i make a new control?
I dont have properties in the ribbon. How do i get this?

Sorry for being so annoying, im thankful for all of the help so far

[CJ_London]

If you are not even aware of the basics I strongly recommend you do a couple of online courses about access to get some understanding. I can't recommend any specifically, just google 'ms access online courses' and you will get plenty of hits

To answer your questions as best I can

What are controls? - they are the 'objects' on a form or report. There are many types, the most common being textboxes and labels. Textboxes display data in one form or another, labels provide a description
How do i reference it? by its name
Am i giving a name to the subform, so it replaces tbl_tanysgrifiadfisol, or is the name going somewhere else? subforms are another form of control - it usually defaults to the name of the underlying form.
Where is the control source? in properties under the data tab (if you cannot see the properties form, click on the properties sheet button on the ribbon)
How do i make a new control? by selecting one from the ribbon and then clicking where you want it to appear on the form
I dont have properties in the ribbon. How do i get this? if you cannot see the properties form, click on the properties sheet button on the ribbon