访问查询问题 [英] Access Query Problem

问题描述

我在访问查询时遇到了问题。 我有一个音乐数据库。 该数据库包含一个艺术家表格，其中包含所有艺术家名称，一个名称表格，其中包含所有专辑标题，以及一个ArtistTitles表格，这是一个联结表格，它将这两张桌子的
组合在一起，以确定哪位艺术家拥有哪些专辑。   ;该表还包含一些附加数据，例如发行年份和包含专辑封面艺术的OLE对象字段。 我正在撰写一个查询，返回每位艺术家的总
专辑，总歌曲和总播放时间。 我还想在每个艺术家的第一张专辑中加入专辑封面图片作为此查询的一部分。 我有总数，这很简单，但我很难提出
解决方案，作为此查询的一部分检索图像。 我能想到的每一种方法都涉及分组和访问，不会因为显而易见的原因而允许它。 我很难过。 您可以提供任何帮助。

I'm having difficulty with an Access Query.  I have a music database.  The database contains an artist table which has all artist names, a titles table which has all album titles and an ArtistTitles table which is the junction table that brings these two tables together to determine which artist owns which albums.   The table also contains some addition data such as release year and an OLE Object field which contains the album cover art.  I'm writing a query which returns the total albums, total songs, and total playing time for each artist.  I also want to include the album cover image for the first album for each artist as part of this query.  I have the totals, that's simple enough but I'm having difficulty coming up with a solution for retrieving the image as part of this query.  Every method I can think of involves grouping and Access wont allow it for obvious reasons.  I'm stumped here.  Any help you can offer would be appreciated.

推荐答案

 我有总数，这很简单，但我很难找到一个解决方案来检索图像作为此查询的一部分。  

  I have the totals, that's simple enough but I'm having difficulty coming up with a solution for retrieving the image as part of this query.  

对"第一张专辑"使用单独的查询并加入艺术家。

Use a separate query for 'first album' and join on artist.

这篇关于访问查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！