Search results

RESOLVED: Date()-1 excluding Weekends I have a query that pulls data from a Due Date column based on the date. I want to see what I missed from yesterday. However on Monday it shows me Sunday. I want it to instead skip Saturday/Sunday and use Friday if it is Monday but I cannot for the...

Never had much luck with the charts in Access, what better time to learn then now? I have a query that in Column A: has a sum of the number of phone calls and column b has the total number of times the phone call had documentation logged, I want to take and compare them in a pie chart but when...

I've searched Google but to no avail (maybe I'm not not being specific enough) but I have a form with a textbox with a default value of "Input # Received" and an input mask for a 3 or 4 digit number, what I would like to have is when a user clicks the textbos the "Input # Received" clears and...

Is it possible either by macro or VBA to import an excel document that is on a FTP site. We have a report that is ran daily that is in Excel, I take the report and add the new information to a access table, then link the excel doc and run an update query to update all the records. Currently I...

I'm new to these forums so I apologize if I'm posting in the wrong section. I'm running multiple reports that I print to PDF using a freeware PDF printer (PDF995). These reports are ran on a weekly basis and will always be merged into one document. Currently what I have setup is a macro to...