Replies

Hans is there any work around or patch for doing the linking and updating?

I don’t think that would work. I have another idea but don’t know how to do it. The field I want to increment the number in is in a subform. Instead of have an autonumber can I have it take the last number – in the table and add 1 to it?
Thanks Hans for always responding and being such a big help.

Thank you so much – got it working

Thanks Hans – got it working

Hans as usual you are wonderful. Thank you so much it works great.

If I do a filter on Elec in col H (Discipline) I get 22 but on the Totals col. in col F I get 16. Can I send this to you again?

Hans it still didn’t work – What are the green parts of the VB Macro?
Thanks

Hi Hans – again I get asked to fix something – just because I know a little bit about Access & Excel. Thanks for your help. The spreadsheet is supposed to Count the Disciplines when you click the Current Total button – then put the result in F3 to F10. Someone else created this Macro and I tried to fix it.
Thanks Again

I tried your suggestion – it didn’t work – I think I have to put it into all 3 queries to get it to work properly. Sorry I’m not very good at explaining. Thanks for all your help. I think I may have solved it by doing a update query instead of an append.
Thanks

Sorry for the long delay – I was so tired of working on the Database I went to bed. Here goes- I will try to explain it better.
I have a table of items (over 6,000) that I have 3 queries counting on a Start date & End date for specific criteria for Planned, Actual and Forecast information. I then have a append query that runs the 3 counting queries and allows me to append it to a table. The only way I could get the user to put the end date in is have him go to the table and type it in. It needs to do a count from March 1 to July 30 each week from a Monday to the Sunday – ex. July 21 to July 27th. I need to hold that information (which I do in the table) and then I have it linked to excel to create a chart. I need help with 2 things. How do I get the end date into the table from the parameter query and how can I have it update the table each week but leave the dates? Hopefully this makes more sense.

I have no idea how to do that. If you have any examples that would help.
Thanks again

I have queries that specify different criteria for a table. Each query gives me a different result – I need the record number of the queries to create a chart. Hopefully this makes sense. Thank you.

Morning Hans, got busy so I couldn’t get back to you. Attached is the stripped down db. I have the check box in the master table. I want to count it once for each employee. Thank you for looking at this for me.

Thanks Hans – I did try this but it still counts for each time that qualifies. I have the Qualifies field in the Employee table, then the times the employee clocked in are in another table. We have to go through the times manually to check to see if they qualify so I want the report to calculate the staff that qualify but it does a calculation on each time. Hope this explains it a bit better.

Is there an easy way to count the # of check boxes in a report? I have the Active check box in the 1 table but It keeps coming up with a count of many table check boxes within the group.