Recent content by MoeIndustries

Hello, I don't know if this is possible and is probably complex, but I receive an excel spreadsheet of our investments. The sheet is really clumsy but it's consistent. So I was hoping to import it into Access then have a query strip out just what I need. I.e...

Hi again, I don't know what's happened - I simply changed the name of the account number column in the table to "Account" and altered the appropriate name in the formula and it's worked! Thanks to everyone for your great help!!

This is driving me crazy! If I take out the account part, i.e.: YTDBud: DSum("[2012 Bud]","Table","Period <=" & [Period]) it works (it seems to total the whole period) - so the issue must be with the account part. When I remove "[Account Number]" and replace it with a number i.e. YTDBud...

Hi again, Thanks for your continued help! tehNellie: I made sure everything was number format not text - that's why I now can't figure out what else is wrong.:) No, I simply put that down for this example - would that make a difference?

Hi again everyone, sorry to keep this up - you've been great so far! I've just tried the same Dsum expression on a different table with the same set up but when I run the qry everything shows up fine except for the Dsum column which is filled with ERROR - when I click on an ERROR it says...

Thanks for explaining! I will try those excercises - I had already noticed the ordering of text (to my confusion!!)

I've converted everything to number and it works! Thank you very much!!! I had account code as text (I originally had period as text too) because I thought these were hash figures, if they never require to be summed together as such I thought they should always be text - is this bad database...

Thank you for your help so far! I tried the first suggestion as it seemed the most straight forward (for my level) but I keep getting the "data type mismatch" error. Amount is number Period is number Account is text

Hello ALL, I have the below financial data showing each acounts monthly figures: Period.....Account....Monthly£ 01 ........1000 ........£500 01 ........1005 ........£40 01 ........1011 ........£1,200 02 ........1000 ........£20 02 ........1005 ........£100 02 ........1011 ........£20 03...