microsoft.public.access.queries | Forum profile

  Or maybe -- Try this, replacing [CBT table] with your actual table name -- TRANSFORM Sum(qcartFinalAssignWkCbt.EndCost) AS SumOfEndCost SELECT qcartFinalAssignWkCbt.qcartAssignWkCbt.CbtName, Sum(qcartFinalAssignWkCbt.EndCost) AS [Total Of EndCost] FROM [CBT table] LEFT JOIN qcartFinalAssignWkCbt ON [CBT table].[CbtName] = qcartFinalAssignWkCbt.qcartAssignWkCbt.CbtName GROUP BY [CBT table].[CBTNo],...

  You are already in a kind of where clause, so add extra condition with AND: UPDATE AAJGAJuniors SET aajgajuniors.rank = dcount("1","aajgajuniors", "score<=" & [score] " AND agegroup =" & [agegroup] ); assuming agegroup is a number. If it is a string: UPDATE AAJGAJuniors SET aajgajuniors.rank =...

  Not sure what you mean by "week day translation". The syntax for DateDiff() allows for the difference in minutes, hours, days, ... you pick. Regards Jeff Boyce Microsoft Office/Access MVP "Laura1 via AccessMonster.com" <u31091@uwe> wrote in message news:98bce1921453e@uwe... >I am missing it, datediff appears to give you the week day translation. > SORRY, additional...

  I don't see anything the the query that should cause such a problem. Of course you are calling on other queries an that could be trouble. It is a rather complicated query - unnecessarily so. You have a Distinct Clause at the top then a long Group By at the bottom with essentially the same fields with the addition of Discharge.CloseDate. Since you aren't doing any summing or other such math, dump the entire Group By...

  If it is that massive then you probably need to invest in a major database engine such as MS SQL or Oracle to hold the data. You could still use Access as a frontend to the data AS LONG AS you never exceeded the limit of 2 gigabytes of data when you where running your queries. With the structure you have outlined you might be able to return the information but depending on how the data is segmented and the relationships between the...

  On Wed, 08 Jul 2009 01:27:30 GMT, "gr8_access" <u53119@uwe> wrote: >Hi, >I am having issues with access sql. I have data for example: 123456789. I >would like to break this into two lines and I don't know how to do it. >Intended output should be >1234 >56789 > >Please advise how can I accomplish this ? Is this a nine-character Text field in...

  That's a much bigger question. You won't have transactions for every day for every account. The missing dates must come from somewhere, so you will need a table of dates that you can outer join to. Create a Cartesian product query based on this table of dates and your Accounts table (i.e. it outputs every date for every account.) In that query, use a subquery to sum Deposits - Withdrawals for the account and dates up to...

  The three columns are defined in the Page Setup. The three columns would display across then down. The link Master/Child would be used to link the appropriate child/Components for each master/Assembly. The subreport would display every related Component in three columns and as many rows as it takes. -- Duane Hookom Microsoft Access MVP "Steve" wrote: > Thanks for responding, Duane! > > What...

  You can't. Do it correctly and write a report. -- Dave Hargis, Microsoft Access MVP "Leo" wrote: > How do you write the code so that only the subform will be printed when you > do not want to go through report format? The sub form displays the seleted > record. > > Thanks > Leo  

  But you could probably do: SELECT Distinct PI.Machine, PI.Process FROM ProcessInstances as PI INNER JOIN (SELECT PI2.Process FROM (SELECT DISTINCT Machine, Process FROM ProcessInstances) as PI2 GROUP BY PI2.Process HAVING Count(PI2.Machine) = 1) as SP ON PI.Process = SP.Process John Spencer MVP wrote: >Dale, >Will that work if the same machine runs the process multiple times even though >no other machine runs...