Recent content by Aterlatus

The second option was definately the simpler solution, and it works great :D Thanks :)

Hi all, I've created a report that summarises some data for last month. I want to put a heading on this report saying "June 2003" if it's currently July 2003, "August 2003" if it's currently September 2003 etc. So far, I've got it to print "6 / 2003" or "8 /...

Works grand. Thank you :)

OK, that part works great :D Thanks. Now for the next dilemma though. This table also contains a date that the job was complete. I want the query to only show results for last month, without affecting the grouping (can you tell I've tried to do this myself already? ;)). Any suggestions...

Hi All, I'm just playing about with a few queries, and I've come across a bit of a brick wall... I have a list of engineers with scores, like so: Bloggs 1 0 0 1 1 0 1 1 0 Smith 1 1 0 1 1 0 0 0 1 Bloggs 1 0 0 0 0 1 1 0 1 Jones 1 1 1 1 0 0 1 1 0 Bloggs 1 1 0 0 0 0 1 0 1 Smith 0...

Is it not possible to just set "Control Source" property to: Query:[QueryName].count Or something? Surely there's got to be an easier way such as this? If not, could anyone supply more detailed suggestions for implementing the recordcount - the suggestion in the last post just gave...

OK, I think that once I've associated the form with the query/report things should start working a little better. I've got the button placed and named, how do I go about getting it to run the query & fire up the report when I click the button? Also, I need a count of the records found on the...

Also, once I've got the query set up how do I get the query to run from the button click on the form? How does this then go on to generate the report? Thanks :)

Okies - I'm actually using a combobox, but that should work the same (at least, it does in visual basic). When I try and enter the following as the criteria for my query: Forms![SelectContractor]![Engineer] access turns it into: [Forms]![SelectContractor]![Engineer] And I get a standard...

Hi all, I currently have a query and a report that work quite happily together, however it requires that I hard-code the criteria for the query beforehand. I'm trying to change this so that the report can be fired up by submitting the criteria (a contractor and an engineer) on a form. I've...

OK, I'm not sure what I clicked or where I clicked it, but all seems to be working fine now. Thanks :)

Still nothing :( I am right in saying that the row source type should be table/query aren't I? Other than that, I'm pretty much out of ideas :(

OK, I've got as far as making the bottom box drop down once the contractor is selected (which proved the first bunch of code is working, and thus it's just the query needs refining). The combo boxes are called "Contractor" and "Engineer". The form is called...

OK, done that. Once I've selected a contractor in the first combo box, and I click on the engineer drop down box, I get an error saying that the table or query does not exist. I tried creating query with the above SQL statement, and attached the query to the row source instead and it now says...

Hi all :) I have a form with a combo box on it, listing a bunch of contractors from a table. I have another table, that has two columns - contractors and engineers. How can I populate a second combo box on the form with the "engineers" values associated to the contractor selected...