Search results

Well, that solves one problem but raises multiple others. It also produces incorrect data. For example, the Jan 2004 issue contains only 1 record of 30 in which the "2nd Disk" is checked. However, this query reports that there are for for January (and for every other month, for that matter) and...

Wayne: Thanks. My larger problem is getting multiple things to work together. My DB contains information about issues of a journal; each record is an article. There is a field called "Dockets"; all of the articles in, for example, the Jan issue have the same Docket number. The DB contains all...

Wayne: I'm confused about your confusion. My DB has a True/False field called "Hand". Let's say there are 100 total records. I want to count the number of records for which "Hand" is True (i.e., has a check). My original attempts all led to a result of 100 (instead of 9, which is what I was...

This is the SQL SELECT DISTINCTROW Dockets.Month, Dockets.Year, Sum([MOL_Master]![EndPage]-[MOL_Master]![StartPage]+1) AS TotalPages, Count(MOL_Master.[2nd disk?]) AS CountOf2nd FROM (MOL_Master INNER JOIN Dockets ON MOL_Master.DocketNumber = Dockets.DocketNumber) INNER JOIN Schedule_Master ON...

>Sigh< Now, when I tried to duplicate that query within a larger query, I get an error about not using an aggregate function or some such. :(

That's it! Thanks very much. Rodney

Wayne: Thanks, but that gets me the same result, a count of the total number of records. As I said, dunno why this is complicated. Rodney

Count (grrr...) Hi, all. I don't know why this is complicated, but... I'm trying to count all records for which the value of a certain field is true (the field is a True/False data type). What I get is the total number of records, not just the ones with the box checked. I've tried all...

Solved! I got around the different data type problem by creating a fake date expression: FakeDate: "7-" & Left([Dockets].[Month],3) & "03" and feeding it to DatePart(): Path: Left([Dockets].[Month],3) & "\" & [Dockets].[Journal] & DatePart("m",FakeDate) & [LogicID] & ".doc" All is working...

Ok, My [month] field is text, so I can't use DatePart() on it, and i can't change the data type because that will break other things. That means, I think, that I'm going to have to a - reinvent the wheel with a bunch of code saying, in essence, Feb = 2, March = 3, etc. b - break the other...

Well, the posts aren't exactly the same. I thought I was getting no answers because I (a) hadn't given enough information and (b) might have put the question in the wrong forum. But thanks anyway for policing my innocent mistake...

Hi all. I have a database in which each record has a corresponding MS Word file. I want to create a calculated field in a query that contains the filename with full path. Then, a button on a form to open the Word file associated with the record. I have the second part under control, but I'm...

Hi all. I have a database in which each record has a corresponding MS Word file. I have the code to open Word, but I'm having trouble creating a pathname from the separate bits of data that have to be strung together. What I have so far is: Path: Left([Dockets].[Month],3) & "\" &...

Tim: Thanks very much. That worked like charm. :) Rodney

Dave: That worked out great! I found that I could create one form with serach and result fields. It was also very instructional. I found that in this statement: DoCmd.OpenForm "SearchResults", acNormal,,"[TableField1]=_" & Chr$(34) & Me!Textbox1 & Chr$(34) I didn't need the quotes...

I don't have it right in front of me, but that's possible. I don't think that report has anything in the report footer. I'll check, but in the meantime, thanks very much.

Tim, Thanks very much. I would have had no idea that any coding was involved. Perhaps it's time to take a class....

Hi. Here's what I want to do, but I don't know where to begin, and I don't even know if this is the correct forum I am using Access 97. I have a table containing information about articles to be published. The information includes contact info for the author(s), information about the article...

Hi. Another simple question, I hope. I have a field for email addresses. I want to validate the field so that any text placed in it must contain the @ sign. So far, I have had no luck with variations on the InStr function. On the other hand, I have no idea what I'm doing, so my lack of...

Hi. I hope this is a simple question. I am using Access 97. I want to count the number of records in a report. Access help says: 1 Open the report in Design view. 2 Add a calculated text box to the report header or footer. 3 To display the property sheet, make sure the text box is...