DSum Question 1

[CluelessRink]

I have a DSum that goes

=DSum("totalsales","tbl_tips"," [transdate] = #" & [transdate] & "#")

And it works wonderfully.

I would like to add another variable to it though, one that will pull the data from another field called dept from the table named tbl_employees.

I've tried

=DSum("totalsales","tbl_tips"," [transdate] = #" & [transdate] & "#","dept","tbl_employees")

but that didn't work.

How would I phrase it?

What I am trying to do is get the total amount of tips by day (transdate) by department (dept).

 

[CluelessRink]

Got it! The problem was in the query, I had the wrong table in there.

It sure helps to have a second mind in the mix to assist.

 

[CluelessRink]

What the!!??

Here's an odd one!

When I run the query, it pull up a bunch of data that isn't even in the table(s).

I've done a compress and repair, but it's still there.

What would cause that?

 

[PHV]

Check carefully how the two tables are joined.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[CluelessRink]

Oh, they aren't joined at all