Recent content by JillWelch

  1. J

    Problems getting a sum in my query

    I have a query that lists information for each contributor including the amout they have donated. What I want is a field that will give me a total amount of donations for each person. Right now, I'm getting a list that shows each contributor for each occasion they donated instead of a total...
  2. J

    Need a query that totals donations from each individual

    I need a query that will give me a total amount donated for each person. Right now, it lists Suzy Q. $5 Suzy Q. $10 I need it to just list, Suzy Q. $15 Anyone know how to do this? Thanks
  3. J

    Set rules for what can be entered into a box?

    Thank you!! One more question, where do I enter this code?
  4. J

    Set rules for what can be entered into a box in a form?

    I guess I could, but would like to find a different way...I'll use that if I have to though. Thanks
  5. J

    Set rules for what can be entered into a box?

    I have a form that I can enter addresses into, what I would like to do is make sure that in the State/Province box that only two letters can be entered, and I also want it to automatically capitalize the two letters. I need to eliminate typos in this box because l will be using this data later...
  6. J

    Please support these forums

    I will also put the links on my page, although it doesn't get many hits. I don't know what I'd do without these boards :)
  7. J

    Set rules for what can be entered into a box in a form?

    I have a form that I can enter addresses into, what I would like to do is make sure that in the State/Province box that only two letters can be entered, and I also want it to automatically capitalize the two letters. I need to eliminate typos in this box because l will be using this data...
  8. J

    Text Boxes

    Maybe try resizing the box? I'm not sure, but sometimes if my box isn't big enough all the stuff I want to show doesn't until I make the box bigger.
  9. J

    need help with school assignment on access!!!!!! please!!!!??

    I will probably not be much help at all, but I will take a shot in the dark. I looked in my beginners access book and it gives an example of how you can get things into one field. The example it gives is if you have two seperate fields called FirstName and LastName. it says you can type...
  10. J

    More help needed with report that starts up with a form

    I asked for help yesterday and appreciate the advice I got. However, I am still having a bit of trouble and need some clarification. I have a report that is working correctly. It lists contributors and date donation was made for fundraisers 1, 2, and 3. What I want is a box to pop up (before...
  11. J

    Report trouble

    Thank you so much for your help!
  12. J

    Report problems, I need it to sort by date and number

    I'll work on that. Thanks for your help.
  13. J

    Report problems, I need it to sort by date and number

    I tried this, but it didn't work. Now the report shows up blank where it used to list things. Maybe I did something wrong. I went to the query that my report is based on. In the Criteria field for Fundraiser number I clicked build, then reports, then all reports, then selected the report I...
  14. J

    Report problems, I need it to sort by date and number

    I have a report that is working correctly. It lists contributors and date donation was made for fundraisers 1, 2, and 3. What I want is a box to pop up (before I see the list the report gives me) so that I can enter the fundraiser number and the year the donation was made. For instance, I...
  15. J

    Report trouble

    I have a report that is working correctly. It lists contributors and date donation was made for fundraisers 1, 2, and 3. What I want is a box to pop up (before I see the list the report gives me) so that I can enter the fundraiser number and the year the donation was made. For instance, I...
Top Bottom