Search results

  1. R

    Duplicates records in table

    Hi I want to amend my query so that all duplicate records don't appear. For example when the query is run the information generated includes: Day the audit took place Room the audit took place in Faculty the activity belongs to Staff lecturer(s) who takes the class Activity that was going on...
  2. R

    Count Query

    Hi I am running a count query at the moment which shows the number of classes booked for each faculty. The query is as follows: SELECT Audited_Week02.Faculty, Count(Audited_Week02.Faculty) AS CountOfFaculty FROM Audited_Week02 GROUP BY Audited_Week02.Faculty; So when the query is run the...
  3. R

    Using the count function in access queries

    Hi I have a table which has information the count of students in classrooms around the university and I need to summarize the table by Faculty. Therefore, all I want to do is a count of students for each faculty i.e. Art and Design, Business and Law etc. The query i put together is: SELECT...
  4. R

    Report issues

    Hi I am working on a report which I have published to Microsoft Word, however the format of the report isn't correct in Word. The report includes a couple of Jpeg images which are not appearing on the word version. How do I solve this so that the JPeg images appear on Word? Also, is there...
  5. R

    Sub Reports using queries which aren't linked

    Hi I want to create a report which includes information from different queries. I have tried to add more than one query to a report but it comes up with the following: 'You have chosen fields from record sources which wizard can't connect. You may have chosen fields from a table and a query...
  6. R

    Sum formula

    Hi I am working on a report in Crystal 10, which calculates the area a person occupies in a room. I have set the report out in the following way. |(GH1) Faculty |(GH2)Department #of staff Room area Occupied M2 per person| Group Header 1 is Core_faculty.faculty_code Group...
  7. R

    counting data

    Hi I really hope someone can help me this time, I haven't had much luck in the other forums. Basically I am working on a spreadsheet which has 2 columns, one is the priority column and the other is the Action column. At the end of the spreadsheet there is a table which totals up the priorities...
Top Bottom