Recent content by hitchhiker

Good morning all, I've wondering about this problem for some time now and have yet to find an answer (or maybe just one that I fully understand). On the database I'm tinkering with right now I would like to run as many operations as possible from a within a main form. I understand that this...

I've created a series of reports where each report gives statistics for each of my companies offices. Each is based on a similar query that asks for the current year before producing the report. The 'boss' would like to be able to run a single report with each of these as a subreport. I've...

Looks great! Definitely a cleaner, more professional looking page than the previous version.

Thanks Rich, it works great! The sick part is that I've used that function before but I'd been drawing a mind blank all afternoon.

One of the reports I've been working on lately lists the Start date and Completion date of projects we're working on. What I need to include on this report is a bit of text listing how many months the project was active for. For example: If project A started on 09/26/01 and was completed in...

Nevermind everybody. I've figured it out...I was right I was screwing up the syntax...guess it's too early in the morning for me right now.

As a part of my report I would like to display the current month as a two-digit number. I've tried to use 'Format' but cannot get it to work. I imagine it's probably a syntax issue. Could someone please help me out...

Is it possible to do something like conditional formatting on a report? I would like the value in a textbox on my report to be displayed differently based on a seperate value on the same table. Example: Field1 = a date Field2 = yes/no If Field2 is checked "yes" I want the data in Field1 to be...

It most certainly would. But that's not how the boss wants it. They want a list of all projects under construction during the year, and then they want to see which of these projects have had any violations (ie. safety, etc) during each month of that year. The ultimate goal is a percentage...

Please be more specific. What is it that you want to number?

I have created a database which is responsible for turning out several reports at my office. One of the tables in this database lists all products that have had a particular violation, what the violation was and the date of the violation. What this report needs to show is whether or not any...