Search results

That's very nice of u to help with the prompt. I needed help on that as well for being a total noob at VBA lol. Although it would be even better if it executed itself on opening the report without the prompt. Thanks alot :)

Wow u are a lifesaver. That query is just what i needed. I dont mind the temporary table, i can just overwrite it everytime i need to run the report. Thanks alot man! :)

Ah yes!! That line break is just what i wanted. Although i think the function to group them is a better solution. This line break works out well for me now while i figure how to do the function. Thanks alot for the help!

So the idea is, I have to use this function to assign a temporary group ID to the records so that Access group the report based on these temporary group IDs?

Thanks for the reply. I have thought about it but I can't assign a group ID to the entries because I intend to make this log so that a user can go to any date and slot in a record. Having group IDs would break the integrity of the grouping if a user wanted to open a new group in between an...

Hi everyone, I have a table called tblEntries which is a simple log table. I want to create a report with a custom date range for each group. Each group has an irregular interval so i have created a field called "OpenNewGroup" for the user to specify if the entry belongs in a new group. I...