RE: missing data

Tech-Archive recommends: Fix windows errors by optimizing your registry

SELECT PART.PART_ID,
(Select Max(LINE_ID)
FROM PART as P2
WHERE P2.PART_ID = PART.PART_ID) AS LINE_IDs,
(Select Max(PLANT_ID)
FROM PART as P2
WHERE P2.PART_ID = PART.PART_ID) AS PLANT_IDs
FROM PART
ORDER BY PART.PART_ID;

Change the table name of 'PART' to the correct name.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Ra" wrote:

I have the following table:

PART_ID LINE_ID PLANT_ID
A0322 AA1N PFM
A0322 AA1N PFM
A0322
A0322 AA1N PFM
B0316 BB1C PFM
B0316 BB1C
B0316 PFM
B0316 BB1C

Any way I can run a query with a function that fills up the two fields with
missing data in the following format:

PART_ID LINE_ID PLANT_ID
A0322 AA1N PFM
A0322 AA1N PFM
A0322 AA1N PFM
A0322 AA1N PFM
B0316 BB1C PFM
B0316 BB1C PFM
B0316 BB1C PFM
B0316 BB1C PFM

Thank you,

.

Relevant Pages

  • Re: missing data
    ... missing data in the following format: ... run an Update query updating Line_ID to ...
    (microsoft.public.access.queries)
  • Re: formatting a calculated number field on a form
    ... > A query in an MDB file CAN call a user-defined function. ... > function name is Age and it returns a double. ... The user will certainly "notice" if a patient was born on Jan ... I just want control over the *display format* of a number ...
    (microsoft.public.access.forms)
  • RE: Query count then average.
    ... What was happening in my database was the query returned the ... "Ken Sheridan" wrote: ... It probably depends where you set the Format property. ... "Robert F." ...
    (microsoft.public.access.queries)
  • RE: Cannot get code to work for API Save Dialog Box
    ... I got it working to format correctly now. ... that table in my other queries and union query. ... The code is actually working by giving me the totals I need. ... The first spreadsheet placed where I told it to be contains the incorrect ...
    (microsoft.public.access.forms)
  • RE: Excel & MS Query caused compile errors
    ... My data is in an Excel file called ... The format of it were distorted after copying and pasting. ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ...
    (microsoft.public.excel.programming)