Search results

Thank you. :o

Hello. I have a count and a sum expression in a report that are giving me conflicting results. I have one transaction for $5,000 that meets the criteria below. The count appears to be working fine: =Count(IIf([Product]="Business Platinum Points" And [Merchant SIC] In ("4","7","6"),0))...

Hello. For the life of me I can't figure out why I am getting duplicate results for some of my records in a query. I have unique values set to Yes. I have also validated that the tables I am using don't have duplicate data. Thanks for your help. SQL is below. SELECT DISTINCT...

This works great if there is a suffix Left([Last Name],InStr(1,[Last Name]," ")-1) But if there is not one, I get the #Func!

Any non name suffix e.g. JR or III

That didn't work. If there is nothing after the last name I get the #func!

Left([tbl_Rewards Activity Report_Updated].[Last Name],InStr(1,[tbl_Rewards Activity Report_Updated].[Last Name]," ")-1)

Hello, I am trying to perform a Right(Trim on a last name to shed the JR For examle Smith JR....I just want Smith for the field. Thanks for your help.

Hello. I have a query where the intent is to return the most recent Statement Closing Date by Account Identifier. This works great SELECT [ME - Balances and Activity at Cycle End_Updated].[Principal Bank Identifier], [ME - Balances and Activity at Cycle End_Updated].[Account Identifier]...

Never Mind.....seems that it needs the correct path! :)

Hello. I have a pretty simple code to import a spreadsheet. However, I am getting a Run-Time error '3011 The Microsoft Access database engine could not find the object 'Redemption Details$A6:A50000'. I am running another module with the same path, so I know it is not a rights issue. I have...

Hello. I have a report that I am exporting and have two issues: 1.) Some of the labels reflect 'Text 203' instead of what I named the label. 2.) One of the totals is not exporting,=Sum([5 - 29 Bal Sum]). The weird thing is there is no difference when comparing the other totals. It...

Thanks CJ. What if I want to display all of the results?

Hello all. I am driving a query through a form and everything works fine....except when the first letter of the field is the same.. So here is my criteria...Like [Forms]![frm_Delinquency By Tier]![Tier/Program] & "*" I only want the results if the Tier/Program matches what I have selected...

Hello. I have a database (ACCDE) that several users will be using (not at the same time). When I first converted it to ACCDE, because I didn't want users modifying reports or forms, I was getting the 'A potential security concern has been identified'. So I made the path where I saved the...

Thanks for your response and the tool. I will give it a try.

Ouch. That seems messy and confusing. We are talking about 50 users. Any other suggestions?

Hello. I have a form that retrieves information from a query (which of course uses data from a table). Everything is working great and I want to roll it out. However, will multiple users accessing the form/query/table at the same time corrupt the database or not return a result? Thanks.

Hello all. Had the weirdest thing happen today. I have a module Option Compare Database Dim myCheck Function ImportVISACardholderDetail() 'On Error Resume Next DoCmd.RunSavedImportExport "Import-VISA Cardholder Detail" End Function Out of no where today I run the module and the table...

Hello all. The SQL below is part of a query and works fine unless I place criteria (in red below). [qry_VISA Cardholder Transaction Detail - Merchant Rename Query_2].[Revised Category] is an expression and I can get the query to work if I select 'Totals' and 'Group By' in that query. However...