how to match the value in report~

[sallyGals]

i wan to create a report which was include 7 sub report.....but i faced problem when i view report...
the problem is like this:
when there is no input,we have to take the existing record in one form to display in the report... (the frm name is frmStatorEvaluation; in this form, user don need to key in data everyday coz the same record may use for several days),but in da report,if user select to view the day that they wan to view only, but it show all the days record out...izzit any way can solve this problem?
thx for ur kindness help,..i really need help ..

 

[dhookom]

Forms don't have "existing record". Tables and queries have records.

Beyond that, I don't have a clue what you are asking. It might help if you described your tables and data and what you want to display in a report. It is also appropriate to not challenge us with stuff like "izzit", "ur", "coz", "don", "da",...

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[sallyGals]

table's field are shift,supervisorName1,supervisorName2,DirectHeadcount,IndirectHeadcount,plan,reason,actual.
if i do not want to keep the record when i add new record,what should i do?
Besides,i also forgot to mention some things.In the report,user just want to display date 02-02-06,but if there was no input on this day,it does not show the result in the report...so now i wan to make it that if there was no input on the day user want to display,it automatically search the previous day until it get the record to display.it means that the table only hav one record.

thank you for your kindness helping.

 

[dhookom]

If you don't want to "keep the record" then you should delete it when you no longer need to keep it.

How can you talk about dates when there is no date field in your table?

I am still very confused .

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[sallyGals]

well,let me explain more detail,sorry if make you confuse..
As i mention before,my report have 7 subreport,4 subreport are ok,but the problem is another 3 subreport. These 3 subreport's data are retrieve from frmlotcreated2.The problem is in this frmlotcreated2.In this form,user didnt key in data everyday,because the same data can be use for several day,so i only wan to save one record.
Before we view the report,we can select the date that we wan to view..
example:
(frmlotcreated2's record source is tblDailyEvaluation)
i had save one record in tblDailyEvaluation at 2-2-06, when i want to view report at 5-2-06,the report were ask me to enter parameter value.But if i click ok,the report is display empty value.
so now what i want to do is i want to create a command button to view the report ,and i want to make the command button work as before it open the report,it will serching the record until it find the record in 2-2-06.

 

[dhookom]

Report data isn't retrieved from forms. Data is retrieved from tables and/or queries.

If you want a subreport to show only the last record, you can set its record source to something like:

SELECT Top 1 * FROM tblDailyEvaluation ORDER BY SomeDateField DESC;

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[sallyGals]

thx,i will try it.