Search results

It is running in a subreport. It doesn't print anything if there is no programs but it prints correctly for the other options

Yes it worked until we upgraded from Access 2003 to 2007 last year. Yes to the 2nd question.

The first part of the IF statement is not working but the second and third parts work fine. Below is the code created using Access 2000 but currently using Access 2007. Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer) Dim db As Database, rst As Recordset Dim sql As...

I have 5 fields(First,Second,Third,Sum,Sum1). The Sum field is the sum of the first, second and third. In excel I am using the following formula/expression to calculate the Sum1 field =IF(E1<0,E1+10,E1+0 - and it brings back single digit. e.g. First=3, Second=5, Third=8, Sum=16, Sum=6 Can I do...

Yes their is an ID field Yes their is an ID field

jones smith arnold michael johnson davis jones I would like to count the number of records since jones last appeared.(6) Thanks in advance for your help.

Thank you,thank you :) Man,you guys are awesome. Thanks again,it worked great.(Great forum BTW)

505681552 149934515 574883717 With these 3 records I would like to do the following, 1- order the contents of each record, and 2- remove duplicates in each record. Results to look like 012568 13459 134578 Is this possible? Thanks in advance for any help.

Thanks Thanks a bunch.

I have a field with 3 digit numbers. e.g. Field A 123 429 231 745 312 I am trying to use the "like" operator to catch 123 in any order, so my result would be 123 231 312 Thanks in advance for any help/suggestions.

The results must have a "0" and "3" in the same record.

I have a list of numbers to search from e.g. 3504 2257 6403 6152 How can I search for any instances of "0" and "3" anywhere/any order in the string? My result should be 3504 6403 Thanks in advance for any suggestions.

Thank you for your help. I actually changed my header properties/Repeat Section to YES and then used Keep Group Together/With first detail to get my desired result. Again thanks for pointing me in the right direction.

Is there a way to keep the group header from showing on the last line of a page without having to use the Force New Page property? Thank you in advance for any help.

I need to change the value of a field from a number(1) to a letter (X). Can this be done? Help is always appreciated in advance.

I have a query with District,Name,Position.The Position field has multiple contacts(Program,Primary,Secondary). My query results are correct(District,Name,Position) but there are three records. Can I get the Names and Positions in one record for each district? Any help is greatly appreciated.

I would like to build a macro or with some VB code to automatically do the log in for SQL Server rather than having to manually login every single time. Any help is always greatly appreciated.

Great! Thanks for your prompt reply.(Help needed on how to go about doing it).

Is it possible to build a macro or with some VB code to automatically do the log in for SQL Server rather than having to manually login every single time.

Sorry! previous message I sent "Too many tables" should actually be "Cannot open any more tables". Thanks in advance for any help.