Search results

  1. S

    Word document in a report

    I have a form letter that I send out each month to parents of my students. How can I make this a report in my database and have the info drawn in from the database (ie..students, name, date of birth, etc) Each of these fields are in my database
  2. S

    name change

    I am using access 2003 and have a database with over 1500 rows I have many queries and reports relating to this database One of my agencies changed their name and I want to know what is the best way to change the name in the whole database, including queries and reports
  3. S

    rotate text 180 degrees

    I'm using msaccess 2003 and I am running a conference and want to make place cards in front of each guest. I want to fold the place card in half so it stands up. Wanting to bring in the field "Name" from my database, I'm looking for a way to print the name on the card. I will need to make a...
  4. S

    chart in a report

    I'm using access 2003 I am trying to insert a chart into a report When in design view it looks right (pie chart for example has all the sections and they are colored) when I switch to the regular fiew, the cart is either completely blue with one line or all you see is the chart title Any...
  5. S

    error message

    I get an error message when I open access 2003 database "database contains a missing or broken reference to the cacview.ocx version 1.0 All help so far says to go to tools>references. My tools in the help menu does not have references anysuggestions
  6. S

    query help

    I have a database with election data and each time a person votes it is a new record (I didn't create the database) How can I query it to find out who voted in 2004 but not in 2002 etc. I'm using access 2000 Thanks
  7. S

    query help

    I have a database with election data and each time a person votes it is a new record (I didn't create the database) How can I query it to find out who voted in 2004 but not in 2002 etc. I'm using access 2000 Thanks
  8. S

    partial data

    I have a form where I enter the students lastname, firstname I need a field that just pulls the first 2 letters of the lastname as well Is there an easy way to do this
  9. S

    partial data

    I have a form where I enter the students lastname, firstname I need a field that just pulls the first 2 letters of the lastname as well Is there an easy way to do this
  10. S

    partial data

    I have a form where I enter the students lastname, firstname I need a field that just pulls the first 2 letters of the lastname as well Is there an easy way to do this
  11. S

    error

    When I try to import an excel file into my access 2000 database, I get the following error message "an error occurred when trying to import... the file was not imported
  12. S

    format

    I am workling on a report in access 2000. I have a report on the kids in my group and one of the groupings is by age. I have age ranges such as under 10, 11-12, 13-15 etc In my report I count the number in each group but the weirdest thing happens. I inserted a chart and the legend comes up...
  13. S

    range

    I have a report with students ages ( 10, 11,12,13,14,etc) I want to make a report angd have an age range like (0-10, 11-13,14-17 etc) How is the best way to do this
  14. S

    use bot 2000 and 2003

    I just got a new machine with office 2003 but it doesn't include ms access. Can I use access2k with this new version of office?? so I can do reports and put them into word etc??
  15. S

    drop down box

    I have a form with some drop down boxes The form is based on a table One field is lastname and one is firstname The row source is based on table/query The lastname field works fine but the firstname brings in the lastnames What am I doing wrong
  16. S

    error exporting

    I am trying to export a table from access 2000 to excel 2000 and keep getting an error message "external table is not in the expected format" What should I do
  17. S

    report problem

    I have to do a report of cases I've worked on during the year I can tally gender (m,f) =Sum(IIf([sex]="f",1,0)) then I do it again for M Is there a way to group "age" such as 11-13.14-17 etc. I did it in a count but now I want to summarize in the report footer
  18. S

    grouping in reports

    I need to do an annual report for all the cases I reviewed all year I have a lot of fields such as age,gender,IQ,ethnicity, referral source, county etc... I need to count how many in each field What is the best way to to achieve this Thanks
  19. S

    Report based on???

    When I go into a report I would like to see what the report is based on, (query, table etc.) What is the best way to do this
  20. S

    calc in a query

    I have a database where I record my clients visits(sessions) I have a field with the number of sessions allowed and another with the session history I would like to know how to query the table so as to total the number of sessions for each client
Back
Top Bottom