473,320 Members | 1,936 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Can MsAccess help me in this application?

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
2 1166
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: daimler | last post by:
is there a way to enter texts into msaccess 2000 form from vba form codes? i am using dao automation ole to open the msaccess 2000 form but cannot seem to enter texts into the form's cell through...
3
by: Brad Burke | last post by:
From a windows .Net app, I need to 1) check if MSAccess is already open to a certain Access application. If so, then open a form and find a certain record. 2) If not open, then open MSAccess and...
1
by: mounirfg | last post by:
How to programatically check from within a MSAccess application (A) if another MSAccess application (B which is not another instance of A) is currently open
15
by: (Pete Cresswell) | last post by:
I've got a .BAT file that I use for executing various MS Access apps that I wrote way back in the days of 2.0. It's evolved over time, but it still contains a number of possible paths to...
0
by: Richard Beacroft | last post by:
Trying to write a C# Windows App to export all objects and content from 2 MSAccess 97 databases for comparison analysis. very little documentation found. Have managed to instantiate MSAccess,...
4
by: Annick Van Hoof | last post by:
Hi, I'm having my ASP.NET application hosted at a Windows 2003 server (IIS6). This works almost all the time (I have uptimes of 100% on most days), but then all of a sudden a few days in a row I...
2
by: reidarT | last post by:
I am making an installation program for an Access application. The application is run on both Office 2000, 2002, 2003 and soon 2007 versions of Office, When I install the application I need a...
1
by: mike.arsenault | last post by:
Hi there, Have a couple of questions about applications developed using MSAccess. 1. Is there a way to run and use you application OUTSIDE of the MSAccess main window? In other words, can you...
0
by: bbrewder | last post by:
I am struggling with some MSAccess automation issues. Basically, we have a .Net application that uses MSAccess for reporting (legacy code). We are able to launch MSAccess fine and even work with...
9
by: jdaelhousen | last post by:
I have a bit of a problem I'm hoping someone can shed some light on... I have a VB.Net console application written in VS 2003 that produces a .exe file that now sits on a Windows 2000 server...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.