Hi,

First of all, this is a naive question and I am not sure if Ms Access
help me automatically generate a report.

An experiment data are recorded in A.rec. This text file looks like the
following and the first line are field names.

======A.Rec=======

Address, Time, Duration, Param1, Param2, Param3, Parma4
1, 05/05/2005 10:00am, 00:05:00, 12.1, 23.3, 22.2, 43.0
2, 05/05/2005 10:05am, 00:05:00, 12.7, 23.2, 22.1, 43.1
3, 05/05/2005 10:10am, 00:05:00, 13.0, 22.8, 23.2, 42.7
4, 05/05/2005 10:25am, 00:05:00, 12.8, 22.9, 22.6, 42.6
5, 05/05/2005 10:20am, 00:05:00, 13.1, 22.8, 23.7, 42.5
6, 05/05/2005 10:35am, 00:05:00, 12.9, 23.1, 23.1, 42.7
......
1024,05/13/2005 7:35pm, 00:05:00, 11.9, 22.7, 23.4, 42.2

==================

What I want to do is to extract every five address, present them in a
report with a plot showing the variation of ParamX along time.

I managed to import the file into MSAccess manually, but dont know how
to extract the right row, how to draw a graph in a report and how to
automate all the process?

Wish you could give me some good link. Thanks.

Sincerely.

Leas.

In a query use the mod function and test the remainder = 0

result = number1 Mod number2

In your case number 1 would be the address and number 2 = 5. Therefore
the filter would only return all addresses that are evenly divisible by
5.

SELECT Table1.Address, [Address] Mod 5 AS Expr1, Table1.Test
FROM Table1
WHERE ((([Address] Mod 5)=0));

This sample query returns only the records where the Address is an
increment of 5.

I would probably make a MakeTable query and link the graph to the new
table since it's easier to handle.

Thank you very much for the reply.

I don't know if it is true that in some applications Visula Basic works
intimately with MsAccess. Is it a common approach to write some code in
VB to import A.Rec to MsAccess, impose queries on the table, generate a
customized report and plot a figure?

Thanks for your advice.

Leas