S smeagain Registered User. Local time Today, 16:02 Joined Jan 5, 2011 Messages 26 Feb 10, 2011 #1 Access 2007. I have created a calculation query, which when run gives me the total I require. How do I now get the total to show in the total field on one of my forms.
Access 2007. I have created a calculation query, which when run gives me the total I require. How do I now get the total to show in the total field on one of my forms.
pbaldy Wino Moderator Staff member Local time Today, 08:02 Joined Aug 30, 2003 Messages 36,272 Feb 10, 2011 #2 I assume you mean this query is unrelated to the existing source of the form. You can use a DLookup() to get the value from the query.
I assume you mean this query is unrelated to the existing source of the form. You can use a DLookup() to get the value from the query.
