Search results

No, what I am saying is the EmpID is a primary key and only appears once. The department data table is a table that holds all the data. It is the many table without a primary key. Employee table to DeptData table is a one to many relationship.

Correct, the employee is not duplicated because it is a one to many relationship. However, my data that holds the EmpID is duplicated in the "data holding table". It is this table that I need to draw the query from.

It is not that department is critical to the query, it is because of department that I have employee duplicate entries. The data is duplicated and I need to show the employee only once for this form. Thus the group by in the query.

The duplicates occur when an employee is in more than one department. One employee to many departments. I am creating a Emergency Responders list and I only want each full time employee to appear once. Therefore my query is grouped by EmpID. The query pulls from two tables.

I have a query where I group by EmpID, so duplicates do not show up. In this query I have two fields with no data. These fields are to be filled in after the query is run in a form. However, these fields are not editable due to the group by feature. Any work arounds for this? I tried two...

I have a subform called DD subform I have an unbound combo box named Target How to I set the control source of Target to reflect my DD subform? In control source, my only choices are the fields related to the subform, not the subform itself.

When I debug it takes me to DoCmd.OpenReport "EdRep4a", acPreview 'for class

It asks me for Department.Employee number

I can open the report directly. Where would I find Name Auto Correct?

I am running a report but it is asking me to enter a parameter value. Can anyone tell me what is going on? When I go to debug it takes me to the bolded line. That is what my report is called. Thanks in advance to any help you can give. Private Sub Command12_Click() Dim res As Recordset Dim...

I am updating a database from Access 1995 (yes) to Access 2007. Due to the macro and calculated fields, I can not update this database to 2000, then to 2003, then to 2007. It simply won't update. So I am re-creating the database. I have a form that takes the results from option buttons (which...

Yes, the query runs just fine. Running in form view.

Yes, I had already set that, but it does not seem to make a difference.

I have a field on a form called ChemID. This field is made up of two fields, ChemID and ChemName. Only ChemName is displayed. I have a query assoicated with the form that sorts by ChemName; however, the form always displays the original sort of ChemID. Any help would be appreciated. Here is the...