2 exact same queries running on 2 different databases and different results

[jazzy]

this one sums the RMD field

SELECT IRADetails.FullName, IRADetails.AccountNumber AS [Acct#], IRADetails.Age, IRADetails.AccountNumber, Sum(IRADetails.Amount) AS Amount, IRADetails.Company, [IRA RMD Table].Multiplier AS Mult, [Amount]/[Multiplier] AS RMD, IRADetails.DOB, IRADetails.Last4SSMasked, IRADetails.Automated, IRADetails.Complete, IRADetails.Scheduled, IRADetails.ScheduledDate, IRADetails.RMDTypeFROM IRADetails LEFT JOIN [IRA RMD Table] ON IRADetails.Age = [IRA RMD Table].Age
GROUP BY IRADetails.FullName, IRADetails.Age, IRADetails.AccountNumber, IRADetails.Company, [IRA RMD Table].Multiplier, [Amount]/[Multiplier], IRADetails.DOB, IRADetails.Last4SSMasked, IRADetails.Automated, IRADetails.Complete, IRADetails.Scheduled, IRADetails.ScheduledDate, IRADetails.RMDType, IRADetails.AccountNumber
HAVING (((IRADetails.Age)>71));

this ones does not sum the RMD field

SELECT IRADetails.FullName, IRADetails.AccountNumber AS [Acct#], IRADetails.Age, IRADetails.AccountNumber, Sum(IRADetails.Amount) AS Amount, IRADetails.Company, [IRA RMD Table].Multiplier AS Mult, [Amount]/[Multiplier] AS RMD, IRADetails.DOB, IRADetails.Last4SSMasked, IRADetails.Automated, IRADetails.Complete, IRADetails.Scheduled, IRADetails.ScheduledDate, IRADetails.RMDTypeFROM IRADetails LEFT JOIN [IRA RMD Table] ON IRADetails.Age = [IRA RMD Table].Age
GROUP BY IRADetails.FullName, IRADetails.Age, IRADetails.AccountNumber, IRADetails.Company, [IRA RMD Table].Multiplier, [Amount]/[Multiplier], IRADetails.DOB, IRADetails.Last4SSMasked, IRADetails.Automated, IRADetails.Complete, IRADetails.Scheduled, IRADetails.ScheduledDate, IRADetails.RMDType, IRADetails.AccountNumber
HAVING (((IRADetails.Age)>71));

any ideas?

[jazzy]

i changed the expression [Amount]/[Multiplier] to [Amount]/[Mult] ran the query then changed it back to [Amount]/[Multiplier] and its working fine..... is there something i am missing or is Access just that crazy?

[Minty]

Firstly, I cannot see any difference in those two queries?

You are creating an aliased field called Amount:
Sum(IRADetails.Amount) AS Amount

You are then using that alias in a later calculation within the same query:

[Amount]/[Multiplier] AS RMD

Whilst Access lets you do this I'm not convinced it in a grouped query this will work reliably.
Better to break it down into two queries, one that produces the base results, then another one based on that, that does the subsequent sums.

[Micron]

Not sure why it would suddenly work after making the changes, except to say that the query plan would get rebuilt in doing so, and it might have been faulty for the reason stated. The only thing I see wrong is that there is no space before From, but that might just be a posting error.