diplaying contents of required date and also the sum of contents

  • Thread starter Thread starter naveen prasad
  • Start date Start date
N

naveen prasad

Good day..
dear all kindly help me in this.

I have created a table d1 with fields date, r1,r2

r1,r2 are numeric values.

I want to display contents as per required date along with the sum at bottom


like example 20/09/09 20 40
20/09/09 10 50
20/09/09 15 100
19/09/09 25 20
19/09/09 10 10
18/09/09 45 45
17/09/09 10 10
17/09/09 15 15

now if is select query as select * from d1 where date =20/09/09;
it will give result like below its fine but i want sum of
individual column total also
20/09/09 20 40
20/09/09 10 50
20/09/09 15 100


need like 45 190 also at bottom.

pls help me
 
Use that query as the basis for a report. You can then have the totals show
at the bottom of the report footer or group footer.

If you only want specific dates change 20/09/09 to [Enter the Date] then put
[Enter the Date] in the parameters as Date/Time. It will then prompt you for
the date when running the query.
 
Dear it will ask the date at runtime only , but the result is only the
contents matching date,

what i require is contents matching date + sum of diplayed content of row.

like below i described below the wanted result

Jerry Whittle said:
Use that query as the basis for a report. You can then have the totals show
at the bottom of the report footer or group footer.

If you only want specific dates change 20/09/09 to [Enter the Date] then put
[Enter the Date] in the parameters as Date/Time. It will then prompt you for
the date when running the query.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


naveen prasad said:
Good day..
dear all kindly help me in this.

I have created a table d1 with fields date, r1,r2

r1,r2 are numeric values.

I want to display contents as per required date along with the sum at bottom


like example 20/09/09 20 40
20/09/09 10 50
20/09/09 15 100
19/09/09 25 20
19/09/09 10 10
18/09/09 45 45
17/09/09 10 10
17/09/09 15 15

now if is select query as select * from d1 where date =20/09/09;
it will give result like below its fine but i want sum of
individual column total also
20/09/09 20 40
20/09/09 10 50
20/09/09 15 100


need like 45 190 also at bottom.

pls help me
Click to expand...
Click to expand...
 
I posted the answer yesterday and you said it "Excellent dear your formula
made my problem solved."

You continue to ask peices of the same thing but just tweaked a little each
time then repeat with another twist.

Why not post what you are really looky for all at once?

--
Build a little, test a little.


naveen prasad said:
Dear it will ask the date at runtime only , but the result is only the
contents matching date,

what i require is contents matching date + sum of diplayed content of row.

like below i described below the wanted result

Jerry Whittle said:
Use that query as the basis for a report. You can then have the totals show
at the bottom of the report footer or group footer.

If you only want specific dates change 20/09/09 to [Enter the Date] then put
[Enter the Date] in the parameters as Date/Time. It will then prompt you for
the date when running the query.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


naveen prasad said:
Good day..
dear all kindly help me in this.

I have created a table d1 with fields date, r1,r2

r1,r2 are numeric values.

I want to display contents as per required date along with the sum at bottom


like example 20/09/09 20 40
20/09/09 10 50
20/09/09 15 100
19/09/09 25 20
19/09/09 10 10
18/09/09 45 45
17/09/09 10 10
17/09/09 15 15

now if is select query as select * from d1 where date =20/09/09;
it will give result like below its fine but i want sum of
individual column total also
20/09/09 20 40
20/09/09 10 50
20/09/09 15 100


need like 45 190 also at bottom.

pls help me
Click to expand...
Click to expand...
Click to expand...
 
Dear, that was a different problem i asked , and now i requested for the
below query, this query is regarding displaying contents and sum of diplayed
row contents of required date.


regards

KARL DEWEY said:
I posted the answer yesterday and you said it "Excellent dear your formula
made my problem solved."

You continue to ask peices of the same thing but just tweaked a little each
time then repeat with another twist.

Why not post what you are really looky for all at once?

--
Build a little, test a little.


naveen prasad said:
Dear it will ask the date at runtime only , but the result is only the
contents matching date,

what i require is contents matching date + sum of diplayed content of row.

like below i described below the wanted result

