Recent content by kastaman

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