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
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
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...
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...
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
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
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
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
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
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
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
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...
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
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??
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
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
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
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
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