New Database

[Guest]

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.

 

[Guest]

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];

 

[Guest]

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!

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];

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.

 

[Guest]

Open your database in Database view and select Queries.

Click on the New icon and click Ok for Design View.

Close the Show Table window and click on menu View - SQL View. Paste the
post and edit to remove any returns added in the
copying/posting/copying/pasting process.

The left side of the SQL should look like this --
SELECT [Enter start date] AS [Start Date],
FROM A_Adams
WHERE (((A_Adams.[Trade Date]) Between
GROUP BY [Enter start date], [Enter end date],

And the last line will end with a semicolon.

Save the query.

It will prompt you for start and end dates.

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!

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];

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.