Search results

Every time I use the build tool in a query my quotes do not display correctly so my formulas do not work. When I type a quote it appears slanted like italics. It is an inconvenience. Anyone seen this before? thanks

I think I am all set - thanks for your help!

How would I compare different results that were grouped in sub-reports. In the main report I can only compare the text box field but how do I distinguish between each grouped value displayed as one text box in the page footer? thanks

got it working - thanks all

I tried a comma and a semi-colon. I use commas for another macro in another DB and it works fine. Could it be that I am running 2 run code processes before the send object in the macro?

Access Version 2002

This is all I can provide I am in a secure industry - so here are the designed reports. thanks again!!

I have 5 e-mail addresses in the TO: line and two in the CC: line. When I run the macro it only sends to the last e-mail in each line?? I have never seen this before?? HELP :confused:

2 reports are inserted into a new report to be viewed as one on top of the other. I am trying to place a formula in the report footer comparing each related field from each inserted subreport. Both reports have numbers but it does not work?

I have one report which shows a 2007 results subreport on the top and followed by a 2006 results subreport. I want to compare trends with formulas but cannot get it to work. Example: I inserted a text box and typed (total from 2007 subreport/total from 2006 sub report)-1 to get a percent...

I am trying to send a query to 3 e-mail recipients using send object in a macro. I use the TO: line and separate each email with ; For some reason, it only emails the last email on the list? I am using Group Wise 6.5 help

I get it now thanks everyone!!

My detailed textbox with the formula is named test1. I sum([test1]) in the month footer box and then a prompt appears. I thought this would be easy. argh :-)

I have month, product and count of product in a report. It is grouped by month. The product count is summed in the month footer. I added a 4th column that does a percent of total by each grouping interval which is month. My formula works fine for the detail section but when I try to sum the...

Thanks to All!!!! I used ("UserName") and it worked!!! You are the best!

thanks - one other question since I am pretty poor at VB. Do I paste this in the current VBA code that GHUDSON provided. below is his code which is really niuce Public Function Audit_Trail() On Error GoTo Err_Audit_Trail 'ACC2000: How to Create an Audit Trail of Record Changes in a Form...

I just used this and it works great ghudson! One question though: We share the DB on a network drive. All users are recorded as "Admin" in the audit trail field. Is there a way to pull the windows user name for each user? thanks!

I am used to using better reporting tools like Cognos or BO. How can I easily insert sums and percent of totals in reports based on groupings? Everytime I try to place in a function I get the parameter box to pop-up? thanks!!!!

How many nested iifs can access handle in a query..

thanks Wayne I just fixed it! I clicked on default settings for the "open with" in the folder option portion of "my computer" and it fixed the issue. Not sure how messed it up in he first place. thanks to all! cheers!