Recent content by jtidfold

So....I found something even easier actually. Again, newbie here. In Query1 I put the table fields that I wanted as part of the output AFTER the three calculation fields (after the expression field). That's it. And it worked. I have all the data I need. No linking necessary. I've...

Table 1: WBS Element, Job Description, Account, Job Type, Job Type Description, Amount in local currency Query 1: WBS Element, Account, Amount in local currency (Grouped and Summed on Amount in local currency: Query 2: All fields from Table 1 but with the Summed items only to reduce the number...

Ok, so I have a simple query that is taking the criteria of two fields (WBS Element and Account) and totaling in a third field (Amount in local currency). I need to create a new query that takes the summarized totals from that simple query along with some other fields from the table data that...

Ok, I'm going to close this string and open a new one because now I need to link the "simple" query with the table data to create an output query. I used arnelgp's suggestion to create the simple query and it worked. The only thing I had to do was go in to SQL view and change it a little bit...

No need for the "ouch" LOL - I warned everyone that I was a newbie again. I'm probably trying to do something too complex for someone with my level of knowledge of Access :p So technically I can "group" the "WBS Element" and "Account" fields so the Sum() command will work off that by telling...

So when I "fix" the command, it auto corrects the rest to come to this: mysum: Sum(Nz([WBS Element],0)+Nz([Account],0)+Nz([Amount in local currency],0)) However, when it runs, it give an error that states: Your query does not include the specified expression 'WBS element' as part of an...

Getting closer: I got another error message: The expression you entered contains invalid syntax. You may have entered an operand without an operator. This is the string in the top box in the new column (field): mysum: Sum(Nz[WBS Element],0)+Nz(Account,0)+Nz([Amount in local currency],0)) I...

Thanks Pat - "I did the MySum:Sum(" one and got an error message that states "Your query does not include the specified expression 'Profit Center" as part of an aggregate function. The "Profit Center" field is just data. Is it because that field is the farthest left field in the query design?

Ok, so how do I write that in Access? Do I create a new field in the first query? If so, how do I tell it to look for unique instances of the "Job Number" and "Account" fields and create the Sum based on those multiple criteria?

Hi everyone: I've been able to use Excel for everything I've needed for the past 19 years, however with the amount of data we have to deal with now, it seems I have no choice but to utilize Access to perform the calculations. I'm nowhere near an expert in Access, and wasn't back then, however...

Hello: It's been 19 years since I've used access and I've completely forgotten all of the query functions. I have a link table (from excel of course) with over 30k rows, so I want to use the processing power of access to do the calculations. So here's what I have: A table with multiple...