I'm a novice and everything shown seems far to complicated just to omit a blank field from a simple table of information. Project name, amount, date paid. Just show the records that don't have an entry in the date.Help Please.

1 hour ago, Stevyb said:

Just show the records that don't have an entry in the date.

It's actually very simple. Just enter Find mode, type = (the equal sign) into the date field and press Enter or click the Perform Find button in the status toolbar. You can script this, if you need it often:

Enter Find Mode []
Set Field [ YourTable::DatePaid ; "=" ]
Perform Find []

Or just:

Perform Find [ Specified Find Requests: Find Records; Criteria: YourTable::DatePaid: “=” ] [ Restore ]

Edited 7 hours ago7 hr by comment