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 July 21Jul 21 by comment

Thanks for the support I seem to have cracked it now thank you