Recent content by omgjtt

Sorry for making the title so non descriptive. I am unsure how to do this. I am guessing I will need to show unique values in a field? Thanks in advance James

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

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

Thanks @ plog, I read the wiki page and your post and had my "aha" moment. Thanks for your help. I look forward be being more of a contributor on this board when my skill allows : ) Thanks again James

Thanks spikepl. I am reading that and it seems to be clearing up some misconceptions I had. Thanks again.

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

Thanks for the help and additional advice.

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

Did I post this question in the wrong section?

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

Thanks Brianwarnock - I will take a look for that.

@ Summer123 - I changed the actual names when posting oh here. I did not want to give company names. I will fix that! Opps. THanks for spotting. In my code the naming conventions are correct. @ spoole - I did add does. Here is that part of the code - [comro camp_code] When I run the query with...

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

Sorry for asking this question. I watched the first video and the teacher explained how it is a database management system. Sorry for wasting smart peoples time : )

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