If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup Column to Report
I've searched to see if anyone else has this problem but it doen't
seem so. So the database keeps track of photos sent to be archived. There is a lookup field in the main table that get photographers names from another table. There are often more than one photographer which is why I used that kind of list. The problem is when I go to the report there is a different row for each photographer and all of the other data is duplicated on each row. Does anyone know how to get the photographers to display together? |
#2
|
|||
|
|||
Lookup Column to Report
Put the photographer information in a subreport.
-- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "loki" wrote: I've searched to see if anyone else has this problem but it doen't seem so. So the database keeps track of photos sent to be archived. There is a lookup field in the main table that get photographers names from another table. There are often more than one photographer which is why I used that kind of list. The problem is when I go to the report there is a different row for each photographer and all of the other data is duplicated on each row. Does anyone know how to get the photographers to display together? |
#3
|
|||
|
|||
Lookup Column to Report
I've tried what you said but it is just freezing up Access
On Aug 6, 11:58*am, Jerry Whittle wrote: Put the photographer information in a subreport. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "loki" wrote: I've searched to see if anyone else has this problem but it doen't seem so. So the database keeps track of photos sent to be archived. *There is a lookup field in the main table that get photographers names from another table. *There are often more than one photographer which is why I used that kind of list. The problem is when I go to the report there is a different row for each photographer and all of the other data is duplicated on each row. Does anyone know how to get the photographers to display together?- Hide quoted text - - Show quoted text - |
#4
|
|||
|
|||
Lookup Column to Report
If I'm understanding your description, you have a table with a "lookup" data
type field. A scan through this newsgroup will reveal a strong consensus AGAINST using lookup data types in table definitions. Among other issues, this data type stores one value (the key of the record), while displaying something else (the looked-up value). This leads to confusion. We aren't there. We can't see your data. I don't know what you mean by "a different row for each photographer and all of the other data is duplicated..." Are you describing what happens in a query? Regards Jeff Boyce Microsoft Office/Access MVP "loki" wrote in message ... I've searched to see if anyone else has this problem but it doen't seem so. So the database keeps track of photos sent to be archived. There is a lookup field in the main table that get photographers names from another table. There are often more than one photographer which is why I used that kind of list. The problem is when I go to the report there is a different row for each photographer and all of the other data is duplicated on each row. Does anyone know how to get the photographers to display together? |
#5
|
|||
|
|||
Lookup Column to Report
On Thu, 6 Aug 2009 08:22:00 -0700 (PDT), loki wrote:
I've searched to see if anyone else has this problem but it doen't seem so. So the database keeps track of photos sent to be archived. There is a lookup field in the main table that get photographers names from another table. There are often more than one photographer which is why I used that kind of list. The problem is when I go to the report there is a different row for each photographer and all of the other data is duplicated on each row. Does anyone know how to get the photographers to display together? You don't describe the structure of your tables so it's hard to be sure... note that a Lookup Field is actually a meaningless number that only APPEARS to contain a name. I'm guessing that you're also using A2007's abominable new Multivalued Field to get multiple names... right? Consider using the Report's Sorting and Grouping dialog to group by the photo ID. Put the photo-specific information in the group Header (or Footer) and the photographers' names in the detail section. -- John W. Vinson [MVP] |
#6
|
|||
|
|||
Lookup Column to Report
I have since read comments again the lookup column but it was a great
help in designing this system. Okay so the better description would be; we have a main table named photos. Each row is a batch of photos we got from a specific shop on a specific day. So the row reads Unit, ID, Date, # submitted, Downloaded by, photographers, Notes...and a few others not really necessary to list. So there can only be one unit, id, date, # submitted but there is usually more than one photographer. We need to be able have everything the same in all entries so the important ones are linked to lists: Unit, downloaded by, photographers. The problem that happens is that in the report (arranged by date), there is a different row for every photographer chosen. All of the data corresponding is repeated along with the photographer. So some entries are repeated even six times. I have hid the duplicates to make it easier to read but the empty space remains the same as if the data was there and won't shrink. On Aug 6, 2:51*pm, "Jeff Boyce" wrote: If I'm understanding your description, you have a table with a "lookup" data type field. *A scan through this newsgroup will reveal a strong consensus AGAINST using lookup data types in table definitions. *Among other issues, this data type stores one value (the key of the record), while displaying something else (the looked-up value). *This leads to confusion. We aren't there. *We can't see your data. *I don't know what you mean by "a different row for each photographer and all of the other data is duplicated..." *Are you describing what happens in a query? Regards Jeff Boyce Microsoft Office/Access MVP |
#7
|
|||
|
|||
Lookup Column to Report
It's a common practice to base a report on a query. Is your report
'pointed' directly at the table, or at a query? If a query, what's the SQL? Regards Jeff Boyce Microsoft Office/Access MVP "loki" wrote in message ... I have since read comments again the lookup column but it was a great help in designing this system. Okay so the better description would be; we have a main table named photos. Each row is a batch of photos we got from a specific shop on a specific day. So the row reads Unit, ID, Date, # submitted, Downloaded by, photographers, Notes...and a few others not really necessary to list. So there can only be one unit, id, date, # submitted but there is usually more than one photographer. We need to be able have everything the same in all entries so the important ones are linked to lists: Unit, downloaded by, photographers. The problem that happens is that in the report (arranged by date), there is a different row for every photographer chosen. All of the data corresponding is repeated along with the photographer. So some entries are repeated even six times. I have hid the duplicates to make it easier to read but the empty space remains the same as if the data was there and won't shrink. On Aug 6, 2:51 pm, "Jeff Boyce" wrote: If I'm understanding your description, you have a table with a "lookup" data type field. A scan through this newsgroup will reveal a strong consensus AGAINST using lookup data types in table definitions. Among other issues, this data type stores one value (the key of the record), while displaying something else (the looked-up value). This leads to confusion. We aren't there. We can't see your data. I don't know what you mean by "a different row for each photographer and all of the other data is duplicated..." Are you describing what happens in a query? Regards Jeff Boyce Microsoft Office/Access MVP |
Thread Tools | |
Display Modes | |
|
|