Recent content by JasonM

Jdraw, thanks for the feedback. I had started the query, but that also seemed like a lot of duplicated effort. I really appreciate the input though! I think I will try Galaxiom's suggestion below. If that does not work, I will recreate the entire report. If that still doesn't get it I will go...

Thank you very much for your reply! I guess what I am looking for is confirmation that the function used: nz([FieldName],"---") should not cause a problem when used as a control source. It looks like the the data is from another field in the record set. I have checked and double checked the...

I have a funny problem that I have not experienced previously and I cannot seem to find a work around (at least an easy one). Perhaps someone here has seen something similar. I am using the following control source for a text box on a report: =nz([Raw_Turb], "---") When I do, it pulls data from...

Good afternoon everyone! I have a problem that has been vexing me for a couple of weeks now and I thought that someone here might be able to point me in the right direction. I have created two "reports" that are basically data collection worksheets that the user logs data into over the course...

Paul, Thank-you. I guess I have never run into this problem, or have found some other work around. The articles referenced were a tremendous help! Thanks again and happy holidays. Jason

Good morning everyone! I have been using Access 2003 for quite some years and I believe that this works in that version. My employer has recently updated to 2010 (I know... They are always on the cutting edge LOL). I have a select query that collects data and summarizes it and then a transform...

Thank you for your reply. I think I have come up with a similar solution that you have listed, but I had to restructure my data with an additional Query. It works, but it is a bit clumsy. What I have is a Query (based on two other queries) that returns data structured as follows: SampleDate...

Good morning! I am struggling with calculating a value for a report in Access. I have tried multiple methods, but I think I am overthinking the problem. I have a report based on a query. The report is grouped by Location. Each Location has a test result for each of 4 quarters. In the location...

The footer simply uses the average function =min([field name]) I cannot see any way with how the report is constructed that will allow for that. Perhaps I can create a crosstab query from qryDisinfectionProfile_2 to group the needed data by month... That way I would only have "one" result per...

Trevor, thanks for the reply. Here is some of the requested info. I am currently working in Access 2003. The screen shot tries to illustrate what I was asking... The Query SQL is as follows: qryDisinfectionProfile_1 BEGIN SQL SELECT CT_ALL.CTDate, CT_ALL.C, CT_ALL.T AS PlantTime...

Good afternoon all! I am wondering if I am going about my problem incorrectly, perhaps someone here can offer some advice to get me back on track... I have a report which is grouped by year and by month. I am displaying monthly averages for three fields as well as annual average for each of 5...