Recent content by thocutt

Hi! I am generating a report of Supplier Statistics where I want to know how many shipments are more than 3 days late per Supplier. I have been trying to implement the DCount function to do this and it works for the Entire Report Summary, but not for the Supplier by Supplier Breakdown. I am...

Here is my e-mail code. rtf or rich text formatting does not import picture files such as lines and signatures. Did you try HTML format? You may have to tweak the report a bit, but HTML format may send pictures. Good luck. Private Sub MailChangeNotification_Click() On Error GoTo...

Oh my gosh! It worked! At first I put the functions in the report's module and it wouldn't recognize the function (because it pulls from the query?) but then when I created a module and put the functions in there it worked right off the bat! This is great. I really appreciate your help with...

OK, I think I'm getting a bit closer. I changed a record to exactly one month ago and it showed up, so great! The only problem is I want to show all the records for that month. Any ideas?

I pasted what you replied underneath my Date Field in the criteria box, but I got zero data returned when I looked at the report even though I do have fields for November. Any guess as to why this is happening? I'm not real familiar with this yet. Thanks for the response.

Can you be more clear on this? I've been trying and I can't get it to work. I'm not sure if I am doing the right thing.

Another possibility is to open your report and file/send as Excel File and then send it to yourself and then just spruce up the excel file when you receive it. Just an alternative.

Can't you just go into your design view on the report and go to file/page setup/page and select 8 1/2 x 14? Is that not working?

Hi All. I am having a problem figuring out how to filter my reports by previous month. I have a table of data and as each month comes we do a report on the data for the previous month. Every month I go into all my queries and say Like "11/*/00" under the DATE field. I know there is a way to...