Search results

(Access 2003) I have a single user form that has been designed with no associated table. It's sole purpose is to collect user entered criteria then perform a database search. I have recently added a save facility so that separate search criterias can be held in an accompanying save table...

As part of a query I have the following (needs to be Access 2003 sql compatible, I'm sill wearing the learner badge!) ... Minimal Code: SELECT Main.Ax,Main.Ay, (select Astr from Afull where Avalid = Main.Ax) as AxStr, (select Astr from Afull where Avalid = Main.Ay) as AyStr...

Hi folks, I have a table of around 6000 records comprising 4 fields (A,B,C,D). - Each field can contain numbers or Nulls. - Each record can comprise all numbers, a mixture of numbers or Nulls, or all Nulls. I'd like to build a query that excludes all records that contain any number from a...