HI am a bit stuck on a small problem
I am using the dsum to get a total value from a field in a query. When I use the code 1 below it works fine
1) DSum("amount","QryPandLcaptialInvest","dateofinvestment >= #1-1-19# ")
But I want the user in in put the date in a text box on the form. But I have tried the 2 methods below and a few other ( I forgot to save) and get a type error.
This not worked =DSum("amount","QryPandLcaptialInvest","dateofinvestment > = # "+ [Text150] + "# ")
This not worked =DSum("amount","QryPandLcaptialInvest","dateofinvestment > = " + [Text150] )
Can any one point me in the right direction:banghead:
I am using the dsum to get a total value from a field in a query. When I use the code 1 below it works fine
1) DSum("amount","QryPandLcaptialInvest","dateofinvestment >= #1-1-19# ")
But I want the user in in put the date in a text box on the form. But I have tried the 2 methods below and a few other ( I forgot to save) and get a type error.
This not worked =DSum("amount","QryPandLcaptialInvest","dateofinvestment > = # "+ [Text150] + "# ")
This not worked =DSum("amount","QryPandLcaptialInvest","dateofinvestment > = " + [Text150] )
Can any one point me in the right direction:banghead: