Hi guys, i`ve got a report where i Would like to calculate a field. Here is what I have.

TABLES=CUSTOMER
REPORT=BETA
FORM=MAINMENU

So on my form i have a list box with 3 choices. First one is PTP, next one is PTI and PTC.
PTP
PTI
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

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.

Hi Jacob,

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

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:

SELECT tblMyTable.FieldName
FROM tblMyTable
WHERE tblMyTable.Year=2004

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".

Good Luck!

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.

thx

Sorry...

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.

Sorry again.

Thx Jacob,

Just figured it out (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif) Took me sometimes but hey theys (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif) to you.
Have a nice Day

just testing the reply