Search results

Well, that's a relief. Thanks!

That didn't work. I even replaced null with "". Both detect the null/empty rows but don't update them. But this, i think is serendepity, leading me to the venerable Nz([Number alive], [Number of offspring]). One thing noticed though is that although Nz() detects null, MS Access displays You...

[SOLVED] Autopopulate empty fields with values from another field. I have a table which contains data on Number of offspring and Number alive imported from an Excel spreadsheet. Number of offspring always contain value while Number alive is sometimes empty. I would like an empty row of Number...

@arnelgp, thank you very much. That is one elegant solution to my problem. It took me quite the time to analyse your code and incorporate it to my DB, but it was worth it.

@arnelgp, sir I incorporated your code into my original database, so it shares the same code, Union Query, etc. as the one you sent. I am not able to post screenshots in this forum so I attached it in the ZIP file. The db you sent shows that the Footer text box only displays data when all the...

@arnelgp, sir I studied the code and it turned out the problem is caused by one extra ",". It is fully working now. One thing I noticed at your code is that the footer data only displays when all the page rows are filled with data, but on pages in which some of the rows are empty the footer is...

@Uncle Gizmo. Yes, Sir, I'm aware of it. I am using the page footer to calculate the page totals. The problem is when there are few records in a group, it leaves a huge blank between the last record and the page footer. Now when I try to use the group footer for the total, some groups span...

Hi, Sir arnelgp, I have created a new thread (access-programmers.co.uk/forums/showthread.php?p=1629813#post1629813) (I'm not allowed to post links yet), as you suggested and attached a condensed version of my DB. I tried copying the code from your padline but doesn't work. Maybe because I used...

[Solved] Adding Blank Fields to a Report Hi. I have grouped my records so that each group will be printed separately. However, some groups have fewer records than others. Other groups span two pages when printed. I would like to add blank fields to a report so that when printed. Each group...

Hello Sir arnelgp. Could you please explain how that works. I have been wanting to do that. Searched the internet the whole week but the common suggestions are either to use union query or adding blank records. I tried downloading the raw file and the one you edited but I couldn't get mine to...