Recent content by sturner333

Thanks again the help.

I have asked a question on the forum for what I was trying to do a certain way. Maybe I should just ask for what I want to do. I am trying to pick certain records from one table based on data from another record. Table1 has a column of used idNumbers. Table2 has a column of ALL idNumbers. I...

I get the same result with NOT IN as above. Any other ideas?

Why would I get a statement for the sql criteria in a query that reads "At most one record can be returner from this subquery" ((select[tblPlatformCategories].[platformid] from [tblPlatformCategories] where [tblPlatformCategories].[platformid] <>...

Because there is a sub category under this one.

I have a query that one of the fields can have repeated values because it is repeated in the table it comes from. I would like to only have one of the repeated fields. For example: 1000 1330 Bob Lowman 1330 7000 7110 Steve Quast 7110 7000 7110 Steve Quast 7110 7000 7110 Steve Quast 7110 7000...

Thanks. That is what I am starting to realize.

Thanks!

I have inherited a database and ran across something I have not seen. I am sure it is a relationship with another table or query. Next to the left most column is the '+' sign that expand to records. Can someone give me brief explanation of these and how they are implemented and can they be...

This would be in the sorting and grouping section. What would I enter for this. I can give you more info if you need it. Thanks

I have a report that looks like the following: Market Project# Note Project# Note Project# Note Market2 Project# Note Project# Note Project# Note Sometimes a given Project# has multiple notes entered. Right now my report will handle the multiple notes...

Thanks for the response. I have a couple questions: 1. In the Join, choose ALL projects and notes that match? 2. This expression should be in the Field: section? 3. I know you don't know all my data but I am trying to match up you code with my data. NotesEngineerField is the...

The project table that the rest of the data comes from also has 2 engineers listed.

I am trying to do an complicated report and am looking for some ideas on how to do it. This hard to explain ( I think), but what I want to do is run a report based on project category project number and all notes that where entered for those projects The tricky part is if there is a project...

I have a front-end database that is linked to a back-end. The back-end is a replica. I recently re-did the back-end, added some tables. I have never had this problem before when I have had modifications but the following happens now: I can refreash the link between the front-end and back-end...