New Database

A

Andre Adams

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.
 
K

KARL DEWEY

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

Andre Adams

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 said:
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 said:
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.
 
K

KARL DEWEY

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.

Andre Adams said:
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 said:
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 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Dynamic Naming of Form Button 3
Query. 2
Report 1
Query 9
New Query 7
MS Outlook inbox to MS Accsess Database 0
Cumulative formula for word table 0

Top