Problem with DSum

  • Thread starter Thread starter Keri
  • Start date Start date
K

Keri

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#")
 
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 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



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

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

Keri said:
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#")
Click to expand...
Click to expand...
 
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

Keri said:
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



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

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

Keri said:
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#")
Click to expand...
Click to expand...
Click to expand...
 
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

Keri said:
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

Keri said:
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



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

--
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.
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#")
Click to expand...
Click to expand...
Click to expand...
 
Back
Top