Recent content by Medea

Occured to me on the way home....create a second query based on your first query. This works. Put your parameters on the 2nd query. DK...you agree? Trish

Too cold to ski tonight....I will play with this more when I get home.

I got the error too!

I'm confused!!!! Why are you guys getting an error and I'm not????? Any ideas DK?

You are a god!!!!!! Thank you!!!!! Trish

Make a copy...pair it down by getting rid of the table, queries, etc that are not needed and leave around 10 records. That should make it small enough. Also, download mine again and when in query mode, select view --> Design view. That is easier to read then the SQL view.

sure thing....

Thanks! That works great for incrementing but I also need it to find the changes in order number. Ex: Order # 1234 may have 3 line items - so I would need 10,20,30. Order # 2345 may have 5 line items - 10, 20, 30, 40 50. I will play with the "GetLineCounterReset()" and see what I get...

Where you able to download the sample? Are ... Field1 is: "Total Shipment Charge" Field2 is: "FSC" fuel Surcharge Field3 is: "Distance" fields in a table or parameters in your query? I put them into a table along with the fields listed in your first formula.

I re-created (i think) your table and query and it worked fine. I used your formula exactly with no issues. See attachment. Field spelling as you listed. Take a look/see attachment. SELECT Table1.[Total Shipment Charge], Table1.FSC, Table1.Distance, IIf(IsNull([Allocated Overwidth Charge...

What field is the popup referencing?

Whenever that happens the first thing you should do is check the spelling of your fields in the formula. Check everything in the brackets. Trish

Hello, I have an issue that may or may not be an easy fix. Either way, I am at a loss and would appritiate ANY help!!!!! I import data from excel in order to cleane and format it to migrate it. One field is blank but needs to be auto numbered 10, 20, 30, etc at each change in Order number...

Thanks for the response but I just fugured it out. I took out all the "WHERE" clauses except the date parameters and it runs great. Have a great night! Trish :)

Hello All, I have an SQL statement behind a report that is giving me an "Expected; End of Statement Error". I can put the first part (blue) in a separate query and it runs fine. When I add the rest of the statement behind the report (Red), the errorr message selects "Yes". The report has a...