Recent content by cat001969

The easiest way to do this is to create the union query and save it, then create a query on the union query as a make table query.

Is there a reason you are not going to file --> get external data? Is this a one time import or is it an import that you need to do on a regular basis?

In design view of the report look at all areas of the header ... it sounds like you have a field that is not connected to anything. These fields are easily spotted as they normally will have a green triangle in the upper left corner of the field. You will need to remove the field or connect it...

You could create a query with an outer join between the 1st and second tables then base the form on that.

If the report is based on the query, and the query is getting the parameter values from the form you only need to run the report, the report will run the query. You don't want to do make table queries every time you need the report. There is no purpose for that.

You need to add a report footer to the report - View - Report Header/Footer In the report footer you need to add a text box. In the properties for the text box under control source you will need to enter a formula. The formula should look like =count([fieldName]) so if you are counting last...

Make sure you select the Table, Query, etc to view its dependencies :D

The join would not work for what I need to do. I have 5 sets of 3 fields, if the first field is not null then it needs to pull the name of the matching provider, if it is null then it has to look at the next two fields and pull the name of the provider as well. It then must return only one...

I am doing a Dlookup in a query based on the value of one table to look up the value of another field in a table based on two other fields in the second table. Although my code is presently returning data it is not correct data. Any suggestions? Test: IIf(IsNull([Attend_Prov_MMIS_Id_W039])...

fields in tables should be the smallest possible value, Name is never a good field because it can be broken down further ... in your case you should have: LastName LastName2 FirstName MiddleName You can then concatinate them in any form, query, or report to have them show as you would want...

The form is open as maximized. Nothing special about the form in general. I would normally think that it would be a system resource or memory issue, but it is happening on every computer we try the database on. The only solution so far has been to minimize then restore the form. I also know...

The me.requery does not help. The area of the form that is not loading is the form footer where there are customized buttons that are needed for the form. The fields and the data are loading but without those buttons the form is useless for the most part.

The form that is not loading is based on a query.

Oops Ok ... well that worked for the first try, now it is not working. Any other ideas? Here is the whole process. The main form loads, click a button, a different form opens and the main form closes, click another button and a 3rd form loads (this is the one that won't load fully), and...

Duh Thanks ... that seems to work ... I know better ... oh well, guess the brain is just not working today.