Recent content by jzwp22

Typically a query that returns a Cartesian Product will not be updateable. Are you trying to run an action query (update, append etc.)? Can you post the SQL text of the query?

If you left a table in the query and there was no join between that table and another table in the query, the query will return a Cartesian product of the two tables. So if you had 1000 records in 1 table and 500 records in the other, the query would return about 500,000 records (1000 x 500).

In your query you will have to add the ConcatRelated() function with criteria based on the TripID SELECT tblEventDetails.tripID, ConcateRelated("Locations","tblEventDetails","TripID=" & tblEventDetails.TripID) as ConcatenatedLocations FROM tblEventDetails GROUP BY tblEventDetails.tripID By the...

Technically you do not have to create a new thread, but others may only be monitoring new threads, so you may get more people helping with a new thread. I am traveling at present so I will not be on-line much over the next few days, but I'll try to help when I can.

Glad to hear that the thread helped you out. Good luck as you move forward with your project.

You're welcome

In general, calculated values should not be stored in the tables, you would just do the calculations on the fly when you need them in a report, form or query. If you require a report, then you would handle the calculations there. It sounds like you already have the calculations functioning in...

Create a query. Add both the imported data table and your lockerInformation table. Make joins between the two tables. If I recall, you may have to make a join for each of the fields (location, type and number). If so, the update query would look something like this UPDATE...

If you want to save the external data, then you will need to create the table structure necessary to hold that data and then use append queries to copy the data from the external source to you created table structure. All your forms, queries (other then the append queries) and reports should be...

If you have the data in another electronic format such as a spreadsheet, you can import the spreadsheet into Access as another table and then run some append queries to move the data into the tables you have set up. Once you are done with that, then you can delete the imported data table.

Is the measurement start date field set up with a text data type or a date/time data type? If it is text, convert it in your criteria WHERE cdate(measurementstartdate) BETWEEN #12/01/2012# AND #12/31/2012#

How about this: WHERE startdate BETWEEN #12/01/12# AND #12/31/12#

OK. All employees including team leaders should have corresponding records in a table tblEmployee -pkEmpID primary key, autonumber -EmpNo -txtFName -txtLName If an employee is related to another employee, i.e. a leader to a team member, we need a table to capture that relationship...

What I would recommend is to create a properly normalized table structure and take your dumped data and migrate it into the normalized structure. When the data has been moved, the tables that have the original dumped data can be deleted. This will allow you to use consistent data. From there...

Do you have any code that runs when you open the database? I did find this thread. I'm not sure if would be applicable in your case. In VBA, go to tools--> references and see if any are marked as "Missing" if so, you will need to resolve those Have you run the compact/repair utility...