Aug 5 2004, 02:15 PM
Hi guys, i`ve got a report where i Would like to calculate a field. Here is what I have.
So on my form i have a list box with 3 choices. First one is PTP, next one is PTI and PTC.
Into my report that i`ve done I would like to be able to have the results for PTP only, another report for PTI only and so on. Is there any code that I have to put somewhere, help me please I am Lost
Also with ACCESS is there anyway to do a report that will update himself, what I mean is that for exemple if i have 3 calls today for PTP, i would have a report that would tell`s me DAILY WEEKLY AND MONTHLY, is that possible. Thx guys
Aug 5 2004, 02:55 PM
Answer to your first question.
You can control which items (PIP, PTI, PTC) show up by restricting the recordsource of your report to only show records WHERE YourFieldName="PIP" etc.
For your second question you can do a similiar modification to your query, where you restrict the date field in the query to only show dates for the current week or month.
Aug 5 2004, 03:12 PM
thx for replying to me, but i don`t find record source anywhere, i am pretty new with MS acess, do i have to open my report under design, and go on the field. Do you have an exemple Please.
And for the reports regarding my 2e question, do u know a few sites with examples. thx for r hel;p
Aug 6 2004, 07:32 AM
In design view of your report right click on the detail section to bring up the properties sheet. Then click on the data tab. This is where the recordsource is at.
For the second part:
You can create a query that will be used as the recordsource of your report. In this query you can place criteria on fields from your tables. For example in the SELECT statement above I restricted the tables year field to "2004".
Aug 6 2004, 07:59 AM
Hey Jacob i am looking all over the place in MS ACCESS, been in my report view, clocked on detail, properties, but i got nothing uner data tab. Is this normal.
Aug 6 2004, 08:44 AM
Click on the part of the design view where you cannot drop controls. It is usually greyish black and is the part not on the detail secion.
I am sorry for telling you to click on the detail section. clicking the detail section will bring up the properties for the detail section and not for the report. You need to click somewhere away from the header/footer and detail section. Then the data tab will have a recordsource available for you to create or select the query or table you would like to use as the source of the object.
Aug 6 2004, 09:13 AM
Just figured it out
Took me sometimes but hey theys
Have a nice Day
Aug 6 2004, 09:48 AM
just testing the reply
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here