Jerry Whittle said:
Use that query as the basis for a report. You can then have the totals show
at the bottom of the report footer or group footer.

If you only want specific dates change 20/09/09 to [Enter the Date] then put
[Enter the Date] in the parameters as Date/Time. It will then prompt you for
the date when running the query.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


:

Good day..
dear all kindly help me in this.

I have created a table d1 with fields date, r1,r2

r1,r2 are numeric values.

I want to display contents as per required date along with the sum at bottom


like example 20/09/09 20 40
20/09/09 10 50
20/09/09 15 100
19/09/09 25 20
19/09/09 10 10
18/09/09 45 45
17/09/09 10 10
17/09/09 15 15

now if is select query as select * from d1 where date =20/09/09;
it will give result like below its fine but i want sum of
individual column total also
20/09/09 20 40
20/09/09 10 50
20/09/09 15 100


need like 45 190 also at bottom.

pls help me
Click to expand...
Click to expand...
Click to expand...
 
Just add date criteria to what I posted.
--
Build a little, test a little.


naveen prasad said:
Dear, that was a different problem i asked , and now i requested for the
below query, this query is regarding displaying contents and sum of diplayed
row contents of required date.


regards

KARL DEWEY said:
I posted the answer yesterday and you said it "Excellent dear your formula
made my problem solved."

You continue to ask peices of the same thing but just tweaked a little each
time then repeat with another twist.

Why not post what you are really looky for all at once?

--
Build a little, test a little.


naveen prasad said:
Dear it will ask the date at runtime only , but the result is only the
contents matching date,

what i require is contents matching date + sum of diplayed content of row.

like below i described below the wanted result

:

Use that query as the basis for a report. You can then have the totals show
at the bottom of the report footer or group footer.

If you only want specific dates change 20/09/09 to [Enter the Date] then put
[Enter the Date] in the parameters as Date/Time. It will then prompt you for
the date when running the query.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


:

Good day..
dear all kindly help me in this.

I have created a table d1 with fields date, r1,r2

r1,r2 are numeric values.

I want to display contents as per required date along with the sum at bottom


like example 20/09/09 20 40
20/09/09 10 50
20/09/09 15 100
19/09/09 25 20
19/09/09 10 10
18/09/09 45 45
17/09/09 10 10
17/09/09 15 15

now if is select query as select * from d1 where date =20/09/09;
it will give result like below its fine but i want sum of
individual column total also
20/09/09 20 40
20/09/09 10 50
20/09/09 15 100


need like 45 190 also at bottom.

pls help me
Click to expand...
Click to expand...
Click to expand...
 
Dear , i tested the same yesterday only , it is giving result

displaying complete contents like all dates contents but at bottom giving
the sum of only selected date.

what i require is diplay contents of only selected date along with sum of
only selected date contents at bottom.


KARL DEWEY said:
Just add date criteria to what I posted.
--
Build a little, test a little.


naveen prasad said:
Dear, that was a different problem i asked , and now i requested for the
below query, this query is regarding displaying contents and sum of diplayed
row contents of required date.


regards

KARL DEWEY said:
I posted the answer yesterday and you said it "Excellent dear your formula
made my problem solved."

You continue to ask peices of the same thing but just tweaked a little each
time then repeat with another twist.

Why not post what you are really looky for all at once?

--
Build a little, test a little.


:

Dear it will ask the date at runtime only , but the result is only the
contents matching date,

what i require is contents matching date + sum of diplayed content of row.

like below i described below the wanted result

:

Use that query as the basis for a report. You can then have the totals show
at the bottom of the report footer or group footer.

If you only want specific dates change 20/09/09 to [Enter the Date] then put
[Enter the Date] in the parameters as Date/Time. It will then prompt you for
the date when running the query.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


:

Good day..
dear all kindly help me in this.

I have created a table d1 with fields date, r1,r2

r1,r2 are numeric values.

I want to display contents as per required date along with the sum at bottom


like example 20/09/09 20 40
20/09/09 10 50
20/09/09 15 100
19/09/09 25 20
19/09/09 10 10
18/09/09 45 45
17/09/09 10 10
17/09/09 15 15

