Search results

  1. M

    Question Open Exclusive

    I am trying to open my database for exclusive use but i get the following message: You can't open "" for exclusive use because you do not have permissions to open exclusively Any ideas why this is happening? The only security i have is password prtection
  2. M

    Add column to query result

    I have the following sql statement: SELECT * FROM Autoglass UNION ALL SELECT * FROM AutoscreenNetwork UNION ALL SELECT * FROM Autowindscreens UNION ALL SELECT * FROM Glasscare UNION ALL SELECT * FROM MobileWindscreens UNION ALL SELECT * FROM NationalWindscreens This just unions all...
  3. M

    Writing UNION ALL in vb

    Can anyone show me how to write a UNION ALL sql query in VB.NET
  4. M

    Report on un-related tables

    I have six tables which contain the same sort of data but aren't related in any way. The first thing i want to do is have a report that shows all fields of each table on one page. I would also then like to get the sum for two different columns from all six tables. The columns are called Total...
Back
Top Bottom