Listbox and reports

  • Thread starter Thread starter =?ISO-8859-1?Q?=D8ystein_Sund?=
  • Start date Start date
?

=?ISO-8859-1?Q?=D8ystein_Sund?=

I've got a report that's supposed to have a listbox that looks up error
codes from a table that has a relation to another table. This list is
going to look up this based on an ID number from the other table.

The report will look like this:
ID feilkoder (listbox)
56 doa
dead


The report I've made so far looks like this (without a listbox):
ID feilkoder
56 doa
56 dead


This is not so very practical since a lot of data will be printed i
duplicates (data that I've not included in this example).

So my question is, when Access generates a report, is it possible to get
a value from each post it generates?

Whith MySQL and PHP this would have been pretty easy, but not in Access
when I don't know how. Therefore I wondered if Access uses some internal
variables for each post when it generates a report?

Is there some other way to get the value I need for the rowsource to the
listbox?

Any help, other recommandations or suggestions would be highly appreciated!


Sincerely
Oystein Sund
(from a little place called Norway ;-))
 
Oystein,
IT is difficult to understand what you want.
Is it correct to say that the Fail code? (FeilKoder) is the value you want
to display for ID 56?
Is it correct to say ID 56 can have two possible values - doa and dead?
Do you want to display ID once and just a list of values after that?

HS
 
HSalim said:
Oystein,
IT is difficult to understand what you want.
Is it correct to say that the Fail code? (FeilKoder) is the value you want
to display for ID 56?
Is it correct to say ID 56 can have two possible values - doa and dead?
Do you want to display ID once and just a list of values after that?

HS
Click to expand...


That's right! Sorry for the missing translation. It must have slipped
thru when I translated for Norwegian to English.

There is a table called failcodes (or error codes), a table called
service and a table called service_failcodes.

The table called failcodes has a list of failcodes to use in a service.
The failcodes that are selected is put into the table service_failcodes
with the ID from a post from the table service and the ID of the
selected failcode from the table failcodes.

The report I am making is going to be like I explained at first like this:
ID failcodes (listbox)
56 doa
dead

Not like this:
ID feilkoder
56 doa
56 dead

If there is any other way than using a listbox for this, please explain.


Sincerely
Øystein Sund
 
Back
Top