Problem Regarding Report

[glen]

Hi Friends,
First of all sorry for my poor English.


I created one form now I want to create Report for it.
but I have little bit confusion which I cannot solve.Plz help me.
I attached two photos one of form and one of Report I want that when I click report it show me only record of specific page not all records.
but when i make report it showing record of all data which i don't know how to solve.
plz help me.

[June7]

You want report to show records for only sender QRST? Filter the report. This is really basic Access functionality and Access Help has guidelines.

Options:

1. criteria parameter in the report recordsource that refers to the sender field on form
Review http://datapigtechnologies.com/flash...mtoreport.html

2. code that sets WHERE CONDITION argument of DoCmd.OpenReport, like:
DoCmd.OpenReport "your report name here", , , "Sender='" & Me.Sender & "'"
Review http://office.microsoft.com/en-us/ac...010341717.aspx

[glen]

Thank you Mr. June you really helped me.
Now I have one question more.
Look in form there I put ID which is not associated with table. I want to put auto number here which only show here in form and in Report.
what is the procedure?

[June7]

You want a sequential number? Not easy in form, I'm not even going to try. Textbox in report has RunningSum property. Put expression in ControlSource: =1
http://office.microsoft.com/en-us/ac...005187388.aspx

[glen]

Thanks June,
I get in Report but if there is some procedure for Form or I have to put manually?
Bcoz without serial it not looking good.

[June7]

Okay, if you really want to, explore this http://www.lebans.com/rownumber.htm

[glen]

Thank you June.
I think it is very difficult for me to get this procedure.May be in future when I know more about access then I can do it.
But Now I have two other problems, see in attached pic I put the function : =nz(sum([field2]),0)
But it add only the first three rows.But the same function in field1 is working fine.
Secondly if I want to filter Report by date means to show me Records from date to date only what is procedure for this.
Thanks in advance

[June7]

Yes, dynamic numbering in query or on form is tricky. The code works but some users find that it is very, very slow.

I don't know why the function fails. I would have to examine database.

You have same filter options as in post 2. Filtering can have multiple parameters.

[glen]

Please tell me about this filtering in little detail.
what will be the criteria in date field?

[June7]

Option 1: Forms!formname!DateTextboxName

Option 2:
DoCmd.OpenReport "your report name here", , , "Sender='" & Me.Sender & "' AND DateField=#" & Me.SentDate & "#"

Problem with either is that a date value must be provided else no records will return. Also, in Option 2 a Sender must be provided unless change the code to use LIKE and wildcard.

Option 2 could have conditional code that builds filter string with only the controls that have a value. This article has a sample db demonstrating this approach http://allenbrowne.com/ser-62.html

[glen]

John here I am attaching my database you check and solve the problem.Thanks
also if possible please add the date filter in it.
file size was big therefore I uploaded on 4shared.
http://www.4shared.com/get/A9ulo995/...er_-_Copy.html

[June7]

I don't like 4Shared site, Box.com is friendlier. 4Shared seems to insist I download some software and I won't do that. Can't get your file.

However, you need to work on writing the code for the filter string. You have adequate examples to use. Write code and post for analysis when you encounter issue.

[glen]

John this date filter is working properly.
But I want to know that if I want to show me records from 1-8-12 to 20-8-12 only then what will be procedure?

[glen]

https://www.box.com/files/0/f/0/1/f_...1/f_2912636739
Mr. June plz check this database.

[June7]

The criteria could be: datefield BETWEEN StartDate AND EndDate

If you use Option1, the criteria would be:

BETWEEN Nz(Forms!formname!StartDate,#1/1/1900#) AND Nz(Forms!formname!EndDate,#12/31/2900#)