Search results

  1. O

    Help writing a query?

    Help writing a query (sum of appends)? Hello, Every Monday I have to import 9 different files into a database. I then have to append each table from those 9 file to one table (leads) The names of the imported file(s) change each week. I am wondering if there is a simple query I can write to...
  2. O

    Question How to close a non responsive Access database

    I have to work on a terminal server and turn off a database before I can do another task. Sometimes the database will freeze. I have been running the task manager from the run prompt and closing it that way. Is that my best choice? I just want to make sure this will not hurt the database. Any...
  3. O

    Left and right join question

    I am starting to understand the join functions. I am still having a bit of a hard time with the literal meaning of right and left join. For example when should I use a right and left join. If these were the two tables tbl_teacher id | dept | teacherName | ------------------------- 01 | 02...
  4. O

    Multiple conditions in a where clause

    I am trying to write a query that will only return result from 3 different countries (Ireland, Germany, and Spain) from a table that contains 100's of different countries. Here is the query I wrote that does not seem to be working. Select bbc.name, bbc.population from bbc Where...
  5. O

    Books on SQL

    I am looking to learn SQL and am wondering if someone can recommend some books that will help me with Access. I am looking to learn Access SQL since I understand that there are vendor specific differences in the language. Any must reads? Thanks - James
  6. O

    Queries with spaces in field names

    Here is a question I asked at some point last week. I was able to create a query that returned what I needed. Some of the field names have spaces. I understand that this is a bad practice but I am not in control of the naming conventions at this point. To get the result I removed all spaces...
  7. O

    Check SQL sever version?

    I am about to start a training course in SQL server 2008. I am using Access 2003. How can I check which version on SQL server I am running? Can I use Acess 2003 with an updated SQL server? Thanks - James
  8. O

    Hello from Daytona beach Florida

    I am new to this forum but look forward to becoming a regular member. I am a web developer who is new to Access (5 days under my belt) I have been doing front end development for 4 or 5 years. I built a site for a company a little over a year ago and just got a call from them last week. They...
  9. O

    Find unmatched result query?

    I am pretty new you access. <= one week : ) I have a database that contains two tables. Each table has two fields. The data in the left column is the same for each table. It is a naming convention used for a campaign. Lets call that field tbl_Name. The second field in each table is used for...
Back
Top Bottom