A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Help with expression builder in a select Query



 
 
Thread Tools Display Modes
  #1  
Old May 18th, 2010, 08:28 PM posted to microsoft.public.access.queries
Access Rookie[_2_]
external usenet poster
 
Posts: 2
Default Help with expression builder in a select Query

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!!!
  #2  
Old May 18th, 2010, 08:35 PM posted to microsoft.public.access.queries
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Help with expression builder in a select Query

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!!!

  #3  
Old May 19th, 2010, 04:08 PM posted to microsoft.public.access.queries
Mackster66
external usenet poster
 
Posts: 63
Default Help with expression builder in a select Query

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!!!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.