Help with report from newbie

[micfly]

Just learning so be kind please. Using Access97.



OK, I'm stumped and cannot get past this. Not quite sure how to word this so
bear with me. My main form is built along with the tables to store the data.
Works perfectly as I can navigate through all the deals with no problem. My
problem now is building a simple report.



The report will have, say 3 textboxes (actually more) to show the data:



NewRetail UsedRetail Total

10 15 25



The data: customer name, year, make, model, etc., is entered in the form
FrmTracking. As part of the record the user selects NewRetail or UsedRetail
from a combo box (row source: SELECT DISTINCTROW [TblTransaction].[ID],
[TblTransaction].[Transaction] FROM [TblTransaction]



NewRetail or UsedRetail is stored in the TblTracking table in the field
named Transaction.



Each record has a sold date. What I am trying to do is select a report for
say all records in December, 2008, showing total used, new, and all total.



I have no idea where to begin? How would I start by selecting the month?
What would be the control source be for the report?

I'm guessing a query but not sure. How do I pull this info into the report?
A textbox for NewRetail for example with a control source of what? Another
query I presume? I've been working on this for a week with no avail. Thanks
for any help to get me kick started!

 

[Golfinray]

I generally try to use Datediff commands in the query,
like Datediff("d",[yourfirstdatefield],[yourseconddatefield])
That will give you the difference in days from one date to another.

 

[micfly]

Thanks for helping. Not quite sure how to apply this, though? I only have
one date field in the table.
Still can't figure out how to pull the months records showing total used,
new, and all total?

I generally try to use Datediff commands in the query,
like Datediff("d",[yourfirstdatefield],[yourseconddatefield])
That will give you the difference in days from one date to another.

Just learning so be kind please. Using Access97.



OK, I'm stumped and cannot get past this. Not quite sure how to word this so
bear with me. My main form is built along with the tables to store the data.
Works perfectly as I can navigate through all the deals with no problem. My
problem now is building a simple report.



The report will have, say 3 textboxes (actually more) to show the data:



NewRetail UsedRetail Total

10 15 25



The data: customer name, year, make, model, etc., is entered in the form
FrmTracking. As part of the record the user selects NewRetail or UsedRetail
from a combo box (row source: SELECT DISTINCTROW [TblTransaction].[ID],
[TblTransaction].[Transaction] FROM [TblTransaction]



NewRetail or UsedRetail is stored in the TblTracking table in the field
named Transaction.



Each record has a sold date. What I am trying to do is select a report for
say all records in December, 2008, showing total used, new, and all total.



I have no idea where to begin? How would I start by selecting the month?
What would be the control source be for the report?

I'm guessing a query but not sure. How do I pull this info into the report?
A textbox for NewRetail for example with a control source of what? Another
query I presume? I've been working on this for a week with no avail. Thanks
for any help to get me kick started!

 

[micfly]

Anyone?

Thanks for helping. Not quite sure how to apply this, though? I only have one date field in the table.
Still can't figure out how to pull the months records showing total used, new, and all total?

I generally try to use Datediff commands in the query,
like
Datediff("d",[yourfirstdatefield],[yourseconddatefield])
That will give you the difference in days from one date to another.

Just learning so be kind please. Using Access97.



OK, I'm stumped and cannot get past this. Not quite sure how to word
this so bear with me. My main form is built along with the tables to store the
data. Works perfectly as I can navigate through all the deals with no problem.
My problem now is building a simple report.



The report will have, say 3 textboxes (actually more) to show the data:

NewRetail UsedRetail Total

10 15 25

The data: customer name, year, make, model, etc., is entered in the form
FrmTracking. As part of the record the user selects NewRetail or UsedRetail
from a combo box (row source: SELECT DISTINCTROW [TblTransaction].[ID],
[TblTransaction].[Transaction] FROM [TblTransaction]


NewRetail or UsedRetail is stored in the TblTracking table in the field
named Transaction.


Each record has a sold date. What I am trying to do is select a report
for say all records in December, 2008, showing total used, new, and all total.


I have no idea where to begin? How would I start by selecting the month?
What would be the control source be for the report?

I'm guessing a query but not sure. How do I pull this info into the report?
A textbox for NewRetail for example with a control source of what?
Another query I presume? I've been working on this for a week with no avail.
Thanks for any help to get me kick started!