Recent content by joeblow2

What I am doing is trying to get a combined solution set. Basically I want to combine the results of these two queries: Select Event_id,Question_id,Response,AgeGroup,Sum(Quantity) From Event_line Group by Event_id,Question_id,Response,AgeGroup and Select AgeGroup, Sum(Quantity) From Event_line...

I've included my tables, input data, output data and sql. As you will notice the self join introduces errors in numbers in both Expr1 and Expr3. I hope someone can see what is introducing the errors and how to fix it. Thanks

Thanks a lot jdraw!

Can anyone please suggest something to read regarding the way Access nests joins in the "from" clause- all that amount of bracketing etc. Especially self joins. Thanks.

Thanks a lot!

If I had a form to gather the info, how would I make the query get the value of a parameter? Am I on the right track if I say something like: [Forms]![Form Name].Control Name ? Thanks.

Thanks for your reply. However, how would I pass the value of the parameter to either DLookup or the sub report? Thanks.

Hi: I have a report based on a query, say Query1. Now I want to include in the report, a field (SumofQuantity) based on a second query, say Query2. Both Query1 and Query2 have the same parameter needed to run them. Is this possible? Initially I used the expression builder to say...

Thanks Paul.

I am doing a "group-by" query. There is one field - a date field - which I want to appear in my query because it's tied to parameter conditions. But I don't want it as a group-by field because it gives me duplicate records as the dates are all different . However, I get an error message if I...

Thanks boblarson.

Hi: I need help in finding out how to make a backup of my database. When I look at the size of the file of my backend (database) it is about 10 MB. However, when I go to Tools|Database Utilities|Backup Database, it only creates a file of about 1 MB. This is causing me to wonder if using the...

Thanks for letting me know.

How do I declare and use variables in the expression builder? Thanks

Hi: I got the records to delete. I used the command button wizard and used whatever code it created. Also, I had to put the navigation buttons back as I had removed them. So the user navigates to the record to be deleted and then the button is clicked. How do I mark this as my post has been...