Recent content by PavelowFE

Looking at it, I believe an SQL WHERE statement is what is needed. SELECT Comments.Comments FROM Comments WHERE ???? Something that will call only the text that is showing in the subform called "Comments". WHERE [forms]![switchboard]![Comments]![comments] (but how do I get it to only show...

Still having problems with this. I swear it's something easy, but I just can't figure it out. I really need to get this done, it's the last thing I have left to fix. I tried the suggestion above, with no luck. It still outputs all the records in the Comment table: Dim strDocName As String...

The problem I have is that the user wants to select which comment goes in the report. I have the sub-form where the user can fill out a date and a comment and then use the navigation buttons to go back and forth in the records. I have the report calling up the table, but it wants to put all of...

I have a subform that the user selects a date and makes a comment (text box/memo), stored in a table. I want to be able to show the comment on a report, based on the comment (record) the user has selected on the subform. The user wants to be able to have reports that show the same data, but...

Here's what I'm starting with for the code. Just need something like an If/Then statement would be in Excel. WHERE [Forms]![Switchboard]![Date Range]![Start Date] And [Forms]![Switchboard]![Date Range]![End Date];

Back for more great help. Scenario - two tables, one fields of data (text) to include date fields (Start, End), the other with a field (Comment) and a date field (Comment Date). My report is based on a query from of the first table. I included a subreport of the second table. I want the...

Got it. Have to call up the main form, then the subform.

Yes, it checked good. Now, for part II: I want to have the Date Range as a subform on my main form. How can I get all the functions relying on [Forms]![Date Range] to work? Thanks again for the help.

I got it now. I used [Start Date] And [End Date] for Datefield. Thanks! Vince

Does the word "Datefield" go there? If so, all I get is a popup window for Datefield.

I'm trying to get a query of a table output the data based on the start and end dates of a form (that remains open). Here's what I have, but it isn't working. I've tried several ways using the WHERE function. As always, I appreciate the help very much. SELECT DISTINCTROW Sum([Teams...

Awesome help once again. Thanks! Vince

Since I'm on a roll and this thing is coming together well, How do I do the same thing if the [# of Aircrew Trained] is 0? (i.e. If the # of Aircrew Trained is zero, but there is a value for [Asset Used], I don't want it to return anything). I'm sure it's just as easy as the first one, but I...

That was it. Thanks for the help. Vince

How do I get this (code below) to not output a blank if [Asset Used] does not contain a value? SELECT DISTINCTROW [Mission Report].[Asset Used], Sum([Mission Report].[# of Aircrew Trained]) AS [Sum Of # of Aircrew Trained] FROM [Mission Report] WHERE ((([Mission Report].[Date Tng Completed])...