Search results

Hi there.. I need a simple query... I want all the records to appear which have some text in that particular field. So if there is no text in that field, it won't come up. What would I need to write under that field in the query?

Hi again, thanks to all for the help given so far. Is there anyway (other than making that field a primary key) to prevent the same value being entered into a different record? E.g. If under 'Name' Radion has already been written, I want an error message coming up saying there is already a...

Hi all, I'm working on a library database for a small collection. I have two fields, 'Date Out' and 'Date IN'. Is it possible that whatever date is written for the date taken out, I can set the 'Date IN' to be 7 days later than that date? Thanks in advance.

Hi there, I'm making a database for a small library collection. I want to make a query for all overdue books, so if the Date which the book is due has passed, it will come up in the query. What do I put beneath the 'Date due' field? So If 1 day has passed that date, it will be overdue...