Search results

Thank you. Where would one find those system files?

Hello. I pasted the tables, modules, macros, etc. from one database to another and the only thing left is the Saved Import. How can I get that into another database? It is quite a large import, otherwise i would just recreate it. Thanks.

I am using Access 2010. I am a little confused about using Where. I generally only use where when I don't want the result displayed....betwee[start date]and[end date]. In this case I want the [Cycle Date] as part of the output. This is what I want my output to look like...

First off, thank you for taking time to look and respond to my issue. [Cycle Date] is the prompt for the date. I need the cycle date, which is not in the table that the query is using, in the final text file (we use the information in an index upload). Hope that helps.

SELECT [tbl_Card Holder Journal Report_Update].[Miscellaneous Third Text], [qry_VISA Statement Index from PSCU Conversion].CardWithDashes, [Primary First Name] & " " & [Primary Middle Name] & " " & [Primary Last Name] AS FullName, [Cycle Date] AS CycleDate, "M:\" & "" & [Field2] AS...

Hello all. Having issues exporting a query to a delim text file. DoCmd.TransferText acExportDelim, "", "qry_VISA Statement Final Index", "R:\DEPT-BR\CONSUMER LENDING\VISA\VISA Statements\VISA Final Index.txt", False The file itself exports just fine. However, in the query I have a prompt...

Now I am getting the Overflow message..... bizarre.

Yes sir. Something I forgot to mention. The query works great without the Criteria. Once I populate the field though, I get the prompt.

Hello. I am trying to set a Criteria of >.50 for the expression below. Available%: [Available]/[Credit Line Amount] However, I get prompted for a parameter value. I have saved the query and have even tried to build another query with this query as the source to no avail. Is there...

Hello. I have a simple query that prompts the user for the # of transactions and also the low and high credit available. SELECT [qry_Cardholder Data for RePrice Through Oct 2012].PRIN, [qry_Cardholder Data for RePrice Through Oct 2012].[Account number], [qry_Cardholder Data for RePrice...

thank you sir. Worked.

Hello all. Today has been plagued with weird simple problems... Anyway, here is a simple formula: Total$BalSameRate: [qry_Reprice - Stay at Same Rate - A+]![SumOfBalance]+[qry_Reprice - Stay at Same Rate - E]![SumOfBalance]+[qry_Reprice - Stay at Same Rate - B]![SumOfBalance]+[qry_Reprice -...

Thanks for the response. Even with using your suggestion I still get the #Type! message.

Hello all. In a report I am tryintg to divide the CountOfAccount number by by the total number in another query. Individually in the report I get the totals, but when I try to get the % using the formula below, I get #Type! =[qry_Reprice - Stay at Same Rate - A+]![CountOfAccount...

Worked. Thank you sir.

Thank you for responding. However, I am getting a Data type mismatch in criteria expression error message.

Hello all. I am trying to perform an Average IF calculation in a query with multiple criteria. This is what I came up with: A+AvgBal>1: Avg(IIf([qry_Cardholder Data for RePrice Through Oct 2012]![FICO 0512] Between 730 And 9000,[qry_Cardholder Data for RePrice Through Oct...

Hello all. I have a query that I am trying to copy/paste the contents into an Excel template I built. The weird part is that when I try to paste the data as text or .csv, it doesn't paste any expressions I have. If I just straight out paste, it does, but not paste special. Any ideas...

Thanks pbaldy! Worked. Thanks for the information Bob.

Hello all. I am having an issue with an expression in a query. What I am trying to do is to sum [Account Balance Total Amount] IF the [External Status Code] is null. When I use Expr1: Sum(IIf([External Status Code]=" ",[Account Balance Total Amount],0)) I get a zero result When I use...