Recent content by MrCee

Hi All I want to create a query which is based on two fields. One field is a date query i.e >=Date()-7 OR >=Date+7 The Other is a Combo box where the criteria is No My problem is that access is currently running this as two individual queries. Is it possible to make this query return data...

Thanks Thanks for your help guys, that sounds like a much easier way to do this.

Delet query problem Hi Neil i have had a look at update queries but cant see a way to make it happen from there. I will try to be a little clearer in what I need. I have a Table which contains 6 fields. For the purpose of this explanation i will have the fields numbered 1 to 6. I want to...

Hi I need to know if it is possible to create a delete query which will target particular fields in a row based on certain criteria in a seperate combo box(on same table). The few ways that I have tried to do this have been unsuccesful so if anyone can shed some light on the subject it would...

Hi All I am very new to Access and currently experimenting with setting up basic database. I need to search for a record with a unique indexed number (no Dups) via a command button on my main form. Ideally the search will then take me to the corresponding row displayed in a sub-form. I would...