Sum up an amount

[Guest]

Please help I am new to Access.

I get a Aggregate Funcition error from Trvl_Start when I try to run this
where am I going wrong?

SELECT Sum([ACT_TRVL]) AS Total, tblAttendan.TRVL_START
FROM tblAttendan
WHERE (((tblAttendan.TRVL_START)>#1/1/2007# And
(tblAttendan.TRVL_START)<#3/30/2007#));



Thank You.....

 

[Jason Lepack]

SELECT
Sum([ACT_TRVL]) AS Total
FROM
tblAttendan
WHERE
TRVL_START between #1/1/2007# And #3/30/2007#;

Give that a try.

Cheers,
Jason Lepack

 

[Guest]

Hi and thank you for your response. What I want is to have the amounts for
each time plus a grand total that is between the dates. What I am getting
from your SQL is that grand total but no dates....

Please help thank you!

SELECT
Sum([ACT_TRVL]) AS Total
FROM
tblAttendan
WHERE
TRVL_START between #1/1/2007# And #3/30/2007#;

Give that a try.

Cheers,
Jason Lepack

Please help I am new to Access.

I get a Aggregate Funcition error from Trvl_Start when I try to run this
where am I going wrong?

SELECT Sum([ACT_TRVL]) AS Total, tblAttendan.TRVL_START
FROM tblAttendan
WHERE (((tblAttendan.TRVL_START)>#1/1/2007# And
(tblAttendan.TRVL_START)<#3/30/2007#));

Thank You.....

 

[Jason Lepack]

SELECT
Sum([ACT_TRVL]) AS Total,
TRVL_START
FROM
tblAttendan
WHERE
TRVL_START between #1/1/2007# And #3/30/2007#;
GROUP BY
TRVL_START

Hi and thank you for your response. What I want is to have the amounts for
each time plus a grand total that is between the dates. What I am getting
from your SQL is that grand total but no dates....

Please help thank you!

SELECT
Sum([ACT_TRVL]) AS Total
FROM
tblAttendan
WHERE
TRVL_START between #1/1/2007# And #3/30/2007#;

Give that a try.

Cheers,
Jason Lepack

Please help I am new to Access.
I get a Aggregate Funcition error from Trvl_Start when I try to run this
where am I going wrong?
SELECT Sum([ACT_TRVL]) AS Total, tblAttendan.TRVL_START
FROM tblAttendan
WHERE (((tblAttendan.TRVL_START)>#1/1/2007# And
(tblAttendan.TRVL_START)<#3/30/2007#));
Thank You.....- Hide quoted text -

- Show quoted text -

 

[Guest]

Thank You again. What that does is gives me a total of a certain date. But
I want a grand total for the amount between 01/01 and 03/30

Please help thank you

SELECT
Sum([ACT_TRVL]) AS Total,
TRVL_START
FROM
tblAttendan
WHERE
TRVL_START between #1/1/2007# And #3/30/2007#;
GROUP BY
TRVL_START

Hi and thank you for your response. What I want is to have the amounts for
each time plus a grand total that is between the dates. What I am getting
from your SQL is that grand total but no dates....

Please help thank you!

SELECT
Sum([ACT_TRVL]) AS Total
FROM
tblAttendan
WHERE
TRVL_START between #1/1/2007# And #3/30/2007#;

Give that a try.

Cheers,
Jason Lepack

Please help I am new to Access.

I get a Aggregate Funcition error from Trvl_Start when I try to run this
where am I going wrong?

SELECT Sum([ACT_TRVL]) AS Total, tblAttendan.TRVL_START
FROM tblAttendan
WHERE (((tblAttendan.TRVL_START)>#1/1/2007# And
(tblAttendan.TRVL_START)<#3/30/2007#));

Thank You.....- Hide quoted text -

- Show quoted text -

 

[Jason Lepack]

"But I want a grand total for the amount between 01/01 and 03/30"
That's what the first query I gave you did.

Show me sample input and expected output before I can help you any
more.

Cheers,
Jason Lepack

Thank You again. What that does is gives me a total of a certain date. But
I want a grand total for the amount between 01/01 and 03/30

Please help thank you

SELECT
Sum([ACT_TRVL]) AS Total,
TRVL_START
FROM
tblAttendan
WHERE
TRVL_START between #1/1/2007# And #3/30/2007#;
GROUP BY
TRVL_START

Hi and thank you for your response. What I want is to have the amounts for
each time plus a grand total that is between the dates. What I am getting
from your SQL is that grand total but no dates....
Please help thank you!
:
SELECT
Sum([ACT_TRVL]) AS Total
FROM
tblAttendan
WHERE
TRVL_START between #1/1/2007# And #3/30/2007#;
Give that a try.
Cheers,
Jason Lepack
Please help I am new to Access.
I get a Aggregate Funcition error from Trvl_Start when I try to run this
where am I going wrong?
SELECT Sum([ACT_TRVL]) AS Total, tblAttendan.TRVL_START
FROM tblAttendan
WHERE (((tblAttendan.TRVL_START)>#1/1/2007# And
(tblAttendan.TRVL_START)<#3/30/2007#));
Thank You.....- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[Guest]

Thank You for any help..

Examples:

01/01/2007 total for that date: $500.00 (Act_Trvl)
02/01/2007 total for that date: $600.00 (Act_Trvl)
03/30/2007 total for that date: $500.00 (Act_Trvl)

Grandtotal: $1600.00 (Totals)

Your first query only gave Totals (1600.00)

This is what I want...

Thank you again and please help....

"But I want a grand total for the amount between 01/01 and 03/30"
That's what the first query I gave you did.

Show me sample input and expected output before I can help you any
more.

Cheers,
Jason Lepack

Thank You again. What that does is gives me a total of a certain date. But
I want a grand total for the amount between 01/01 and 03/30

Please help thank you

SELECT
Sum([ACT_TRVL]) AS Total,
TRVL_START
FROM
tblAttendan
WHERE
TRVL_START between #1/1/2007# And #3/30/2007#;
GROUP BY
TRVL_START

Hi and thank you for your response. What I want is to have the amounts for
each time plus a grand total that is between the dates. What I am getting
from your SQL is that grand total but no dates....

Please help thank you!

:
SELECT
Sum([ACT_TRVL]) AS Total
FROM
tblAttendan
WHERE
TRVL_START between #1/1/2007# And #3/30/2007#;

Give that a try.

Cheers,
Jason Lepack

Please help I am new to Access.

I get a Aggregate Funcition error from Trvl_Start when I try to run this
where am I going wrong?

SELECT Sum([ACT_TRVL]) AS Total, tblAttendan.TRVL_START
FROM tblAttendan
WHERE (((tblAttendan.TRVL_START)>#1/1/2007# And
(tblAttendan.TRVL_START)<#3/30/2007#));

Thank You.....- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[Jason Lepack]

You need a report, not a query. Use the second query that I gave you
and use the Access report wizard to help give you the grand total.

Cheers,
Jason Lepack

Thank You for any help..

Examples:

01/01/2007 total for that date: $500.00 (Act_Trvl)
02/01/2007 total for that date: $600.00 (Act_Trvl)
03/30/2007 total for that date: $500.00 (Act_Trvl)

Grandtotal: $1600.00 (Totals)

Your first query only gave Totals (1600.00)

This is what I want...

Thank you again and please help....

"But I want a grand total for the amount between 01/01 and 03/30"
That's what the first query I gave you did.

Show me sample input and expected output before I can help you any
more.

Cheers,
Jason Lepack

Thank You again. What that does is gives me a total of a certain date. But
I want a grand total for the amount between 01/01 and 03/30
Please help thank you
:
SELECT
Sum([ACT_TRVL]) AS Total,
TRVL_START
FROM
tblAttendan
WHERE
TRVL_START between #1/1/2007# And #3/30/2007#;
GROUP BY
TRVL_START
Hi and thank you for your response. What I want is to have the amounts for
each time plus a grand total that is between the dates. What I am getting
from your SQL is that grand total but no dates....
Please help thank you!
:
SELECT
Sum([ACT_TRVL]) AS Total
FROM
tblAttendan
WHERE
TRVL_START between #1/1/2007# And #3/30/2007#;
Give that a try.
Cheers,
Jason Lepack
Please help I am new to Access.
I get a Aggregate Funcition error from Trvl_Start when I try to run this
where am I going wrong?
SELECT Sum([ACT_TRVL]) AS Total, tblAttendan.TRVL_START
FROM tblAttendan
WHERE (((tblAttendan.TRVL_START)>#1/1/2007# And
(tblAttendan.TRVL_START)<#3/30/2007#));
Thank You.....- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -