Is there a way to do a query that will pull out records if just one word is in the field.
I have a field that contains the names of the committees a person is part of (Education, Membership). I want to pull out only those that are part of the Education, but the field contains both words...
This is a strange question. I hope there is a way to accomplish this.
My boss wants to get a listing of all the folders we have on our P: drive (from the server) and all the subfolders so that we can see what type of hireracy we have have set up.
I'm hoping there is a way to do this so I...
I have a table with a few fields that are Yes/No which makes them True/False in the eyes of Access. When I try to use some of these fields in a mail merge I'm getting FALSE where I thought I would get nothing and TRUE where I thought I would be getting a check mark, because that is what I did...
Does anyone know if you can change the color of the shadow in one of the word art fonts in Powerpoint?
If so, how. I can't figure out how to change the shadow image of the word. I can change the foreground word okay, but not the one in the back.
Thanks
Sharon
I have been made delagate to the boss' tasks in Outlook. We are assigning categories to each task.
Is there a way to sort by category?
Thanks for the help.
Sharon
I'm trying to create an invoice where I can add up the total donations. No problem there, so far, I think.
I have the following the the subinvoice footer.
=Sum([AmountOfDonation])
My problem is when I try to show a balance due. What I need to do is take the answer from the above formula...
I have an existing database (so I can't start over) and it contains a field where the members birthday was input. It is a text field and the dates are enter 9/28/1955.
I need to create a query that will allow me to pull out all the September birthdays when I run the query in August so they can...
If a field is null when the report prints out can I have it put in a canned statement (i.e. "If you want to become a member, give us a call.")
Just an idea I was toying with
Thanks
Sharon
I'm trying to create a report that will be an invoice.
I am creating invoices for pledges (donations). My donors may have given us a pledge of 5,000 but they might wish to pay in increments. So I created a record for each date that they are planing on paying.
I need to be able to have all...
I have a form with a combo box on it. I use it for solicitors of donations. When I click on it and choose a name it changes All the records for that donor (from previous years) to that solicitor.
Can you tell me what I am doing wrong?
Thanks
Sharon
One of my tables has a field in it that looks up into another table to get the info. (i.e. Campaign Name).
When I created a form to use for data entry into that table instead of showing me the name of the campaign I see the number that associates that field with the record in the Campaign...
I have a problem with a subform. It will not allow me to do data entry into it.
I have a fund raising database. A table with donors, one with pledges, and one for the payments of the pledges.
I'm using the form with tabs to show the different data. The donor info is okay, the pledge info is...
When you use the group feature and group "with first detail" how can I tell the program to repeat the last header if the group goes on to a second page. Page header will not give me what I am looking for.
Thank you
Sharon
Is it possible to do a vlookup with an if statement.
My spreadsheet looks like this:
Name 2003 2004 2005
John "formula" "formula" "formula"
My source looks like this:
Name Year Amount
John 2003 45
John 2005 354
Mary 2004...
I need to do a mail merge with (Word) and my database. My database is a list of donations and the payments made toward those donations. I have a history of the payments and donations from 2003 thru 2006.
In my letter (Word) I need to put a history of giving over the past few years. I'm...
I have a field which is an auto number because it is a PK. I just realized it has jumped from record 902 to 34,737,892!
Is there a simple way to get it back at least to a number in the 1,000's. I'm just afraid that as I add more records that PK auto number will get way to big.
Any...
I'm attempting to modify the Events database to track fundraising. My thoughts are that my attendees are my donors and the events are the campaigns.
My question is, I have data from previous years that is currently in the GiftWorks program (ugh) and I want to export that data and somehow...
I am trying to create a donations database. I would like to link my existing member table and non-member table to this database, because I will be contacting members and non-members to donate to this years annual drive.
My question: If I create a field in both of these linked tables that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.