Good morning all trying to see if there is a help video on this. So let me try to see if I can talk this one. I make a query (agregate) and make a second query to do the calculation. I like to get all this in one form to execute on one button. When I think I got it, I deleate the query only to find that the query in the form is looking for the agregate query. How can I get his done so I dont have the 2 querys just the SQL? Not going to ask if it can be done Richard probably will put out di-lithium crystals and blast it with a phaser and make a new function.. LOL
V/r Juan LLNP
Kevin Robertson 11 days ago
Since this is a long SQL statement and from the extended cut I won't post all that code here, but this is how to do it.
If you take the calculation from the second query and put it in the aggregate as an Expression.
Then go to SQL view. This is what you need in the RecordSource of the form (copy and paste).
Now both Queries can be deleted (make sure everything is working first).
Juan C Rivera 11 days ago
Thanks Kevin I will try tonight last night it drove me crazy when I removed the 1st query and could not figure out what happened.... LOL senior moment!