Search results

Bob, I apologize for that. Is it not possible to create a brand new query called "Locate by Outstanding Days" and build a report off that (It would be called the same thing)? If so, I am having a hard time building the query for the new report. Is there a simpler way of achieving my goal...

Bob, Thank you for posting the following statement. I was able to get it to work once and I forgot to save it and now I cannot get it to work anymore. I have tried for two hours. I am uploading my Database. Feel free to take a look if you wish. Field 1 is Date Rejected and Field 2 is Date...

What if [FieldName2]) is open meaning a date has not been put in the field because it is still open. I have Invoice Recieved as a field 1 and Invoice Processed as field 2. Field 2 is more than likely to remain open a lot of times but I still want the DateDiffer to tell me how many days the...

Hi all, I have built a database for my work and I have been trying to figure out how to write a formula to tell me how many days an Invoice is outstanding? The formula will be written inside a Report Field After I have this formula I will be creating a report based on all Invoices that are...