Search results

Uops! I didn't knew that... But then I need to display it on a form, so I guess I need to have just 12 months and with a name so that I can see them. It has to end up being January february March ..... payed by a payed by b payed by c JoRDi.

Thanks neileg! I don't know which of all was the failure, but at least I simplified it and changed all as you suggested and it works! I've done it like: SELECT DISTINCTROW water_selling.village, water_selling.name_wug, Sum(IIf((DatePart("m",water_selling.[date_rec])=1 And...

Hi! I have a table were each time someone from a village enters money is recorded, the amount and the date. I want to query that adding the total amounts per month. I managed to do it for a whole year whenever the year is the current one. SELECT DISTINCTROW water_selling.village...

I have also a corrupted database and ythis stellar phoenix access repair seems to work... unluckily the demo version does not allow you to seve your repaired database, but it shows all the tables you have in there (with the information inside!) If at last i decide to buy it i'll tell you how it...

Hi! I don't know if I'm making it too difficult, but the thing is that I need to create a procedure to make some graphics with the results of a survey. The survey is introduced in a database, but due to my little skills with Access the only way I thought it would be easy to take the results was...