Search results
-
M
Am I using the right query v. Union Query??
This is my query:[ SELECT NAIC, [Time to Maturity], RBC_CLASS, SumofBookValue FROM [qryDUMMIES] UNION SELECT [qry ReconD1 Tenure].NAIC, tblWALGroups.[Time To Maturity], IIf(([sec_group]="BONDS" Or [sec_group]="MBS / CMO") And Not ([new_type]="PFD SEC" Or [new_type]="PFD SEC YA" Or... -
M
Important Dynamic Range from Excel
Hi guys, I am trying to import a dynamic range I made in Excel into a table in access. I use the code below to import a range from excel into a table. The range I have in excel is defined as =OFFSET(ybport!$A$2,0,0,COUNTA(data!$A:$A)-1,5) and is named yieldbookMort. The VBA code below in...- Mennochio
- Thread
- Replies: 0
- Forum: Modules & VBA
-
M
Parameter Query Error (Have already Read previous Discussions)
All, I am having difficult with some code that is making use of a query that has a parameter in it. I have read the discussions here and think that I have made use of the suggestions to overcome the error. However, even with the code in place I am getting a popup box prompting me to enter the...- Mennochio
- Thread
- Replies: 5
- Forum: Modules & VBA