Recent content by lilmosweet

Hello, I have a Database task to take the value of one field and check if they are the same, if they are the same then return the value of another field value at the smallest or minimum value indicated or null. Can you help me with this one. I tried to use the IIF formula but I run into a...

Thanks! You are the best! Have a great weekend!

I have a Date Parameter set up in my query for the user to input the start date but I need the result to return only 60 days after the input start date from the user. How do I achieve this in my access query? Thanks!

Thanks John again, yes it is up and running. I was busy building the form for the buttons for the macros - blah, blah, blah but the critical part is complete. The Status Code is grouped and they want to see the Due Dates in the Oldest to newest order with null value at the end of each...

It worked!!!!! Thank you John! Michele

This did not work however I know that 0 is the null value and 1 is for not null. Is there a way to sort the null value dates to the bottom of the ascending DUE_DATE order in my query? This is the last part of my database that I need to complete.

Thanks - I'll give it try. It sounds right and I was wondering about the 1 & 0 and how to use it. I welcome all responses since I have tried everything I could think of today :)

Hello, I'm new to this but I have a challenging Database Project. I need to sort the DUE_DATE in Asc order grouped by each Status Code sort but the null values in DUE_DATE have to be at the bottom. I have everything done except I cannot get the null DUE_DATE to sort to the bottom of each...