Repeating parameter queries and counting

J

Jakki

Each year I need to create a report from raw data extracted from another
program.

The report will contain a single line of text with a field for the total at
the end of the text.

I would like to create a parameter query to extract each line of data needed
on the report as this raw data changes each year.

I also want to count each answer to my parameter query and insert that
amount in a field on the report.

After insertion I want to requery for the next line of text in the report
until complete.

I would like to know if this is at all possible?

Thanx,
 
K

KARL DEWEY

How are you getting a total for a single line of text? Come on now give us
a hint of what the data looks like. It is hard to guess with what little you
gave.
 
J

Jakki

Here is a snippet of the data I will be manipulating:

Col Lv Prg Deg Maj
RW RW MED_RW MD MED
SN NG CLDR MSN CLDR
HP HU DB03 AAS DB03
GS GS GS_MBS MASTER MBS
SN NG CLDR MSN CLDR
SN NG ACC1_NP MSN ACC1
RW RW MED_RW MD MED
RW RW MED_RW MD MED
RW RW MED_RW MD MED
HP HG BI05 MS BI05

On the report each line of data will change based on the total figure needed
and that is based on whether I will use "Lv" and "Deg" or "Prg" and "Deg" or
just "Deg", etc. That is why I chose to use a parameter query to pull on the
data I need. The design of the report is as follows:

DMD [TOTAL]
MS/MASTER [TOTAL]
GDE CERTIFICATES [TOTAL]
GDE/MS [TOTAL]

I appreciate any assistance.
 
K

KARL DEWEY

Did I somehow miss your translation table? How do you get DMD, MS/MASTER, DE
CERTIFICATES, and GDE/MS from the data you posted?

Jakki said:
Here is a snippet of the data I will be manipulating:

Col Lv Prg Deg Maj
RW RW MED_RW MD MED
SN NG CLDR MSN CLDR
HP HU DB03 AAS DB03
GS GS GS_MBS MASTER MBS
SN NG CLDR MSN CLDR
SN NG ACC1_NP MSN ACC1
RW RW MED_RW MD MED
RW RW MED_RW MD MED
RW RW MED_RW MD MED
HP HG BI05 MS BI05

On the report each line of data will change based on the total figure needed
and that is based on whether I will use "Lv" and "Deg" or "Prg" and "Deg" or
just "Deg", etc. That is why I chose to use a parameter query to pull on the
data I need. The design of the report is as follows:

DMD [TOTAL]
MS/MASTER [TOTAL]
GDE CERTIFICATES [TOTAL]
GDE/MS [TOTAL]

I appreciate any assistance.

Jakki said:
Each year I need to create a report from raw data extracted from another
program.

The report will contain a single line of text with a field for the total at
the end of the text.

I would like to create a parameter query to extract each line of data needed
on the report as this raw data changes each year.

I also want to count each answer to my parameter query and insert that
amount in a field on the report.

After insertion I want to requery for the next line of text in the report
until complete.

I would like to know if this is at all possible?

Thanx,
Click to expand...
Click to expand...
 
J

Jakki

The DMD, MS/MASTER, GDE CERTIFICATES and GDE/MS is static text that does not
change from year to year. This report, in essence, is a summary of all the
various degree programs that students are enrolled in. The raw data, which
comes from another program, has a record for every student enrolled in the
various programs, although that data is reported as I previous indicated.

KARL DEWEY said:
Did I somehow miss your translation table? How do you get DMD, MS/MASTER, DE
CERTIFICATES, and GDE/MS from the data you posted?

Jakki said:
Here is a snippet of the data I will be manipulating:

Col Lv Prg Deg Maj
RW RW MED_RW MD MED
SN NG CLDR MSN CLDR
HP HU DB03 AAS DB03
GS GS GS_MBS MASTER MBS
SN NG CLDR MSN CLDR
SN NG ACC1_NP MSN ACC1
RW RW MED_RW MD MED
RW RW MED_RW MD MED
RW RW MED_RW MD MED
HP HG BI05 MS BI05

On the report each line of data will change based on the total figure needed
and that is based on whether I will use "Lv" and "Deg" or "Prg" and "Deg" or
just "Deg", etc. That is why I chose to use a parameter query to pull on the
data I need. The design of the report is as follows:

DMD [TOTAL]
MS/MASTER [TOTAL]
GDE CERTIFICATES [TOTAL]
GDE/MS [TOTAL]

I appreciate any assistance.

Jakki said:
Each year I need to create a report from raw data extracted from another
program.

The report will contain a single line of text with a field for the total at
the end of the text.

I would like to create a parameter query to extract each line of data needed
on the report as this raw data changes each year.

I also want to count each answer to my parameter query and insert that
amount in a field on the report.

After insertion I want to requery for the next line of text in the report
until complete.

I would like to know if this is at all possible?

Thanx,
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

The question is how does the data get translated from one to the other as
there is no correlation?

Jakki said:
The DMD, MS/MASTER, GDE CERTIFICATES and GDE/MS is static text that does not
change from year to year. This report, in essence, is a summary of all the
various degree programs that students are enrolled in. The raw data, which
comes from another program, has a record for every student enrolled in the
various programs, although that data is reported as I previous indicated.

KARL DEWEY said:
Did I somehow miss your translation table? How do you get DMD, MS/MASTER, DE
CERTIFICATES, and GDE/MS from the data you posted?

Jakki said:
Here is a snippet of the data I will be manipulating:

Col Lv Prg Deg Maj
RW RW MED_RW MD MED
SN NG CLDR MSN CLDR
HP HU DB03 AAS DB03
GS GS GS_MBS MASTER MBS
SN NG CLDR MSN CLDR
SN NG ACC1_NP MSN ACC1
RW RW MED_RW MD MED
RW RW MED_RW MD MED
RW RW MED_RW MD MED
HP HG BI05 MS BI05

On the report each line of data will change based on the total figure needed
and that is based on whether I will use "Lv" and "Deg" or "Prg" and "Deg" or
just "Deg", etc. That is why I chose to use a parameter query to pull on the
data I need. The design of the report is as follows:

DMD [TOTAL]
MS/MASTER [TOTAL]
GDE CERTIFICATES [TOTAL]
GDE/MS [TOTAL]

I appreciate any assistance.

:

Each year I need to create a report from raw data extracted from another
program.

The report will contain a single line of text with a field for the total at
the end of the text.

I would like to create a parameter query to extract each line of data needed
on the report as this raw data changes each year.

I also want to count each answer to my parameter query and insert that
amount in a field on the report.

After insertion I want to requery for the next line of text in the report
until complete.

I would like to know if this is at all possible?

Thanx,
Click to expand...
Click to expand...
Click to expand...
 
Top