now if is select query as select * from d1 where date =20/09/09;
it will give result like below its fine but i want sum of
individual column total also
20/09/09 20 40
20/09/09 10 50
20/09/09 15 100


need like 45 190 also at bottom.

pls help me
Click to expand...
Click to expand...
Click to expand...
 
The date criteria must be placed in both parts of the union query.
--
Build a little, test a little.


naveen prasad said:
Dear , i tested the same yesterday only , it is giving result

displaying complete contents like all dates contents but at bottom giving
the sum of only selected date.

what i require is diplay contents of only selected date along with sum of
only selected date contents at bottom.


KARL DEWEY said:
Just add date criteria to what I posted.
--
Build a little, test a little.


naveen prasad said:
Dear, that was a different problem i asked , and now i requested for the
below query, this query is regarding displaying contents and sum of diplayed
row contents of required date.


regards

:

I posted the answer yesterday and you said it "Excellent dear your formula
made my problem solved."

You continue to ask peices of the same thing but just tweaked a little each
time then repeat with another twist.

Why not post what you are really looky for all at once?

--
Build a little, test a little.


:

Dear it will ask the date at runtime only , but the result is only the
contents matching date,

what i require is contents matching date + sum of diplayed content of row.

like below i described below the wanted result

:

Use that query as the basis for a report. You can then have the totals show
at the bottom of the report footer or group footer.

If you only want specific dates change 20/09/09 to [Enter the Date] then put
[Enter the Date] in the parameters as Date/Time. It will then prompt you for
the date when running the query.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


:

Good day..
dear all kindly help me in this.

I have created a table d1 with fields date, r1,r2

r1,r2 are numeric values.

I want to display contents as per required date along with the sum at bottom


like example 20/09/09 20 40
20/09/09 10 50
20/09/09 15 100
19/09/09 25 20
19/09/09 10 10
18/09/09 45 45
17/09/09 10 10
17/09/09 15 15

now if is select query as select * from d1 where date =20/09/09;
it will give result like below its fine but i want sum of
individual column total also
20/09/09 20 40
20/09/09 10 50
20/09/09 15 100


need like 45 190 also at bottom.

pls help me
Click to expand...
Click to expand...
Click to expand...
 
Got it dear,
Thank you very much for your kind co-operation.



regards


KARL DEWEY said:
The date criteria must be placed in both parts of the union query.
--
Build a little, test a little.


naveen prasad said:
Dear , i tested the same yesterday only , it is giving result

displaying complete contents like all dates contents but at bottom giving
the sum of only selected date.

what i require is diplay contents of only selected date along with sum of
only selected date contents at bottom.


KARL DEWEY said:
Just add date criteria to what I posted.
--
Build a little, test a little.


:

Dear, that was a different problem i asked , and now i requested for the
below query, this query is regarding displaying contents and sum of diplayed
row contents of required date.


regards

:

I posted the answer yesterday and you said it "Excellent dear your formula
made my problem solved."

You continue to ask peices of the same thing but just tweaked a little each
time then repeat with another twist.

Why not post what you are really looky for all at once?

--
Build a little, test a little.


:

Dear it will ask the date at runtime only , but the result is only the
contents matching date,

what i require is contents matching date + sum of diplayed content of row.

like below i described below the wanted result

:

Use that query as the basis for a report. You can then have the totals show
at the bottom of the report footer or group footer.

If you only want specific dates change 20/09/09 to [Enter the Date] then put
[Enter the Date] in the parameters as Date/Time. It will then prompt you for
the date when running the query.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


:

Good day..
dear all kindly help me in this.

I have created a table d1 with fields date, r1,r2

r1,r2 are numeric values.

I want to display contents as per required date along with the sum at bottom


like example 20/09/09 20 40
20/09/09 10 50
20/09/09 15 100
19/09/09 25 20
19/09/09 10 10
18/09/09 45 45
17/09/09 10 10
17/09/09 15 15

now if is select query as select * from d1 where date =20/09/09;
it will give result like below its fine but i want sum of
individual column total also
20/09/09 20 40
20/09/09 10 50
20/09/09 15 100


need like 45 190 also at bottom.

pls help me
Click to expand...
Click to expand...
Click to expand...
 
Back
Top