Recent content by chrismja

I FINALLY figured it out!!!! Thanks in no small part to your help!!!! I really appreciate it!!! :-)

Ok...I finally figured out my syntax error, and I'm convinced that this is how my SQL statement should read, but I'm getting a type mismatch error......any suggestions? SELECT [TOTAL INVENTORY].[RECD DTE], [TOTAL INVENTORY].[STOCK NO], [TOTAL INVENTORY].YR, [TOTAL INVENTORY].CARLINE, [TOTAL...

I typed it in exactly as you had it and I'm getting an error: syntax error: (missing operator) in query expression 'TOTAL INVENTORY.[LST PRICE]-(TOTAL_FOCUS.BODY*TOTAL INVENTORY.[INV AMT]-TOTAL_FOCUS.TOTAL) Any suggestions? As you can see by my old expression, I do understand how to write them...

Yes, it includes the date as a single digit, "4" for 2004, "5" for 2005. I'll try this and see! Thanks again!:-)

Here you go!!! I appreciate both of your help VERY MUCH!!!! SELECT [TOTAL INVENTORY].[RECD DTE], [TOTAL INVENTORY].[STOCK NO], [TOTAL INVENTORY].YR, [TOTAL INVENTORY].CARLINE, [TOTAL INVENTORY].[SERIAL#], [TOTAL INVENTORY].MODEL, [TOTAL INVENTORY].DAY, [TOTAL INVENTORY].[COLOR=DESCRIPTIONS]...

I have put all my incetives in one table with an extra field for the year. Now what I'm trying to figure out is how to rebuild my expression and make it lookup the year and then the model to match up the incentives. This is my current expression: PRICE: IIf([TOTAL...

Here is my expression: PRICE: IIf([TOTAL INVENTORY]![YR]=4,DLookUp([TOWNCAR4]![%],"TOWNCAR4",[TOTAL INVENTORY]![MODEL]=[TOWNCAR4]![BODY])*([TOTAL INVENTORY]![INV $$$])-(DLookUp([TOWNCAR4]![TOTAL],"TOWNCAR4",[TOTAL INVENTORY]![MODEL]=[TOWNCAR4]![BODY])),IIf([TOTAL...

I really appreciate all your help. Ok....let me see if I can explain. I work for a Ford dealership, and I have a spreadsheet that I use to price our vehicles (instead of negotiating we choose to give customers our best price upfront) I think Access can do what my spreadsheet is doing and be more...

I don't know if you may have any other suggestions....it is working partially... It is pulling some of the records just fine, but then in other records where the field includes an expression that I have built (and was working fine)it just says "error".

Thanks! I appreciate your help! Maybe you can tell me what I'm still doing wrong, I tried what you suggested, and this is what it looks like: FROM [TOTAL INVENTORY] LEFT JOIN [TOWNCAR4] ON [TOTAL INVENTORY].[MODEL] = [TOWNCAR4].BODY LEFT JOIN [TOWNCAR5] ON [TOTAL INVENTORY].MODEL =...

I am joining 3 tables, but it's only pulling matching records in the tables, and there are some unique records I also need it to pull. I'm sure there is a way to do this, but I don't know how. Here's the situation: I have a table named "Total Inventory" and I have 2 other tables that include...