Search results for query: *

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])...

Nevermind, I got it. I made a report from just that query, then in my original report, I added a subreport from the new one. The only problem now is that it doesn't let me do much formatting. Thanks anyways. Vince

Depending on what you desire, you could just go to Access Options, Trust Center, Trust Center Settings, and then select the radial "Never show information about blocked content".

This code gives me the information I'm looking for, but I can't get into my report. 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]) Between...

Hi PH, I tried using your code, but it didn't work. Here's what I got: "You tried to execute that does not include the specified expression 'Asset Used' as part of an aggregate function." Vince

Sorry, you're above my head on that.