Recent content by Anchoress

Thanks Raman256, that's an excellent 101 suggestion. However, my data source is batches in the Raiser's Edge database, and there is no opportunity in that medium to create user-defined calculated fields. Any other suggestions to answer the question I asked?

I'm struggling to successfully create a calculation in MSWord based upon a value in a merge field. The problem may be because the merge files are stored in and run from the Donor Contact Management Database The Raiser's Edge, or because the version used is 2007. I used instructions for Word...

Hi all: I'm using Word2003. I want to be able to toggle field codes ([ALT+F9]) and then work with the result as plain text. I've tried several things: 1. Toggle to reveal the field codes then select/copy/paste special (paste as plain text) 2. Toggle to show the field codes then unlink fields...

AccessMSSQL, thanks for the info, I'll try that when I have time. It's an .MDB

Anyone? Still trying to track down the developer.

Thanks, but it didn't work unfortunately. Wish it were that easy LOL.

I work in an office with Office2000. One branch of our non-profit organisation had a volunteer design a database in Access to track the usage of rented storage bins. The database works great for its intended purpose, however the volunteer is not available and the front-end is so locked down...

Actually, I prefer to solve this problem in a way that kills two birds with one stone. In my actions table (which is for all types of contact), I have a field for the due date for the action (the 'do by' date that you're using), and also a field for the actual completed date (to indicate that...

Are you substituting your actual form name for the placeholder [yourformnamehere]?

In the criteria field, type <Now()

So it doesn't matter who gets what records? You just have a 'staff' field or something, and you want it to update X records to "Julie", and X records to "Matt", etc? I'm not an Access programmer, but I'd do it one name at a time using a range of numbers in your ID field (assuming you have one...

Hi aml5171: 1. Create a new query and select the fields you want from the parent table. 2. Add the 'group' function by clicking the Sigma symbol (like the autosum in Excel). 3. In a new column in the query, in the top row create the following expression: TITLE: Sum([TABLENAME]![FIELDNAME])...

The sticky thread at the top of the Queries forum tells you how to do exactly that.

Check my thread just below yours - Bob Larson answered my question and I'm sure it's pretty much the same for you! E2A: Duh, I am dumb. E2A2: Also, the more interesting and specific you can make your thread title, the quicker you'll get replies from the busy techs on the site who don't have...

Hi, boblarson: That's perfect! Thank you so very much!! I hope my question and your answer may be of use to others, as well!