Search results

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

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.

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.

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.

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.

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.

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.

I have a report that has many subreports.When I preview them it looks great,but when I tried to email the report an error showed up. "Too many tables". Is there a limit to how many tables you can use in reports and is there a way around it?

I want to send a report each week automatically to two recipients. If I am away from the office it still sends report.