Search results

The database is posted on the Sample Databases page (once approved by the moderators) with a "many thanks" for your input.

This database was compiled to meet a need for an easier way to calculate the Bradford Factor for absence tracking. The main query that does all of the work was written by LBH (from this forum) so, to give him the credit he deserves, I'm posting this for all to use as they see fit.

I cannot say "Thank you!" enough... The query works perfectly. I have a few things to finish off on the database and then I will post it for all to use - with a special "thanks" on a splash screen to you!

I suppose now is a bad time to let you know that I forgot that it's supposed to be a rolling 12 month query... I tried to add WHERE (((Datatable2.BegDate) Between Date() And Date()-365)) at the end of the query but it just returns an error message. Sorry... :-(

It may be politically incorrect to hint about "orientation" but I am so happy I could kiss you!! My colleague will tell you that I have been a bear with a sore head, belly, @ss and other things trying to sort this out. THANK YOU!!! PS As a way of saying thanks, I'm posting the database onto...

I've attached the database itself. I have a calculation on the AbsencebyEmployeeName report using the number of incidences of absence (Count of [BegDate]) and the number of working days ([WorkDays]) that works fine on the report but I want to have it in the query so that I can graph the...

I'm trying to produce a calculated field (Bradford Factor) using a count of the start date (number of incidences) and the workdays total. I've tried pretty much everything I can think of and looked at all manner of websites to no avail. The calculation works fine on the report but I want to...

I have an Access 2003 database running on a server. Today (for about the 5th time in 6 months) Access reported that the VBA was corrupted and tried to repair the database. As usual, it didn't work but I don't know what to do to prevent this in the future. Any ideas? Our IT bloke is scratching...

I knew it had to be something simple - like me! It's worked a charm and my report is now doing exactly what I wanted. Thanks!:)

I'm trying to report our raw material spec data (width, thickness, hardness) in an Access 2003 report with a summary/subreport in the report footer that shows the data that has changed in the past 60 days for our suppliers. The 60 day summary report works fine until you put in in the report...

I lost my first wife & son many years ago and - to be perfectly honest - definitely did not have the grace and poise of your daughter afterwards. I'm not a Christian but I have seen the benefits of faith a number of times over the years. The only thing that your daughter needs to know is that...

The last service pack or update was back in June; service pack for Office 2003. I've looked at what Microsoft say it does and there's nothing related to MSGraph in there - or so it looks! I'm now ripping my hair out as I can't load a form or report with a graph on them inside 3 minutes!! Are...

Hi Gang! I'm trying to add graphs to a db to help display scrap/rework totals on a week by week basis. The query works absolutely fine but when I try to add a graph to a blank form in design view, I get a pop-up "Installing Components". This takes about 2 minutes EVERY time I try to do anything...

Obviously, I'd missed the plot on the way over here! You may be a "Gentleman Bassist" but you found a neat answer to my problem! To be honest, I'd started to replace the label with another control; that way I could code the change but the extra label works just fine. Thank you, Sir!!:D

Hi Gang! I'm trying to change the contents of a control's label based on the contents of another control. I've tried using the AfterUpdate on the second control but nothing happens. Am I giong stupid or have I missed the point with this and should I be going directly to the code on the form? BTW...

SUCCESS!! Thanks for the tip which worked like a charm!:) We'll have to get together for a beer sometime. Let's face it, it's not as if there's a huge distance in between and I owe you one, buddy!:D Which part of Maidstone are you from? I know my way around fairly well as I've got some good...

Hi! I've got a problem with a csv file from our MRP system. It always contains spaces BEFORE the data in the fields and I need to ignore them when I group the data. The crosstab report works absolutely fine but I don't get the right output because of those darned spaces!!:mad: HELP!!:confused: