Display Only First Record of Repeating Records?
Tech-Archive recommends: Fix windows errors by optimizing your registry
I have a table in which two fields are repeated (Job Number and Service).
I'd like to create a query that only displays the first row of the repeated
records, so that the job number and service combination will be unique
(ideally it would display it as if a job can have multiple services, but
never have the same service twice). Any ideas? Thanks in advance.
.
Relevant Pages
- Re: Tricky Delete Problem
... Do you want to delete just column 5 (based on the first row) or do you want ... In a table (or query), you can only "delete" entire columns. ... > I probably want to sum the columns and find the ones that equal 0. ... Prev by Date: ...
(microsoft.public.access.queries) - IIf statement in query
... the first row of my query? ... Unfortunately, there is a third option, "None", which has a value of ... getting "#Error" when I run the query. ... Prev by Date: ...
(microsoft.public.access.queries) - Export query to CSV, column name containing #
... I need to export a query to a CSV formatted text file, ... "Include Field Names on First Row." ... Prev by Date: ...
(microsoft.public.access.externaldata) - Re: Help with counting only one time
... You want to exclude all but the first row for each order? ... In the following example, I will assume there is a primary key field named ID, and the table is called Table1. ... but I am clueless on what to do in the query even ...
(microsoft.public.access.queries) - Re: "Numeric field overflow."
... Number data type, which really screwed up the works because the column in ... What was really nutty was that the append query ... However, if you tell it that the first row is a header row, ... If the source query has calculated fields, you may need to typecast the ...
(microsoft.public.access.queries) |
|
