Search results

I am trying to compare data from two different systems. I need the employee id, name, and hours worked. The prolblem is that in one system the name and id number are separete fileds. In the other, they are merged into i field where the name is 6 letters of last name, then first initial then 4...

OK, NEVERMIND ON THAT ONE, I GOT THE UNION QUERY CORRECT.

OK, still trying to get union query to work I have: SELECT [NAME],[SALARY] FROM [ONE] UNION SELECT [NAME],[SALARY] FROM [TWO] and when I run it, I get an input box asking for SALARY parameters. Why? I jsut want it to show all the records from both tables.

I have two tables(ONE & TWO) with the same fields. You probably ask why two tables just alike, well I am importing them both from other departments to do some comparisons on. For simplicity, lets say there are two fields Name and Salary. I am trying to use a union query to show each name once...

I have created a report based on a crosstab query that shows the monthly worked hours of each employee. I will have to print the same report next month based on new data in another table. Is there an easy way to do this,(run the same query and report each month) without having to recreate them...

I have about 12 tables, 1 for each department, and I was trying to query them all to find duplicates(employees that have worked in multiple departments); all tables have the same four fields(if it matters). What kind of relationships(if any) must be between the tables to query them all? Can I do...

Nevermind, I figured it out. thanx tho

I have a query to count the number of records each employee (with certain criteria) has. 4 fields: EmplNumber,DateWorked,Code,Count The count field I added and just put a one in each record. So that in my report I am grouping by Employee Number, and just showing the summary info, after summing...

I have a form to enter attendance data. When I have entered all I am going to, I try to close form and get "Invalid Use of Null" because there is no number in employee number text box, well I am done, with no new numbers to enter. I set all the properties in the table to 'not' required and...