Help with expression builder in a select Query
in [Queries]
|
Prev: Access 2007 Append Query – Issue with automatically inserted brack
Next: Help with expression builder in a Query to retrieve wanted dates
From: Access Rookie Access on 18 May 2010 15:28 I am a beginer of Access. I have a database that consists of 4 columns/fields of dates. These dates/fields can be filled or can be blank. I call them A, B, C, D. Now I want to make a query or report to retrieve the date data in the column/field of A. The criteria for this: all the dates in field A must be later /larger than those in field B or C or D if B or C or D contains any value. I queried the A,B,C,D from the table that contains these fields. The first criteria I wrote is "A is not Null". But then I want to say if B or C or D is not blank, A must be > any of B or C or D. But how do I write this formula? I think to use expression builder. But still how? Anyone can look into this for me? If you need more info, we can chat more. I really need a rescue hand on this~~ Thanks!!!
From: KARL DEWEY on 18 May 2010 15:35 In design view grid -- FIELD: A CRITERIA: >B AND >C AND >D -- Build a little, test a little. "Access Rookie" wrote: > I am a beginer of Access. I have a database that consists of 4 > columns/fields of dates. These dates/fields can be filled or can be blank. > I call them A, B, C, D. > > Now I want to make a query or report to retrieve the date data in the > column/field of A. The criteria for this: all the dates in field A must be > later /larger than those in field B or C or D if B or C or D contains any > value. > > I queried the A,B,C,D from the table that contains these fields. The first > criteria I wrote is "A is not Null". But then I want to say if B or C or D > is not blank, A must be > any of B or C or D. But how do I write this > formula? I think to use expression builder. But still how? > > Anyone can look into this for me? If you need more info, we can chat more. > I really need a rescue hand on this~~ Thanks!!!
From: Mackster66 on 19 May 2010 11:08
I may be mistaken, but wouldn't that just return records where all fields have dates but A is the most recent? I wouldn't think that would pick up records where B,C, and D were null or any other combination of null values. "KARL DEWEY" wrote: > In design view grid -- > FIELD: A > CRITERIA: >B AND >C AND >D > > > -- > Build a little, test a little. > > > "Access Rookie" wrote: > > > I am a beginer of Access. I have a database that consists of 4 > > columns/fields of dates. These dates/fields can be filled or can be blank. > > I call them A, B, C, D. > > > > Now I want to make a query or report to retrieve the date data in the > > column/field of A. The criteria for this: all the dates in field A must be > > later /larger than those in field B or C or D if B or C or D contains any > > value. > > > > I queried the A,B,C,D from the table that contains these fields. The first > > criteria I wrote is "A is not Null". But then I want to say if B or C or D > > is not blank, A must be > any of B or C or D. But how do I write this > > formula? I think to use expression builder. But still how? > > > > Anyone can look into this for me? If you need more info, we can chat more. > > I really need a rescue hand on this~~ Thanks!!! |