Search results

I am attempting to create a report that breaks down a field of 'ID' numbers into groups of x. In the sample report below x = 12 and the report will apportion the first 12 'ID's to the first page and textboxes with extra large fonts will signify the start and end of 'ID' numbers for that page...

Hi all, I've tried the ‘is null, '=0" and ‘nz’ routines on the Count(Tablename.Fieldname)'s, but can't seem ‘to get them to output a value of 0 in the null fields. I must be doing something wrong. Any and all help would be very much appreciated. Thanks much, aldo

I have a report that prints blank serialized forms and I basically need a query to generate a field where if I request 4 sheets to be printed the list generated would look like this: IDNo 1 2 3 4 -aldo

I have the following code entered on a subform:Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.Verify = -1 And Me.Status = 0 Then Dim strMsg As String strMsg = "This account has not been updated." & Chr(10) & Chr(10) & _ "Do you wish to update the account now?" If MsgBox(strMsg...

Is there a way to set up a query/report to display rows numbered 1 to max(AccountSize) and display the Count(AccountSize) that match the row number even if they are zero quantities? I'd appreciate any help I can get. Thanks much, aldo