Need Null results returned also

[Scottie31]

I have a query that i run and now I am adding another column to provide a ETA for an order, when i specify a date I only get results that have that date and when I leave out the date I get too many results. Can someone please let me know how I can modify my query so that I get all the results with an ETA and also all the accounts that do not have an order placed.

Thanks,
Scott

 

[amerfeld]

I have a query that i run and now I am adding another column to provide a ETA for an order, when i specify a date I only get results that have that date and when I leave out the date I get too many results. Can someone please let me know how I can modify my query so that I get all the results with an ETA and also all the accounts that do not have an order placed.

Thanks,
Scott

Scott:
A little more info please. Are you using one table in your query or more than one? If an account doesn't have an order placed, what criteria do you need to pull that information? Does that mean it doesn't have an ETA?

Scott:
Just thought of this - try putting this in the criteria row of you field: date (your date) or is null
see if that gets you what you need.

 

[Scottie31]

I'm using several tables in my query and trying to use an "IF" statement in my expression to return a result. For this expression I am using the information from 2 tables.

Cust # INV Date Disp. Date Order Number Dispatched
52025 jan 17 jan 17 12345 Y
68859 jan 17 jan 17 65785 N

What I am looking for is in another colum to have customer # 52025 show the order number and then Null to show for Customer # 68859 as this customers order has not been dispatched yet. The other problem I have is I only want to see if the current order or next order in the sytem is dispatched or not as there could be several future orders in the system.

Hope this helps or just confirms I'm out of luck.

Thanks,
Scott