Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kastaman

    Lookup function from 2 different cells

    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 -...
  2. kastaman

    Lookup function from 2 different cells

    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...
  3. kastaman

    Query Select previous month volume to calculate sales

    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...
  4. kastaman

    Query Select previous month volume to calculate sales

    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...
  5. kastaman

    Replace Function

    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...
  6. kastaman

    Multiple IIF statement

    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
  7. kastaman

    Combine multiple queries to create a Report

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

    Combine multiple queries to create a Report

    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
  9. kastaman

    Query to Identify various clients

    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...
  10. kastaman

    Multiple IIF statement

    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*...
  11. kastaman

    Query to Identify various clients

    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...
  12. kastaman

    Grouping Query results

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

    Grouping Query results

    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...
  14. kastaman

    Grouping Query results

    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)...
  15. kastaman

    Grouping Query results

    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
  16. kastaman

    transfertext - import into access by selecting from table listing

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

    transfertext - import into access by selecting from table listing

    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...
  18. kastaman

    Drop-down list filtering

    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
  19. kastaman

    Query - sum volumes by month

    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 =...
  20. kastaman

    Link table to new database source

    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...

Part and Inventory Search

Back
Top