Search results

Bob, I got it to work by putting this in a query: SELECT Payment_Pending.*, DateDiff("d",[Invoice_Date],Date()) AS Age FROM Payment_Pending But out of curiosity, how do I go about getting the form bound to the table? Thanks for all your help man.

Thanks again for your help Bob. I did try putting in the control source in a form text box and got this: #Name? I'm attaching the file, maybe you can see what I'm missing.

Thanks again for your time Bob. I'm wondering if where I'm putting this code is the right place to begin with (in the table, in the Age field, which is integer number data type). I put this: =DateDiff("d",Date,[Invoice Date]) And got this error: Could not find field 'Date'. Then I put...

Thanks for replying Bob. So you mean to write it like this? =DateDiff("d",[date],[Invoice Date]) Because that didn't work for me.

Hey guys, I'm just getting started with Access (Ver 2002 - 10.5 - SP3) , so I don't know much at all. I'm trying to do something I know is very basic, but I'm having a lot of trouble: I have a field in a table called Invoice Date (format is short date) that is manually entered. All I want to...