'blank' row separator between different groups of dates (1 Viewer)

dd*

New member
Local time
Today, 12:14
Joined
Nov 17, 2020
Messages
15
Hello, I'm not sure which forum to post this thread in, please point me to the right forum.

I'd like to achieve the following, pls let me know how I can do this.

I would like a 'blank' row separator between new data sorted in a specific order
I would like a 'blank' row separator between different groups of dates. The 'blank' row has a column to display the new date.

The data is
1. data sorted in a specific order
2. date - the latest date first
3. Title/name in alphabetical order. The titles can have the same dates


For example

1. Date Unknown
2. 10/10/2020
3.A
B
M

1. Date Confirmed
2. 20/10/2020
3.C
F
L
2. 2/11/2020
3.A
D
L
2. 1/12/2020
3.C
L
R

1. On Hold
2. 01/04/2020
3.G



I'm working with 2 possible options
1. continuous form, or
2. split form - datasheet on the bottom


TIA
 

Pat Hartman

Super Moderator
Staff member
Local time
Yesterday, 21:14
Joined
Feb 19, 2002
Messages
42,981
A form is not a report. It doesn't have break options. Use a report to display the data if you want it formatted like a report.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:14
Joined
Oct 29, 2018
Messages
21,358
Hi. Maybe you can use a Tab Control instead of "blank rows." You can display each group of records in separate tabs.

Just a thought...
 

Users who are viewing this thread

Top Bottom