<div>
Use the query in the Excel spreadsheet as the data source for a pivot table
</div>


Use the query in the Excel spreadsheet as the data source for a pivot table

<div>
Try <br />
<br />
<br />
Select Field1, Field2, Fieldn from TableName group by Field1, Field2, Fieldn<br />
<br />
<br />
Field1, Field2, Fieldn (are your field names)<br />
TableName is your table name<br />
<br />
<br />
Regards,<br />
<br />

</div>


Try


Select Field1, Field2, Fieldn from TableName group by Field1, Field2, Fieldn


Field1, Field2, Fieldn (are your field names)
TableName is your table name


Regards,



<div>
fabriciofonseca:<br />
<br />
Are you suggesting a Totals query? <br />
<br />
I have tried this and it simply does not work. 
</div>


fabriciofonseca:

Are you suggesting a Totals query?

I have tried this and it simply does not work.

<div>
MNelson831<br />
<br />
I don't know much about Excel. So I don't know what a Pivot table is.
</div>


MNelson831

I don't know much about Excel. So I don't know what a Pivot table is.

<div>
Thanks, sorry I couldn't me more helpful.
</div>


Thanks, sorry I couldn't me more helpful.

<div>
<div class="content wysiwyg-content">
Is there a way to have a Query only show the first time the value appears. For instance when I'm doing a query on an Invoice I don't want the Header repeating for each Line. I know that I can do this in a report (at least I think so) but I want to create an excel sheet so I use the office link from the query to do this.
</div>
</div>


Is there a way to have a Query only show the first time the value appears. For instance when I'm doing a query on an Invoice I don't want the Header repeating for each Line. I know that I can do this in a report (at least I think so) but I want to create an excel sheet so I use the office link from the query to do this.

Query Repeating Values?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.