Recent content by mitchk

Hi Guys, thanks for all advice and suggestions - I got it working using GPGeorge suggestions by creating two queries - one for the DateIn and one for the DateOut and used the results of these for the chart :) thanks again - help much appreciated mitch

sorry a few beers and I've missed all this :) maybe I should have said I want to take all the records from the table and get a total of the DateIn and total of the DateOut for the current month. is basically just a realtime tally of how well we are doing

struggling to get my head round this but I'm trying to get 2 separate counts in one query o_O I have a table with each record (Repaired Instrument in this case) has a DateIn and a DateOut the query is being used for a chart which gives a realtime view of the total input and output of Repairs...

Morning Guys, thankyou so much for your help - I've been able to use both the talley table and vba solutions for my query

Hi Guys, New here hoping for somebody to help me understand how to create this query. I have a database of customer records which span years 2000 to current and are trying to create a query to show the customer (row) by the amount of units received each year (column). Problem is I want the...