Search results for query: *

Thanks, it works. I Hate Spammers and Flammers!!!

Hello I have a table called 'staff' and another name 'course' Under 'staff' table is: StaffID FirstName Lastname Under 'Course' is: CourseID StaffID CourseName My questions is when I do a query under SQL, how do I show the staff's FirstName and Lastname instead of showing the StaffID. I...

Nevermind, I found out the solution to this. I Hate Spammers and Flammers!!!

This is hard to explain, but I'll give it a try. I have this problem that I have been trying to solve, but it just seem impossible for me to do. My problem is when I have one field on the report, the report only allows me to use one column and then continues on the next page. What I want to...

Actually, I figured out how to do it... :) Well what I wanted to do is to count the number of a Specific title, from training from text. And within the Employee Contact Information, I needed to find who is in the title and stuff. Then with all these, I had to put it into a report. Well...

Or is there in possibility to bound two queries into one report instead of one query. If it's possible, then I don't need two create two tables into one query. I Hate Spammers and Flammers!!!

Hi, I tried doingthis code but it doesn't let me because of syntax error. How can I make this work, cuz I want to use two tables into one query so that I can use it in the reports. SELECT A.FirstName, A.LastName, Count(A.Classes) AS CountOfClasses, First(A.Title2) AS FirstOfTitle2 FROM Training...

You will need to create a form that will have a combo box with a button that will open up the query. The combo box is will filter the the things you will need to look up. You don't put the statement in the sort field, but you put it in the criteria field. I Hate Spammers and Flammers!!!

I'm not sure if this is what you mean, here is the thread that might have the answer you're looking for. thread701-832485 I Hate Spammers and Flammers!!!

Thanks alot, it works great!!! I Hate Spammers and Flammers!!!

I forgot to add in. I need the duplicates in the table and that's y I did not delete these duplicates. I Hate Spammers and Flammers!!!

I have a query I have fields: ID, Name, and Track. What I wan to do is capture all of the information, except for the duplicates. What I mean is that if I have two ID's called 4, I want one of the 4 to show up, but the other 4 doesn't. This query will be coming out from a table called...

Thank you very much!! this is exactly what i want. Thanks alot!!! :) I Hate Spammers and Flammers!!!

Hi, I've been trying to find ways to make my database small in size and have less queries to be created, but the only way I can make this work will make the database bigger, and more queries, which will cause a mess.. What I want to do is I have a table called "tblTraining” and inside the...

You make it look easy... It works great!! Thanks alot!!!! I Hate Spammers and Flammers!!!

Oh... I don't know the code for this sql stuff.. I Hate Spammers and Flammers!!!

Select Left ( Format ( [MyNumbers], "0000000000" ), 4 ) As [ID], Mid ( Format ( [MyNumbers], "0000000000" ), 5, 3 ) As [CustID], Right( Format ( [MyNumbers], "0000000000" ), 3 ) As [TimID] I Hate Spammers and Flammers!!!

I did change my field name to other words that are not reserved, but it still pops up the error message. I Hate Spammers and Flammers!!!

I tried using this code within the SQL View, but when I try to run it, it gives me a message saying "The SELECT statement includes a reserved word or an argument that is misspelled or missing, or the punctuation is incorrect. I converted these numbers into a text. I Hate Spammers and Flammers!!!

I have a column with 10 digit numbers (1234567890) w/o any spaces in between in my table called "NUM". And in my Query, I want to split these 10 into 3 parts 4-3-3(1234-567-890). Thanks!! I want the first part to be in a field called "ID", second part in a field called "CusID", and third...