Re: Not just returning value of selected record

It sounds like you can present this information in a map with location names
and a corresponding table that lists the serial numbers at each location. I
think I understand what you're trying to achieve, but it seems impractical
because a desk may have no items or it could have 10 items. Is there enough
space to list 10 serial numbers? What happens if that list needs to grow
even further?

If you really want to do it your way, create an empty table of locations
(unique) and serial numbers. Then, use an update query to add each serial
number field by joining with your original table on the field location and
something like:

IIF(IsNull([Serial Number]),[OriginalSerialNumber],[Serial Number] & ", " &
[OriginalSerialNumber])

The result will be a list of locations and all of the serial numbers at that
location. Then, you can place a textbox at each location and draw the data
from the newly populated serial number field. You'll find more information
about doing this if you search for "transpose" or "concatenate" in these
forums.


littlevikinggirl@xxxxxxxxxxx wrote:
Thanks for the suggestion but the problem I have with using a query is
that there is more than one position I want to display, closer in fact
to 100. So I'd have to write a query for position1, another for
position2, and so on. I can't do it by prompting user input
([Location:] in criteria) as again I want to display multiple values,
not just the one for position1.

Maybe I need to describe my problem better? Say there is a floor plan
of an office and you want to display the serial number of each PC,
printer etc on the floor plan. They are all stored in the table but
with names like "desk1" and "desk2" as the locations and people may
not know where these positions relate to physically. So I want to have
numerous text boxes on the form, each one evaluating a different
location in the table in order to give a visual representation of the
locations.

Hope this makes more sense now and if I'm wrong about the query /
still not using it correctly then please let me know,

thanks again

little viking girl

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200703/1

.

Relevant Pages

  • list only most recent event in a query
    ... I want to display a record of only the most recent courses ... ie if they attended a course in 2001, a refresher in 2002 ... I have tried using the Max function on the query on the ... but it still lists the earlier ...
    (microsoft.public.access.queries)
  • Re: help with date query
    ... I just want to display the month ie Jan ... One column list numbers 1 to 12 and the other lists months Jan to Dec ... I set the criteria to point to the combo box. ... add a computed field Monthto the query ...
    (microsoft.public.access.gettingstarted)
  • Re: Different behavior with list box and combo box
    ... You *could* populate the list/combo box with a query but, ... the list would display the same members for each record on ... then the lists would indeed be the same. ... Change the ", " in the function to vbCrLf, so that the focus areas are on ...
    (microsoft.public.access.formscoding)
  • Month Format
    ... Can you help me format a field in a Query that not only ... I am able to display ... but when I sort the query it lists the month ...
    (microsoft.public.access.queries)
  • RE: Weird Problem with a Subreport
    ... Ok for the sorting i will try to explain it to you. ... query by writing the SQL I didnt include the Place holder field, ... Do you have a text box in the Goup Header? ... I have a header of shutdown in front of the whole list but the two lists ...
    (microsoft.public.access.reports)