adding blank rows to a table

[Guest]

I need to set up a report in a way that shows 3 blank rows followed by 27
actual entries (as a pattern for the whole table).

Is there a way to do this using an update query?

 

[Guest]

I need to set up a report in a way that shows 3 blank rows followed by 27
actual entries (as a pattern for the whole table).
Spreadsheets have blank rows but not database tables. The blanks in a table
will probably all lump together either at the top or end.

Do what you want in a query - search on grouping, numbering, and ranking.

Is there a way to do this using an update query?

No it would need to be an append query.

 

[Joseph Meehan]

I need to set up a report in a way that shows 3 blank rows followed
by 27 actual entries (as a pattern for the whole table).

Is there a way to do this using an update query?

You need to set up your report to do what you want. Tables just store
data, they don't keep empty spaces or even keep the data in any specific
order.

Using a report, it would be easy to have what looks like three empty
lines.

 

[Guest]

The following as the report's module should do it:

Option Compare Database
Option Explicit

Dim i As Integer, n As Integer


Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

n = n + 1

If n <= 3 Then
Me.NextRecord = False
Me.PrintSection = False
Else
i = i + 1
End If

Select Case i
Case 28 To 30
Me.NextRecord = False
Me.PrintSection = False
If i = 30 Then
i = 0
End If
End Select


End Sub


Private Sub Report_Page()

i = i - 1

End Sub


Ken Sheridan
Stafford, England