Search results

In the query, you can add the ID # field (if it isn't already in the query) and then choose to sort ascending or descending.

You're getting the error because the form looks into it's record source and can't find a relevant field to put the data. To put data into multiple tables, you may have to use VBA but maybe there is a different way to go about doing it. Anyone?

Oops. I figured you would have noticed that button since you are THE Great Pat Hartman. A billion posts. :) Probably the only difference then is the webserver. :/ He is using a free one... I believe. Right Agent_J?

Glad we got it worked out. Now I can concentrate on my work. :cool: Btw, You're welcome. Any time.. except when I have work to do :p

Hand-off :) To any members who view this thread, please pick this up for I have fallen out of time. :( Good luck Katie!

Yup, Maybe! But try putting Expr1: CCur(Nz([SumOfPurchaseAmount],0)) further to the right of [SumOfPurchaseAmount] and see if that works.

If you have winzip installed on your computer.... Explore to the file.. then Right-click on the file.. (default settings of winzip will add itself to this menu).. goto winzip.. then Add to TheFileName.zip. Then attach the zip. :-D

He's using the Insert Image option next to the Insert Hyperlink option.

ooOOO! Pre-existing calculations and data! If you attach the Excel file, (if it's too big, try zipping it) it would help us help you. (This "decision tree/table" is already in the Excel file, right?)

Is [SumOfPurchaseAmount] a field in a table? Where does this get calculated?

Maybe move DAO 3.6 as high on the list of references as you can. Then have a go at it.

You're welcome. :-D Expr1: CCur(Nz([curValue],0)) Just to make sure you put it in the right spot and made the correct changes (since I forgot to tell you :o) In your query, it would go in a Field (top row) value. Then you'd change [curValue] to whatever expression or source you were...

Sounds like you'll either have to use SQL statements or VBA coding. If you give us more details on the tables and desired output, we can help you out. (What's the table called? What fields are in the table? What is the setup of the fields (non-default properties.. data type, etc)?)

Just in case you, like myself, wait to see a post as new before going back into a thread. I am adding another post.. but basically check out the last post. I wrote it while you were writing yours so.... the thread might appear "read" to you.

I do not believe there is such a On Close event for the entire database. To get around it.. You could have a hidden/invisible form load on startup and then when the user goes to exit the database this form will have to go through OnClose/OnUnload events before the database is actually closed.

Expr1: CCur(Nz([curValue],0)) :D

Ohh! My mistake. I thought the values were coming up as ZERO and not NULL. Sorry.

Great! Wizards are evil.. yet helpful for some.

And you've set the format for the appropriate data to Currency? But all the other data displays in currency format? :confused:

Ah that slippery Nz(). I've only used it once so far. Good job Pat. :)