Search results for query: *

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

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

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

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

Need a query to output a sum of values, dependant on a different value in the record. i.e.: My table contains fields "Type of Aircraft" and "Aircrew per aircraft". The values for "Type of Aircraft" are AC-130, A-10, F-16, MH-60, etc. The values for "Aircrew per Aircraft" are a number based on...

Hi, I have a report based on a query and I need to add another portion of the form based on a second query. I tried using sub-reports, but it is not providing all my information. It only shows one record from my query, whereas viewing the query shows muliple records. Probably not enough info...

Hi, I'm trying to get my query to count the number of records based on the value (text) that it contains. Here's what I have so far: SELECT Sum([# of Operators Trained]) AS [Total Operators Trained], Sum([# of Aircrew Trained]) AS [Total Aircrew Trained], Count([Type of Tng]) FROM [Mission...

Hi again. Trying to get a query to sum the values in all the records of one field, but only between certain dates. I've manage to do the Expression to sum the values, but can't figure out how to do it for a date range. Thanks in advance for the help again. Vince

Hi, I have a table that has one column, which will contain numbers input from the user on the form. I need to run a query or find a way to calculate the sum of the values in the column and be able to show that. The catch is that some of the cells contain multiple values separated by a comma...

Hi, Not sure if this is the place to post this, but I believe part of my problem has to do with Linksys routers. Anyways, it may not be, but it's a start. Base problem: I can't access the three websites that I designed and maintain. I'll try to keep this condensed to make it easy. Problem...