Search results

I can't seem to get what you said in your last post to work. Why would you be adding the Adult/child fields to the ztblEthincOrigin table? Should they not go in the query? When I put the functions in the append queries they don't alter any data at all :(

I'm trying this on the database with real data on (which is why I can't upload it). The detail section is the same size as the text box now. I've tried using the settings with 5 columns, column width and height are the same as the text box/detail size and I'm still having no luck! I know this...

Done. Now I can't even see any postcodes!

I've created a new report and created a single text box that is 2cm wide. The report is 20cm wide and I've set it to 3 columns 3cm wide with a 1.2cm column spacing and it still prints all the postcodes in a single list. Can't understand why it won't do it!

Here we go :)

Tried all that! Here is an attached screenshot to show my settings which are not working. Maybe it is because the text box is so long? I can't seem to resize the PostCode textbox without cutting off the text in the page header.

That doesn't seem to work :S. The report still display the query results in a single list.

I'm exporting from MS Access and wanted to export it to word so that the user could add in any extra information they wanted to use before printing it but I seem to only be able to export to .rtf which doesn't include the logo I've used. Might be easier to use a form to add the additional data...

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...

Cool! What I really need to try and do though is have the table as follows: Ethnic Origin | Adults | Children and have all of the ethnic origins listed even if no one falls into those categories. What you have done is a great start though so thanks!

Here is the blank database. I've had to add an extra field so I can run a query to count the amount of men that have accessed the services in the quarter.

Yes I will upload this evening as I am currently at work and don't have it with me. Thanks for the suggestions so far!

The only problem I can see is that I'm trying to get the ethnic origin from the CarerEthnicOrigin and PartnerEthnicOrigin fields that need to be combined to form the adult group and then I will have to get the ethnic origin from the Child Table.

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...

Most of them involve counting a single field and then grouping by whether a boolean field is true or a text box contains data so I suppose I could create a query that counts the single field then sub queries from that?

So even though each query is returning me a single number I still have to use a sub report for every single query?

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...

Here is my current query: SELECT Count(Child.DoB) AS CountOfDoB, AgeGroup([DoB]) AS AgeGrps, Child.AccessedThisQuarter FROM Child GROUP BY AgeGroup([DoB]), Child.AccessedThisQuarter, DateDiff("yyyy",[DoB],Now())+Int(Format(Now(),"mmdd")<Format([DoB],"mmdd")) HAVING (((Count(Child.DoB))<>0) AND...