Hello. Appliance Repair man here

[ZackHubbard]

I'm an amateur access user that really enjoys putting together data bases. i can usually fumble my way through most things. but i know i'm not being efficient in how i'm going about it. i look forward to meeting and interacting with all you pro's out there!

 

[CJ_London]

you need to take into account month and year - a common way to do it is something like

SELECT sum(fuelcost) as monthsfuel
FROM myTable
WHERE format(fuelDate,"yymm")=format(date,"yymm")

 

[pbaldy]

Welcome aboard!

CJ, is this in the wrong thread?

you need to take into account month and year - a common way to do it is something like

SELECT sum(fuelcost) as monthsfuel
FROM myTable
WHERE format(fuelDate,"yymm")=format(date,"yymm")

 

[jdraw]

Welcome to AWF Zack.
Perhaps CJ is psychic and can foresee the question???

 

[theDBguy]

Hi Zack. Welcome to AWF!

 

[Dreamweaver]

Hi Zack welcome to AWF