var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Delete query
How do I set up the query when they want to delete the records that starts with the word small?
Add a column to your delete query. In this column for the field enter expr1:Mid([Field Name],1,5) now in the criteria for this column enter "small".
Field Name is the name of the field that has the text starting with small.
To check if it works make your query a select query and only records that start with "small" should be displayed. If it works change your query to a delete to delete the records.
DELETE * FROM <Table> WHERE <Column> LIKE "small*"
Have a nice day!
I tried small* and it worked. Thank you soo much. I'm sure I'll be back.