Recent content by DurhamCons

Thanks for your help. :confused:

I have a report that shows commissions over a certain payperiod. In this report, I have created a subreport that shows the YTD totals. My boss wants to implement a bonus structure that will be tied to an average daily sales over the current quarter. Currently, my query and report structure...

Thank you sir! I appreciate your responses. My roommate figured out that my query was confused (had two fields name the same thing in two different tables). Once he fixed that, my query worked. :D Here is what I used for future people who might find this searching.... Function...

Thanks. I already have that in a module. I'm just not clear on the syntax for "the 1st of the year." Maybe I'm not understanding something? :confused: Thanks of the reply. :D

DateDiffW(DateSerial(DatePart("yyyy",Date()),1,1),(Now())) I'm trying to reference a DateDiffW module to calculate the number of business days from the first of the year to the current date.

Thanks. I have already searched the forum several times and found plenty code for modules. I just don't know how to make them work with my reports. I'm new to the site but not new to message forums so I know better then to ask a question without searching first. :D For this report, we don't...

I did this... And got Error 13: Type Mismatch...

Here are my questions... hopefully this will spark some more involvement from others... In that function, it appears to me that it is assumed my start date and end date are stored in a table. This is not the case. As you can see from my screenshot above that I used an expression for the query...

How? :D :D :D

Thanks for the tip. I changed that field to JOB_DATE in an effort to prevent any problems. So, can I still use what you suggested since the date is not saved anywhere? Is it a good idea to save that information in another table? Your help is very much appreciated! :)

Thank you very much for taking the time to help me with this. This is the first DB I've created from scratch without any previous education on Access. I'm a bit confused regarding the expression I put in the query. It seems to me like it assumes my StartDate and EndDate used to generate...

THANK YOU THANK YOU THANK YOU I searched this and other forums trying to find this answer. All of the replies were with VB code or some fancy way to do it. That worked perfectly and was easy for us newb's. Thanks! :D

Thanks, I may have found that one. Now the question is... what do I do with it? :D

I have searched the forums for an answer to my question and haven't found one that I'm competent enough to make work. :eek: :D I would like to display the average sales per day. I have a report that uses a query which prompts for [Start date:] and [End date:]. I'm having a difficult time...

Thanks for everyone's help. Working through the idea, we found an alternative means to offer incentive that will be much easier for us to work with. Thanks again guys/gals.