By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

Can MsAccess help me in this application?

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.