Search results

hello im building a invoice database to send invoices for costumes for the power usage i have a table with meter reading with customer id, reading, date taken whats would be the best way to create a report showing the last and most current reading and ideally work out the different between...

sorry ye I'm From the UK currently the spreadsheet that is used has and adjustment cell to allow a -2 to exclude bank holidays so was intending to do the same one i can return the number of Mondays

the school had a excel spreadsheet that was very glitchy in that they had: =SUMPRODUCT(--(ISNUMBER(MATCH(TEXT(ROW(INDIRECT(Schedule!$B$1&":"&Schedule!$C$1)),"dddd"),B7,0)))) with schedule related to a date range and B7 was the day of class but not sure how to do this in access

yes i have ClassID, ClassName, ClassDay, ClassPrice so trying to build a query to use ClassDay and a date (or a date range) to return number of times a class happens per month

Hello thanks for reading bit of a novice so hoping you can help i trying to build a query to return how many time a class will run each month so i can then invoice accordingly so if class 1 runs on Mondays and class 2 on Tuesdays can i get access to return the number of each per month?

i have a table to list studentID and ClassID so recording the classes students attend

i am trying to build a database for a dance school i have created a table for the students and one for the classes then linked them with a enrollment table. what i want to do is create monthly invoices per student listing the classes they attend that month so want the invoice to pick up that if...

I hope so too ��

Hi Im Adam total newbie here trying to find my way around access and learn from the ground up