X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Show Amount Only Once In Select Query That Joins 2 Tables, Access 2013    
post Sep 9 2019, 05:53 PM

Posts: 5,573
Joined: 2-November 04
From: Downey, CA

I have query that is sourced by a 130,000 record table with an inner join on the job Number of a much smaller table that only has one job number (db Attached)
I’m using a simple query creating a data set that brings in most of the fields from both tables, so obviously there is a lot of redundancy
I think I’ve asked a somewhat similar question before, and the answer was to create a report – but I tried (unsuccessfully) using MAX to just have one of these “duplicates” show up – is that possible, maybe creating a separate update query to update just one record PER JOB# ?

The main issue is the “Job-To-Date Costs” on the “One” side – to have this amount just show up once (PER JOB) in my select query results ?

EDIT: another POSSIBLE solution is to run an update query, but so it only updates one value ? (I wouldn't know where to start on the mechanics of that...

Thanks in advance,
This post has been edited by bakersburg9: Sep 9 2019, 06:09 PM
Attached File(s)
Attached File  UA_ChallengeShowTotal.zip ( 1.65MB )Number of downloads: 6
Attached File  UA_Challenge_Show_Once.png ( 49.49K )Number of downloads: 8
Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    6th December 2019 - 05:44 AM