Search results for query: *

The cells (B1 & C1) have numeric values and through the combination of the value of each cell, cell A1 would have the specific message Cell B1 C1 Lookup for B1 (Qty) 1 - OK 2 - OK 3 - 1st Notice 4 - 1st Notice 5 - 2nd Notice Lookup for C1 (Occurences) 1 - OK 2 - OK 3 - Ok 4 - 1st Notice 5 -...

Hi there, We're trying to create a lookup that refers to 2 different cells but with no luck. The problem for cell A1 we need a lookup for cell B1 and C1 and depending on the values for each (I have 2 lookup ranges for cell B1 and C1) we should get a result according to the range lookup. Hope...

JonFer, Here is the underlying query: SELECT [tbl_Client_Volumes].[Client], [tbl_Client_Volumes].[Form], Format$([tbl_Client_Volumes].[Date],'yyyy / mm') AS [Billing Month], [ImpressionPrices].[Price], Sum([tbl_Client_Volumes].[Impressions]) AS [Total Impressions], [tbl_Fiscal_Year].[Fiscal...

Hi there, I currrently have a crosstab query where the monthy volumes are exctracted and I have a formula to calculate the total commission by product YTD. Is there a way to show on another column just the previous month's commission? Grand Total 2003 / 11 2003 / 12 2004 / 01 $17.64 77.00...

Hi there, I'm looking for a way to convert the results of my query: INSERT INTO tbl_Client_Volumes ( Form, Impressions ) SELECT DISTINCTROW tbl_Data_Info.Form, Sum(tbl_Data_Info.Impressions) AS [Total Impressions] FROM tbl_Data_Info, tbl_Client_Data GROUP BY tbl_Data_Info.Form HAVING...

BNPMike, If I use the WHERE, could I use this as an expression statement where the result would be the Client: WHERE[Form]='2320' AND [JobName]='*HBC*'AND [Printer]='x*' Field = Alpha. Thanks in advance, Kastaman

M8KWR, How would I combine the reports? Would this be like a subreport scenario? Thanks in advance, Kastaman

Hi there, I have a few queries that have parameters that are client specific [formNo] and {jobName]. I'd like to create a report that would present the info from the queries. Do you have any suggestions. Thanks in advance, Kastaman

PH, The other query: SELECT DISTINCTROW tbl_Client_Data.Client, Format$([199911].[Date],'yyyy / mm') AS [Billing Month], [199911].Account, [199911].Jobname, [199911].Form, Sum([199911].Impressions) AS [Print Impressions] FROM 199911, tbl_Client_Data GROUP BY tbl_Client_Data.Client...

Hi there, We have 3 clients that have 3 parameters that would identify the cliet: CLIENT Parameter 1 Parameter 2 Parameter 1 Alpha [Form] = 2320 [JobName]= *HBC* [Printer] = x* Beta [Form] = 83* [JobName]= *BIZ* [Printer] = p* Sigma [Form] = legal [JobName]= Mel*...

PH, SELECT DISTINCTROW tbl_Client_Data.Client, Format$([199911].[Date],'yyyy / mm') AS [Billing Month], [199911].Form, Sum([199911].Impressions) AS [Print Impressions] FROM 199911, tbl_Client_Data HAVING (((tbl_Client_Data.Client) Like "Biz*") AND (([199911].Form) Like "*BIZ*")) The specific...

Cosmo!! That is exactly what I needed. Thanks so much. Thanks in advance, Kastaman

Hi there, Here is an example of how the query works and what I actually wanted to accomlpish: Current Query: Client Jobname Print Impressions Mellon EITFKGCN 24,303.00 Mellon EITFKGEN 15,183.00 Mellon EITFKNBN 12,906.00 Expected Result: Client Jobname Print Impressions...

Leslie, My query looks like: SELECT DISTINCTROW tbl_Client_Data.Client, [199911].Jobname, Sum([199911].Impressions) AS [Print Impressions] FROM 199911, tbl_Client_Data GROUP BY tbl_Client_Data.Client, [199911].Jobname HAVING (((tbl_Client_Data.Client) Like "*mellon*") AND (([199911].Jobname)...

Hi there, In my access query, I'd like to group the file names according to the first 3 letters of the file: File name = Query Grouping result Alpine = Alp* Alpo = Alp* Beta = Bet* Bettin = Bet* Thanks in advance, Kastaman

Found the answer after reading through many pages in my search: thread181-11380 Thanks in advance, Kastaman

Hi there, On a monthly basis, we import some text files into our database. In order to do this we created a transfertext macro. I'd like a way to import the text files so that we don't need to change the file name in the macro every month, instead I was hoping for a code that will give us a...

Hi there again, Going through the design of the forms & tables and you mentioned that I should have tblPriorSelections AND tblSelectedTeams. Firstly, do I need both table and secondly, how will the info populate the tables? Via forms/query? Thanks in advance, Kastaman

Hi there, Need some help in designing an append query, I have a transaction table that has beed imported every month. I'd like to sum up the volumes by form used and month/year for example: Form Transaction Month Volume 12345 August 2004 1,205,200 I was trying =...

Thanks Randy, I created a Macro to import the data, but there are 2 files that need to be imported each month. Would it be easier just to run the import command 2x, each time identifying which month and file to be imported rather than creating 2 commands that will ask which files to import...