Problem with DSum

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Keri - 17 Jul 2008 16:07 GMT

Hi I am currenlty working on a report to show the costs of usage for a cars.
I have split up into quarters but the following code is not returning any
information. I'm not sure what I'm doing wrong. Any asstiance would be
helpful.

=DSum("[Total Costs]","tblMileage Costs","[Car Tag Number] = 1234" and
[Begin Date] between #10/1/2007# and #12/31/2007#")

Reply to this Message

Dennis - 17 Jul 2008 16:18 GMT

Take the quotes out after 1234
=DSum("[Total Costs]","tblMileage Costs","[Car Tag Number] = 1234 And [Begin
Date] Between #10/1/2007# And #12/31/2007#")

> Hi I am currenlty working on a report to show the costs of usage for a cars.
> I have split up into quarters but the following code is not returning any
[quoted text clipped - 3 lines]
> =DSum("[Total Costs]","tblMileage Costs","[Car Tag Number] = 1234" and
> [Begin Date] between #10/1/2007# and #12/31/2007#")

Reply to this Message

Alex Dybenko - 17 Jul 2008 16:19 GMT

Hi,
if Car Tag Number is a text field - then try to put 1234 in quotes

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

> Hi I am currenlty working on a report to show the costs of usage for a
> cars.
[quoted text clipped - 4 lines]
> =DSum("[Total Costs]","tblMileage Costs","[Car Tag Number] = 1234" and
> [Begin Date] between #10/1/2007# and #12/31/2007#")

Reply to this Message

Keri - 17 Jul 2008 16:50 GMT

Hi I have taken the qutos out of the 1234 and I'm getting an error message on
the report. I also tried "1234" and '1234' both I did not get any
information returned when I did that. Are there any ideas that I might try.
Thanks,
Keri

> Hi,
> if Car Tag Number is a text field - then try to put 1234 in quotes
[quoted text clipped - 7 lines]
> > =DSum("[Total Costs]","tblMileage Costs","[Car Tag Number] = 1234" and
> > [Begin Date] between #10/1/2007# and #12/31/2007#")

Reply to this Message

Keri - 18 Jul 2008 13:48 GMT

I'm still not sure what I'm doing wrong. I've tried re writing the DSum
function I still unable to get it to work. Please some further assitance
would be helpful.
Thanks,
Keri

> Hi I have taken the qutos out of the 1234 and I'm getting an error message on
> the report. I also tried "1234" and '1234' both I did not get any
[quoted text clipped - 13 lines]
> > > =DSum("[Total Costs]","tblMileage Costs","[Car Tag Number] = 1234" and
> > > [Begin Date] between #10/1/2007# and #12/31/2007#")

Reply to this Message

Keri - 21 Jul 2008 16:50 GMT

I have tried adding the function in visual basic and I'm getting an error
there to. I'm not sure what else today. I have read everything i could plus
look in my access book but nothing i seem todo is working does any one else
have a suggestion.

thanks,
Keri

> I'm still not sure what I'm doing wrong. I've tried re writing the DSum
> function I still unable to get it to work. Please some further assitance
[quoted text clipped - 19 lines]
> > > > =DSum("[Total Costs]","tblMileage Costs","[Car Tag Number] = 1234" and
> > > > [Begin Date] between #10/1/2007# and #12/31/2007#")

Reply to this Message