RE: New Database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Maybe there is some more studying I need to do. I don't understand where you
are talking about performing these functions. Is this in a new design view?
Is this while I'm creating the view from an already established database.
Where do I find the screen where I can input this information?

Thanks for you speedy reponse sir!

"KARL DEWEY" wrote:

Try using this query ---
SELECT [Enter start date] AS [Start Date], [Enter end date] AS [End Date],
A_Adams.[Money Manager], Sum(A_Adams.Quantity) AS [Total QTY],
Sum(A_Adams.Commission) AS [Total Commission]
FROM A_Adams
WHERE (((A_Adams.[Trade Date]) Between [Enter start date] And [Enter end
date]))
GROUP BY [Enter start date], [Enter end date], A_Adams.[Money Manager];


"Andre Adams" wrote:

Alright guys....Help me out with this one.

I am an avid Microsoft Excel user, who decided to utilize the database
functions of Microsoft Access. I have all of the information that my
database needs in a table properly configured to release to me any
information that I'll need to pull a report or query from. Here's my
problem.

(1) I need to figure out if there is something out there that will let me
know how
use the design form. There are formula's that I need to input (sum and
total)
and I need to know what to put in here to pull the information that I
need.

(2) If, in design mode, I try to sum, but I want to sum by pulling from
within a date
range. How does that work. So it looks something like this.

Trade Date Money Manager Quantity
Commission

I want to sum within this trade date to give me a total by Money Manager of
the Quantity and Commission.

Please let me know if you need any further information for me, and thanks in
advance for your help.


.

Relevant Pages

  • RE: New Database
    ... Open your database in Database view and select Queries. ... Click on the New icon and click Ok for Design View. ... and I need to know what to put in here to pull the information that I ... If, in design mode, I try to sum, but I want to sum by pulling from ...
    (microsoft.public.access.gettingstarted)
  • Re: Record Source Theory
    ... for is an opinion on the "proper" way to design a professional ... The primary table has forty thousand records and when my database ... You're over-worrying a bit in my opinion. ... pull a few pages of records and then pull more as needed as the user ...
    (microsoft.public.access.modulesdaovba)
  • RE: Best Practices Question
    ... that will sum up all of the best practices for designing a database. ... //several white papers and articles on database design best practices ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Can a form with drop down menus search in other forms?
    ... that has various drop down menus for searching purposes. ... Company A. I want for Access to pull all forms that have "Company A" in it. ... if you said what you meant, then you probably have some serious design issues ... going on in your database... ...
    (microsoft.public.access.modulesdaovba)
  • C# programmer looking for a job
    ... Software Development including Desktop, Client/Server and Database ... Practical skills in object oriented design and design patterns ... XML, Oracle, CVS, VSS, Delphi, bug tracking. ... Developed in Delphi5; ...
    (misc.immigration.usa)