Search results

Afternoon! I've currently got a simple report with one text box in it which is linked to a query that produces a list of names which is going to be a sub-report. So rather than it printing a long list I want to order it in columns. I know that I have to use page setup to change the column...

Hi guys, I've got a report that prints out a query and looks like this: Age Group | Count Under 1 23 1 Year 34 . . And I want to add a field at the end that totals up all of count. I've added a text box to the footer and tried using =Sum([CountOfDoB]) and...

Hey guys, I'm running the following function from a query: Public Function AgeGroup(DoB As Date) As String Dim intAge As Integer intAge = DateDiff("yyyy", [DoB], Now()) + Int(Format(Now(), "mmdd") < Format([DoB], "mmdd")) Select Case intAge Case Is < 1 AgeGroup = "A) Under 1" Case 1 AgeGroup =...

Hey guys, I've got a module that reads a date of birth and puts it into the relevant age group which works fine except that I want to ignore all people over the age of 4 which is so simple yet I can't seem to do it! Here is my function: Public Function AgeGroup(DoB As Date) As String Dim...

Hey guys, I have a query that returns a long list of postcodes but rather than having a report which is 3 pages long I want to be able to break up that list into multiple columns so they can fit on one page rather than multiple pages. Is this possible and how would I go about doing this? I...

Hey guys, I'm trying to generate a report based on some queries and be able to export it to add more data into it. Seems like I can only export to .rtf which gets rid of the images and horizontal lines on the report. Is there any way I can add this data to the report in access in report view...

Hey guys! I'm currently in the processes of creating a simple database in order to create quarterly reports based on the data inside it. It's made up of two tables: Carers and Children with a one to many relationship (one carer can have many children). Below are the layouts of the tables...

Hey Guys, Now I know this should be a simple question but I'm having so much trouble with it. I've generated multiple queries and now I just need to form them into a report but I'm having trouble showing them on a report which is an unrelated object apparently. I started the report from scratch...

Hey guys. I have a table that contains data on people including their birthdate. What I want to do is to have a report that groups people into age ranges and show it in a table. I've managed to do this via a function and a query but what I can't seem to do is show the group titles if no one...

Evening All, I'm currently in the process of creating a database contains data about people. I have to produce a report that counts the amount of people that fall into specific age groups. I've managed to do this but what I also want is to show all the groups even if they have a zero count...