Recent content by stu_gnu

Hi You could try running a query and use the following coding - Select[Your table name].[Your column name], count(*)As Numberof FROM [Your table name] GROUP BY [Your table name].[Your column name] this should hopefully give you the figures that you require. All the best Stu

Hi I'm currently working on a database of which the main question centres around whether a person has used a certain product or not, with the response being either Yes or No. I have managed to create a query which counts how many people said yes and how many said no. However I've been...

Not to sure how to work this formula Pat, could you give me a few more hints please? thanks Stu

Hi Keagan sorry for not getting back to you sooner. However with regards to my problem with percentages want I want to do is find out the percentage of people in my survey who have answered yes or no to whether they have bought a certain product or not. I currently have 200 records in my table...

Hi Is it possible in Access to create functions which can calculate percentages and other statistical information based on the data contained within a database.

Hi I have created a form which enters data into a table as a user types in the required data, within the form there are two combo boxes. The first combo box contains a list of enquiry types which a user can select from. The second combo box contains shortened enquiry type codes which relate to...

Hi I have created a form on which I have removed and then readded the autonumber tool for my ID field. Unfortunately my ID fields now run from 8 to 27 instead of 1 to 19. Is there any way of resetting the autonumber function so that my ID numbers run start from 1 again? please help, thanks Stu

Hi I want to enable the fields in my form so that on entery they change colour is this possible to do and if so will I have to enable each field individually or can I do them all in a group.

Is it possible to programme a form, so that once a user has passed through a field without making an entry, the fields show the word N/A.

Hi I am currently working on a form of which part of it is split into two sections. Is it possible to programme the form so that when one of the sections is selected the other section's fields are greyed out and disabled or restricted. cheers Stu