Search results

Hi all, newish to Access so please forgive if this is really easy. I have a database where people have answered questions to a survey. The returns are Yes No Don't Know I want to find a way of showing how many of each entries are in each question. At the moment I am exporting to excell...

I have an access database containing the results of a survey. Please forgive if this is very simple, I have not used Access much. I need to be able to calculate the numbers of each answer and present the results as a table. i.e question 1 is have your sales a, increased, b, remained constant...

Hi all, I have a database of companies that needs to be divided into sections based on the number of employees a company has. At the moment each on shows an exact number. I need a report (or querry) that will show how many companies fall into each section - i.e. how many have 0-19 employees...

Thanks, worked fine

I have database where users enter a date field when they have completed the work. I am trying to return a query that finds all with this field empty(ie, not worked on) - i have tried like "null" and this has not worked. Any help is appreciated. Thanks

Thanks the update query has worked. Chris.

I don't normally work in access so I am sure I am asking a really easy question. I have a table that is connected to a form where users enter survey data. Currently they have a drop down form to mark the responses to the survey as "Fully Completed", "Partly Completed", etc. On the table I...

I have a table of clients where the data entered relates to whether the client has "increased", "decreased" or "remained constant" in terms of the amount they have ordered. I would like to present a breakdown of the results, and so need to be able to create a total of the 3 responses...

New it would be simple, thanks for the help.

I have a database that gives lists of UK Attractions. There is a field that defines the companies on the database as either a Museum, Art Gallery or Other. It is shortened this so they enter "M" for Musuem, "A" for art gallery and "O" for other. Some of the attractions have more than one...

Replaced with commas and now working fine. Thanks,

Thanks for the help, but I am getting syntax errors. the code entered is =iif([Expr1] >=75; "A" The cursor is flashing on the ; Thanks for the advice, Chris

I am creating a query that adds up a series of numbers for each record. This is no problem and i have a column that gives this total. What I then need to do is take the final number and "grade it". i.e. if the total is between 75 and 100, the grade is "A", if it between 50 and 74 grade is "B"...

See I said it would be easy!!! Thanks for the help.

I will explain it more simply, each company in the table has a entry to show the number of employees they have. I want to create a querry that finds all the companies that have between 21 and 50 staff. Another to find those that have between 51 and 200 staff etc. Hope this helps, Chris.

Only 4: 0-20, 21-150, 151 - 500, 500+

I know this must be so simple, but I banging my head on the wall to find an answer. I have a table with a list of company details including employee numbers - this is a number not a range. I need a query to produce a list of the companies up to 20 employees (easy use the < option) and then...