Search results

Hi JHB, It works beautifully. Thank you soooo much for your time and patience I have learnt a lot. :D All the best

Hi JHB. Thank you for your reply, I have finally got the code working. So that it opens up the report. It took me a little while as I had never done this with a query before. Thank you very much for suppling the code I wouldn't have known where to start.:) What I did notice when I tried it...

Hi JHB, Thanking you once again for your reply. It is exactly what I want to achieve. I have attached a .xls of what I have done so far. 2nd and 3rd screen print is the query with the extra empty field I called this linenumber1. 1st screen print is after I have created the temporary...

Hi, I have gone a little bit further, but I am wondering if this can be done so it is more dynamic. As the report sometimes can have 3 lines of data to say a 11 lines. So by doing it the way I have in the pdf files below it leaves a gap on the page. I require the page to have 26 lines...

Hi JHB, Thank you for responding. Sorry I haven't got back to you sooner. Thank you for the example. The reason I have used this method rather than the crosstab query was that it was giving me duplicate values when inputting two cheques under the one date. Also not holding the value headings...

Hi JHB, Thank you for replying, I needed someone other than myself for a different perspective. I had created two queries this was the orginal one I was working with, is this what you are meaning? Qry_ReceiptOutputRptQ1 made "q" , 1 and then copied this and made Qry_ReceiptOutputRptQ2 and...

Re: Report Receipt Output - 3 Monthly Totals - Help Pls Hi, I was wondering if anyone can assist with this. I have finally created a report with two subreports to accomplish my first task. I now have an issue with the total the first three months is fine as they are totalling up as...

Hi JHB and Tom, I had a look at the database because I am only learning I think it could be the relationships not correctly link. But JHB might beable to better assist you I have created an .xls for JHB since he couldn't open the database.

Hi, I was wondering if anybody can assist me with this. I have a report I have created for Income as per the attached .xls. At the moment it is showing values for the whole year. What I will be doing is creating a parameter form similar to the one attached(.xls file) to select the dates as...

Hi, I have created this report for monthly expenditure the only problem is once the report is run it only fills nearly half a page what I would lilke to happen if possible is the format to fill the one page. It will never go over the one page. But it will have to adjust according to how much...

Hi Isskint, Thanking you for your time once again. :) It worked! I now have my contact report. I have attached the end result minus logo but that was the least of my concerns I didn't want to keep using the spreadsheet I was orginally using.:)

Hi Isskint, Thank you for your response. I tried centring the label as suggested it only centres to that part of the page. Yes I have gone to page setup to get this result. I have attached excel spreadsheet to show you what I have done. I would like this information to be printed on one...

Hi, I have created this list report, but I have now being trying to format it so that the report header will be in the centre of the page and also the page footer. As well as the headings of the values repeating on the other half of the page also. Name Phone Handicap 2/3H/C I have...

Hi Alan, Happy New Year. Thank you very much for your time and assistance it worked a treat.:)

Hi, I have an issue with a crosstab query. I have two tables Tbl_Main with a one to many relationship with Tbl_Expenditure as per the attached excel spreadsheet. I need to add two records with the same date as the cheques were both written on that day. But I need to record them on different...

Re: Cross Tab Query and Totals Hi JHB, Thank you for your example it got me thinking as you were saying it must be storing it as a text field and not a number/currency field. So I took a closer look at the query as I was creating it. What seems to have occurred was when I created the...

Re: Cross Tab Query and Totals Hi JHB, Thank you once again for your time and assistance I have followed what you have mention and it has worked :) Expr1: Nz([Qry_ExpenditureCrossTab].[Friday Night Comp],0) Also wondering if you are able to assist me with the below it has occurred once I...

Re: Cross Tab Query and Totals Hi, What I did first was to create a cross tab query as below, TRANSFORM Sum(Tbl_Expenditure.Amount) AS SumOfAmount SELECT Tbl_Main.Date FROM Tbl_Main INNER JOIN Tbl_Expenditure ON Tbl_Main.MainID = Tbl_Expenditure.MainID GROUP BY Tbl_Main.MainID...

HI JHB I would like to say thank you for your assistance and time. It worked! Have a Merry Christmas and a Happy New Year. :)

I am creating a report in Access 2010. What I want to achieve is that the information that is printed is to stay on one page so I would like to make two columns. Is this possible? I used this query first but it didn't seem to work. FullName:[LastName]&"...