Figure
1.1
This is how ? :
Select Item from Fields List (left side of form ) > Double click to view the value.
The value will be loaded to a listbox ( right side of form )
As shown in Figure 1.1
Double click Description, then the value of that field is loaded to a listbox
Click [Build SQL Statement] button , the Click [OK] button
Sql Statement Shows:
SELECT * FROM [CheckTrans] WHERE [Description]LIKE
'%5003:OFFICE SUPPLIES%'
The result would be something like this:
One record displayed because there is only one record with the description like
5003:OFFICE SUPPLIES
Using BETWEEN in inquiry:
Double click Date, then the value of that field is loaded to a listbox
Select from the list as show above. When you select from the list,.
the item would
go for the empty open textbox, First textbox is the default.
Click [Build SQL Statement] button , then Click [OK] button
Sql Statement Shows:
SELECT * FROM [CheckTrans] WHERE [Date]BETWEEN #7/18/2008#
AND #7/25/2008#
The result would be something like this:
Two record showed because there are two record between 7/18/2008 and 7/25/2008