Search results for query: *

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...

What do you mean backups? Thanks

I am trying to synch 2 databases, a master and a replica, but I get the error message: The Microsoft Jet database engine could not find the object 'MSysCompactError'. Make sure the object exists and that you spell its name and path correctly. I see some of my other databases have this table, it...

Also, the Allow No New Record property doesn't help me. I would like to allow a new record under certain conditions. I could do it in VBA if there is a way. Thanks

I have a form that is populated witha query. I would like to not allow the form to keep forwarding to new blank records. For example there are 12 records, when you use the record controls and get to record 12, you are not allowed to go to 13, or at least not 14. Thanks for the help.

Thanks for the response. I have yet to see a definitive response also, just some tweeks but I don't know if they really apply to my specific problem.