Creating a report from imported data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dale - 14 Mar 2006 17:43 GMT

Hi all,

New to access programming. I'm using access 2003.

I'm programatically importing a FoxPro/Dbase table which I've managed to do
and I'll eventually want to report some findings to an access report.

However, in the interim, I need some help as to how I would programatically
retreive those findings and what commands I should study up on to retrieve
that data.

I need to

1. Get the field (column) names
2. Get the field size
3. The size of the longest record in each field
4. The number of populated fields in each field
5. The value (text) of the longest record in each field

6. The number of fields
7. The number of records

I guess what I really need is a good primer.

Reply to this Message

KARL DEWEY - 16 Mar 2006 07:14 GMT

You are really mixing your terms up.

> 3. The size of the longest record in each field

Records have fields not the other way around.

> 4. The number of populated fields in each field

It would be number of populated fields in a record.

> 5. The value (text) of the longest record in each field

It would be the longest data string in a record/field

A database has tables. Tables have records. Records have fields. Fields
contain data. Think of it as a filing cabinet, drawers, folders, binders,
papers/pages, paragraphs, sentences, words, and letters.

Use the TOOLS - Analyzer - Documentor. Select your table and click on the
options and select what you want to see. Click OK to run. You can save it
to Word to better hunt through it.

> Hi all,
>
[quoted text clipped - 19 lines]
>
> I guess what I really need is a good primer.

Reply to this Message