Search results for query: *

OIC. You're talking about what Browne calls "Parameter query." Yes, that's all I had before because I didn't know how to get the forms to work. So, with a little tweaking this technique should work with a combo box, too? By the way, thanks for the help dhookom. It worked like a charm! Check...

dhookom - I've seen in other posts that you recommend against them. What are the alternatives? Or is there a way to structure your forms so that you don't have them? Check it, Fool! http://www.thepixelmine.com

This is a newbie questions so I hope it will get answered quickly. I searched the posts but couldn't find the answer I was looking for. I have a report that relies on date ranges. What I'd like is a pretty little form that asks for the date ranges and has a button to call up the report with the...

That did the trick. Works like a charm! Thanks, dhookom. Check it, Fool! http://www.thepixelmine.com

I could easily sort by family. What do you mean by 'running sum in the report?' Check it, Fool! http://www.thepixelmine.com

The headline on this was supposed to be: COUNT(DISTINCT <expr>) in a report... not "...is a report..." I can't seem to find "Edit Post" on this site. Check it, Fool! http://www.thepixelmine.com

This has been driving me crazy. It seems so simple. I've got a class roster (report) that totals tuition, number of students per class and total students. I want a total of families. Right now, I have a table for families with a one-to-many relationship to a student table. The result I'm...

Well, thank you kindly, PHV. That indeed did the trick. I had derived the aforementioned code from the help files which (as I'm sure we're all well aware) are not very clear. Dare I say, convoluted. Now, just out of curiosity, does anyone know why my previous attempts were yielding a "January"...

I've created a monthly summary report to summarize my invoices. It's based on a date range. I want a header that displays the month and year based on the [End Date] of the requested date range. For the sake of this example imagine I'm using the date range of 4/1/2007 to 4/30/2007. To do so I...

I've got a subreport in my report header that will only display the first entry of the subreport. To see the relationship among tables click here. My report works like this: The report header is to have a monthly summary of my department's billing. At the end of the header I forced a new page...

I'm sorry...I should have explained just how new I am at this. I've eventually figured out that I had to get my calculations done in a query that the form or subform referred to. This is what I've been able to concoct so far: SELECT TimeCardHours.ProjectID, TimeCardHours.DateWorked...

I'm preparing a database to manage billing and assets for various projects and clients. Specifically, I'm trying to calculate billing charges in a timecard subform. Right now I have a subform that details the project, hrs/qty of service, and a serviceID that links it to a another table that has...

Everyone who was kind enough to help, I ended up just switching the order in the query to the following so that it would at least just show the Project and not the Client once clicked. This worked well enough for me. SELECT Projects.ProjectID, Projects.ProjectName, Clients.ClientName FROM...

KJV, Thank you for the reply. It would turn out that my folly was centered around the "Enfore Referential Integrity." Once I had made sure each of the linked fields matched in type I got rid of the "Type mismatch in expression" warning and Queries made a lot more sense. My queries weren't...

Okay, so there's progress. It would appear that I had not ensured referential integrity causing my values to not match. Once I corrected that in the relationships I was able to get a decent result with: SELECT Projects.ProjectID, Clients.ClientName, Projects.ProjectName FROM Clients INNER JOIN...

Okay, I tried the Query Wizard (did this previously through the ellipses at the end of Row Source). I've also revised my visual aides to perhaps illustrate my point a little better. http://www.thepixelmine.com/forumfiles/tektips/ProdRelation_flow.jpg I ended up with something like this...

I'm a newbie. Please be nice.... I'm setting up a database to manage a list of Clients, their respective projects, and the billing of said projects. See the relationships here: http://www.thepixelmine.com/forumfiles/tektips/ProdRelation.jpg In a Time Card form I have a subform managing the...