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 TouchToneTommy 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: *

  • Users: JITA
  • Content: Threads
  • Order by date
  1. JITA

    Summarise per day from one table with relation to other table with dates

    I have 2 tables: Table1 is filled daily with information about clients from a legacy system. Every day we determine which client is "new" in that table with a query that is comparing today's records with yesterday's records. The outcome is used in a form showing "new" records in the table. This...
  2. JITA

    match a sale date to a price date.

    Hi, I am trying to figure out how to match a sale date to a price date. I have three tables: tblProd ID Desc tblPrices PriceDate Price ProdID tblSales SaleDate SaleQ ProdID Prices do not change frequently, so the tblPrice is not updated regularly. What I would like to achieve is to find a...
  3. JITA

    Match value with certain date or later

    Hi, I am trying to figure out how to match a sale date to a price date. I have three tables: tblProd ID Desc tblPrices PriceDate Price ProdID tblSales SaleDate SaleQ ProdID Prices do not change frequently, so the tblPrice is not updated regularly. What I would like to...
  4. JITA

    error 3078 / to few parameters, expected 2

    I am using ACCESS 2007. I have a table containing items with a start date and an end date. In a query I try to calculate the number of months that the items from the table are within the period that is requested by the query. Example: when I run my query it will pop up two dialog boxes, one...
  5. JITA

    Analyzing two sets of data from two queries

    Hi I hope somebody can give some advise on how to handle my "challenge". I have two tables with financial information over several years. I want to create a query that shows me data from two years in two seperate columns. In order to achieve this I have created a union query that sums up the...
  6. JITA

    Union query with running total

    I have a union query (UqryDagMutaties) on two tables that returns the following fields BankNr (text) DatumMutatie (date) GrbNr (number) Bedrag (number) RekOmschr (text) Omschrijving (text) Based on this union query I have created a Totals query to show filtered records. The records are shown on...
  7. JITA

    Sorting on calculated field (MSAccess 2007)

    I am trying to sort a calculated field in a query (ascending order). The field involved is calculated from three field that all give back a sorting order on fields from the table (with thanks to you already). My SQL statement is as follows SELECT tblCl.ClNaam, tblVerm.Verm, tblVerm.Rev...

Part and Inventory Search

Back
Top