By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,488 Members | 2,545 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,488 IT Pros & Developers. It's quick & easy.

Creating a filter query

P: 6
I have a date field in a certain query. I am creating a advanced filter Query to search one date less than another. I was able to accomplish this. The problem I am having is the blank data fields. In my table the field has dates but a few blanks. I am trying to query a date less than another date or a blank. I am having trouble pulling the blank items in. How do I get a query to filter by blank fields also?
Jan 12 '12 #1
Share this Question
Share on Google+
7 Replies


NeoPa
Expert Mod 15k+
P: 31,186
Without the SQL of your query your question doesn't make enough sense. The SQL's always a good idea to post so why not do that and we'll see if we can work out what you meant to ask.
Jan 12 '12 #2

P: 6
I in the Advanced filter section design view. For example
field: Asset status report date
Table: Special Servicing loan query
Sort:
Show:
Criteria: < [Most recent Special servicer transfer date]
or: ???? this is where i want to also search the column for blank fields
Jan 12 '12 #3

NeoPa
Expert Mod 15k+
P: 31,186
From the Design view select View | SQL. Copy and paste that SQL into a post here and we'll have some clues to work with.
Jan 12 '12 #4

P: 6
Expand|Select|Wrap|Line Numbers
  1. SELECT [Special Servicing Loan Performance Filter].[Asset Status Report Date], *
  2. FROM [Special Servicing Loan Performance Filter]
  3. WHERE ((([Special Servicing Loan Performance Filter].[Asset Status Report Date])<[Most Recent Special Servicer Transfer Date] Or ([Special Servicing Loan Performance Filter].[Asset Status Report Date])=IsEmpty("«varexpr»")));
Jan 12 '12 #5

NeoPa
Expert Mod 15k+
P: 31,186
Try changing that to :
Expand|Select|Wrap|Line Numbers
  1. SELECT [Special Servicing Loan Performance Filter].*
  2. FROM   [Special Servicing Loan Performance Filter]
  3. WHERE  (Nz([Asset Status Report Date],#1/1/1900#)<[Most Recent Special Servicer Transfer Date])
Simply copy and paste from this page into your query in SQL view mode. When you switch to design mode it should show how the new version looks.
Jan 12 '12 #6

P: 6
This worked well. Thank you for your help.
Jan 13 '12 #7

NeoPa
Expert Mod 15k+
P: 31,186
Pleased to help Yanni :-)
Jan 13 '12 #8

Post your reply

Sign in to post your reply or Sign up for a free account.