Search results

Works a treat, cheers mate :) :) :cool:

i get a syntax error, i've attatched a screen dump of it. edit : this is the SQL i have SELECT [Staff Details].[Staff Name], [Staff Details].[Staff Grade], [Mandatory Lectures].[CPR retrain date], [Mandatory Lectures].[Fire lectures retrain date], [Mandatory Lectures].[Manual Handling retrain...

where would that go in thew SQL? i have SELECT [Staff Details].[Staff Name], [Staff Details].[Staff Grade], [Mandatory Lectures].[CPR retrain date], [Mandatory Lectures].[Fire lectures retrain date], [Mandatory Lectures].[Manual Handling retrain date], [Mandatory Lectures].[Blood Protocol...

Another question re : searching by month only Sorry about this guys, got another question to ask :) Im trying make a query, that will produce a report of anyone who has a date in their record that = the month and the year of the current date (i.e todays date). Theres going to be 8 date...

DateAdd("d",7,[Forms]![teste]![CPR retrain]) so that CPR retrain = the date. that works, but only if i put the date in the table -7. I.e if i was looking for the 12/12/2001, i need to put in the 05/12/2001 for it to find anything. I want a range from the date entered, upto a week after it. I...

just did a search and found this, its what i need, but im not sure how to use it? where does it go? I need it +7 days tho. Cheers

i know how to design a query, just not one like this :( i was trying to get [Forms]![search]![List19] so that the field wud b what ever the choice in the listbox was...

Been fiddling with this for 2 hours this morning, still cant get it working. im getting desperate now :( Heres a link to my database, its too large to attatch. http://shepz.pwp.blueyonder.co.uk/staffdatabase.rar

right ok, in the query where it says field, i have a blank column with [Forms]![search]![List19] in. then in criteria i have Like "*" & [Forms]![search]![Text2] & "*" . im guessing its the like thats messing it up, but i dont want to loose the ability to ignore the field if its left blank, which...

im not sure i understand what your saying. My query for just text string looks like this Like "*" & [Forms]![search]![Text14] & "*" how wud i adapt it to work for the combo + text idea?

Currently i have a table with 4 types of training, and a date that the member of staff needs to go on re-training. CPR Fire Lectures Manual Handling Blood Protocol im going to use a combo box which will contain those items, and a text box will be used to input a date. I need to make my query...

Argg need to ask another question now. I need a combo box and a text field to be linked, so that say if CPR is selected, and a date entered, the query will search the database for the CPR field with that date. Ne ideas?

Found another solution. Like "*" & [Forms]![search]![List22] & "*, seems to work fine. If all the fields are left blank, it displays all the records in the table, but thats what i want :D Cheers for your help any way guys :)

I currently have a form with 2 text boxes, these text boxes are linked to a query. If i enter search criteria in both boxes, and a record matches that criteria then it works fine, however if i leave a box blank it doesn't find anything. It because its looking for a record with the first detials...