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

    PHP Setup

    I am trying to install PHP 5 on Windows IIS 6.0. I am using the installer to setup and configure the web server. When I complete the installation it says that the installation has been successfully completed. However, when I try to access .php files from the server it says that they are 404...
    • Olddogg
    • Thread
    • Replies: 9
    • Forum: PHP
  2. Olddogg

    Duplicates Removed

    I have a Query that I am using then I plan to mail merge the fields into word. The problem is there is duplicates coming out of the query and I do not want to waste a bunch of labels/paper. Is there any way to filter out duplicate records in a query? Do I have to redesign the query? Thank...
  3. Olddogg

    Default Value in a Table Field

    Hi I am building a Revenue Scan for my company. I am trying to build it as friendly as possible. Here is my problem: I am trying to make a default value in design view that depends on two other fields. Amount Agent Agent Comp (the default value field) are the three fields... the default...
  4. Olddogg

    Where, Where, Group By, Sum (Newbie)

    SELECT [2004 Year End (Sept 30)].[Sale Type], Sum([2004 Year End (Sept 30)].Amount) AS SumOfAmount FROM [2004 Year End (Sept 30)] WHERE ((([2004 Year End (Sept 30)].Date)>=#12/1/2004# And ([2004 Year End (Sept 30)].Date)<=#12/31/2004#)) OR ((([2004 Year End (Sept 30)].Date)>=#12/1/2004# And...
  5. Olddogg

    Where, Where, Group By, Sum (Newbie)

    Doesn't seem to be working. I must be doing something wrong. Any other suggestions I would really appreciate it... Thanks again PHV
  6. Olddogg

    Where, Where, Group By, Sum (Newbie)

    1st 'where': >=#12/1/2004# And <=#12/31/2004# 2nd 'where': Not "fair/wat" 'groupby': "grp/ind" and 13 other sale types down the column Sum: the amounts ------------------------------------ output: Sale Type SumOfAmount cdc-di 265.13 cdc-erp 1200.16 cdc-group 24877.3 cdc-life...
  7. Olddogg

    Where, Where, Group By, Sum (Newbie)

    I am building a revenue scan for my company. The query that I am trying to build adds up the revenue for that month. The first 'where' expression filters out the dates that I want for the additions. (works fine) The second 'where' I am trying to filter out one of my agents. However, it does...
  8. Olddogg

    Can you Create new Query from VBA

    Thank you so much PH! Works like a Charm! Jon
  9. Olddogg

    Can you Create new Query from VBA

    I am trying to filter from a last name field. What I am looking for is to be able to type in: "sm" and the records that will come up will include: - smith - smythe - smithers etc..... I am trying to use the wildcard : * in VBA but it doesn't seem to be working. Does anybody have any...

Part and Inventory Search

Back
Top