Search results

  1. S

    Merge tables into one Big table

    Thanks a lot Boblarson...Does that however mean i can not do it in the current structure without your modifications?
  2. S

    Merge tables into one Big table

    I have attached an example which i hope explains my problem... In the attached file i have Report 1 , Report 2, and Report 3 these show data from the 3 tables in separate reports and in the right format. But what i want is to combine data from all three tables and show in one report grouping by...
  3. S

    Merge tables into one Big table

    i have tried the following: SELECT Students.*, [Sciences].Subject, [Sciences].grade,[arts].Subject, [arts].grade FROM (Students LEFT JOIN [Sciences] ON Students .StudentID = [Sciences].StudentID ) LEFT JOIN arts ON Students .StudentID = arts.StudentID ; is this correct?... The problem im...
  4. S

    Merge tables into one Big table

    i just wanna do it temporarily to print a report....the report contains all the records from the three table so i thought having a large table temporarily would work
  5. S

    Merge tables into one Big table

    Hi guys, i know its easy but am failing to figure it out... having the following tables Students - contains the main details e.g name, D.O.B, address, contact Sciences - contains 4 science subjects physics,chem,bio maths arts - contains 4 art subjects literature,history,politics how can i...
  6. S

    hi MSAccessRookie can you help me I have a form which contains multiple checkboxes and a...

    hi MSAccessRookie can you help me I have a form which contains multiple checkboxes and a button. On clicking the button i would like to query the information that matches the checked boxes only from a single table. How can i do this taking into consideration the unchecked ones? Any...
    • silver
    • Profile post
  7. S

    Query By Form - Checkboxes

    Hi Guys! I have a form which contains multiple checkboxes and a button. On clicking the button i would like to query the information that matches the checked boxes only from a single table. How can i do this taking into consideration the unchecked ones? Any advice/references greatly appreciated
  8. S

    Group by ID

    Guys i have 3 queries im using to list users satisfying certain conditions and would like to print this off using a report. Since i have the same companyID's in the results of the 3 queries how do i group them according to their IDs? At the moment the report first prints ALL records from Query1...
Top Bottom