Search results for query: *

Hello-- I have two linked tables from one database to another. In the database where the tables actually reside the relationship between the two tables works perfectly. In the database that I want a link to the tables in I can't get the relationship to work. They are related in the database...

This is what I tried. This is not what I want though because if I do that it displays each record with the individual software titles. All I want it totals information for each software title, not all the records associated with the software title.

I have a table that contains software usage records. It has the name of the software package, the computer name with it installed, the budget code that the computer belongs to, and the name of their area. I want a report that does this: Lists each software title with the names of the 4 areas...

hello-- I have a pretty complicated query that I need to run. I have a table containing customer information. In that table there is a column for the customers full name. In a search function I'm designing I want a form to pop up and a user can enter in a last name, a first name, or both...

That last suggestion did the trick. Thanks for the responses!

SELECT * FROM (tblUniqueUsers INNER JOIN tblBIQueryAdmin ON tblUniqueUsers.UserIDNumber = tblBIQueryAdmin.UserIDNumber) INNER JOIN tblBIQueryUser ON tblUniqueUsers.UserIDNumber = tblBIQueryUser.UserIDNumber WHERE (((tblUniqueUsers.UserIDNumber)=[Please enter a UserIDNumber])); The tables are...

It puts all the correct matches into one row, I need each match on a seperate row. Any way to do this?

Ok, I understand better now that I've tried it but when I add in the second Inner Join statement I get a syntax error in my from clause.

The only problem with that is I want to display the information kept in Table1 and Table2 not the information kept in Users.

Hello-- I have an Access database set up with a "Users" with a unique "UserIDNumber." I have several tables that contain records indicating whether the user has a certain piece of software installed. These tables are related to the "Users" table by the "UserIDNumber." I want a user of the...

The issue isn't the phone calls to tech support. Those are received by the help desk. I'm 2nd level. I get a log of a help desk call and then I respond to the user to help trouble shoot the problem. I need to be able to enter the user's user id and get back the computer he is logged into...

not sure, it doesn't really matter though. There are 10,000 computers in my company and I'm not counting on finding and changing the enviornment variables on computers that may not be setup correctly. Although, I don't think this is it because nbtstat won't cache my own computer name and I...

Hello-- I'm trying to write a windows 2000/XP script that will take a user's login name and resolve to the name of the computer the user is logged into. I've used many scripts that I've found that use net send and nbtstat -c commands to find computer names but I find them to be un-reilable...

hello-- I do 2nd level desktop support for a large company and I have a question. We are constantly trying to find computer names based on a user's login ID. Users at my company are authenticated using both acrive directory and novell. We really need a script that will allow you to enter a...