DataBase - expression builder NOT

I am trying to do a very simple "NOT" expression in a report and keep getting
syntax error.

First of all when you open the expression builder in a report,  what are you
connecting at the bottom?  How much bearing does this have on what I am
trying to do?

Second, and I know this should be very simple but what is correct formatting
for the "NOT" or "NOT LIKE" expression.

Contract No.  Not "WS0*".   Should Contract No. be in brackets?  Is it
double or single quotes?

Also can I do two expressions because I want to eliminate more data from my
report.  EX.  Contract No.  Not Like "WS0*" and Contract No. Not Like "WS9*"

  John Spencer replied to Baffled

Any time you have spaces or other special characters in an object name you
must enclose it in brackets.

[Contract No.] Not LIKE "WS0*" and [Contract no.] Not Like "WS9*"

Of course that could be shortened to
[Contract No.] Not LIKE "WS[09]*"

For not equal you can use <>



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

DataBase Count and Filter Result My report has = Count(*) in the group header and I want to filter the results. Report Example: IDnumber Group Header Total of Reports Last Name First Name Idnumber 2 Smith Joe total of 4 or more. Try this in the query used as source for the report - -- SELECT [Last Name], [First Name], [Idnumber], Count([Idnumber]) AS [Total of Reports] FROM YourTable WHERE current code for my query. Where would I put the below infromation? SELECT [Minor Disciplinary Report].Last, [Minor Disciplinary Report].First, [Minor Disciplinary Report].IDnumber, [Minor Disciplinary Report].Unit, [Minor Disciplinary Report].Dateofreport, [Minor Disciplinary Report].[Gpsanction 1], [Minor Disciplinary Report].[Asddsanctions 1], [Minor Disciplinary Report].[Ccusanctions

over three weeks to find the solution to this problem: the Ending Balance of a report with two subreports. I have the Beginning Balance and the two subreports in the Detail Section of the Main Report: rpt_AFinancialStmt. I know that I have to add the beginning balance, the total income together I received a post from Duane stating I needed to have the name of the report and “txtIncomeSum” or “txtExpenseSum” as the Control Source in an unbound text box Ending Balance. Not fully understanding your post, “If the subreport is in the main report's detail section, then you need to calculate the total from all instances of the box named txtRunAmt to the detail section. Set its control source expression to: = IIf(QRYsubrptInvoice.REPORT!HasData, QRYsubrptInvoice.REPORT!idamt, 0) and set its RunningSum property to Over All. Then the grand total in the main report's footer would use the expression: = Sum(amt) + txtRunAmt “ Since I’d tried I put an unbound txt box with the control source of “ = IIf(SubRpt_AInc.Report!HasData, SubRpt_AInc.Report!idamt, 0) and set the running sum to all over. And try

DataBase Weighted Calculations I am trying to total an aggregate function in a report. Here is the basics. UnitIn- UnitOut - Yield - WtYield 10100 - 10000 - 99.01% - 90.01% 2000 UnitOut / sum([UnitOut]) = sum([WtYield]) does not work. These calculations are taking place in a report. I tried to make it happen in a query, but due to the group by to show all the proper fields (not shown here in interest of brevity) for the report it does not sum up the LBSProd properly. Is there a way to remove the Group By in the query, and still have the data show in a report perhaps? Any ideas? Post the SQL of your query as you have it now. Open all, copy, and paste in a post. - - Build a little, test a little. SELECT [Prod Report Master Data].Date, [Prod Report Master Data].[ITEM No], [Prod Report Master Data].Brand, [Prod Report Master Data].Description, [Prod Report Master Data].[Line#], [Prod Report Master Data].[CS PRODUCED], [Prod

have created a database to do our reports. One of our reports is an operations report that could have supplemental reports and use of force reports "attached" to it through an autonumber. If officers fill out a supplemental report, they can also have a use of force attached to the supplemental report. All is working and I can print each report separately. I want to create a function that will allow me to print all reports attached to the main operations report, to include the proper page header / footer for each report (as operations / supplemental reports can be multiple pages per report). Problem: I have an 'AutoNum' field for each report, and the supplemental and use of force have an 'AutoFromOR' fields that point back to

Still have hope but need more help. First Question, more to follow I have a report and I would like the information to print side by side on the report page ! ! (columns which are even at the top) not ! ! (Columns where all the information for is one of them. The next is how to et everything together in an Access report wich looks like a financioal sheet. I will need to combine several queries and am records in each group might vary. I would change the record source of the main report to a query of just unique "group" values. Keep the columns. Then create a single column subreport that can be place in the detail section of the main report. Set the Link Master / Child properties to the "group" field. - - Duane Hookom Microsoft Access MVP information in a query and am using that query as the Control Source for the report. In the report, I have put the information for each column in the Detail section. For the left side of the report, I have [CC] [ACD] for the right side of the report, also in the Detail