Search results

I am creating a new module for our company database to track project cost vs budget. Our system is set up with multiple cost lines, each containing various cost codes. However, not all lines will be used on a project. Typically only 5-6 lines, but I need to set the form up to use the other...

That did fix it. Thanks again. :D

That would make complete sense. It just started doing this after I made some changes/additions to the query. [union] being on of the additions. It never even occurred to me. I'll give it a try. Sometimes it just takes another set of eyes. Thanks for the help.

I have a query that I have created as a Select Query. It will work fine for a little bit, but keeps converting to a Union Query on its own and then gives an error "Syntax Error (missing operator) in query expression 'Tanks.'." This is driving me nuts. I've gone through the Design View when it...

That's my thought too but wasn't really sure where to start with it. It only does it with select records. Just wasn't sure where to start looking. I have the same expression in another Form that seems to be working fine. May force one of the offending records to appear in that Form and see what...

Everything is right justified in the query. This indicates numeric, correct? Sorted ascending, the first value is 1. Sorted descending, the last value is 1620. Looks like the data type is numeric in both the table and query, correct?

Tanks is a table. The [Job_ID] is an Autonumber, Long Interger. The datasource for the form is a query. Sorry, but don't know how to check the datatype in a query?

Thank you for the replay. While this would avoid the error, it would defeat my purpose as I still wouldn't fetch the value. The field [Job_ID] contains a value. I can see it. For some reason it doesn't pull into the expression for some records.

I am attempting to perform a Dlookup to populate an unbound control with the following command: Me.txtad_Ship.Value = DLookup("[ad_Ship]", "[Tanks]", "[Job_ID] = " & Me.Job_ID) For some of the records, I get an error message of "Syntax error (missing operator) in query experssion '[Job_ID]...