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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Cowboysooner

  1. Cowboysooner

    Problem using Totals function in a query

    Yes, I have "group by" for the [salesman] field but I still have a problem. I have a [Number of Sales] field with a DCount formula that correctly calculates the total number of sales when set to "group by" (all salesman show the total number of sales for the column, Adams =...
  2. Cowboysooner

    Problem using Totals function in a query

    Thanks for your response but I'm having trouble creating the totals query. I am able to get a total for an entire column but can't get it to separate the activity per salesman. For example, using my previous post, totaling the Date Closed column gives a value of 6, I need to know that Adams had...
  3. Cowboysooner

    Problem using Totals function in a query

    Thanks for your response but I'm having trouble creating the totals query. I am able to get a total for an entire column but can't get it to separate the activity per salesman. For example, using my previous post, totaling the Date Closed column gives a value of 6, I need to know that Adams had...
  4. Cowboysooner

    Problem using Totals function in a query

    Existing Table: Cross Cross Date # of Sale Sale Closed Spreads (1) (2) Adams 1/1/03 3 RREM DDA Adams 1/5/03 2 DDA Adams 1/6/03 2 Jones 1/1/03 1 RREM Jones 1/2/03 1 RREM DDA Jones 1/6/03 1...
  5. Cowboysooner

    Can a drop down menu limit options in next cell?

    I have a drop down menu with the following items: Drop down menu #1: Residential Real Estate Treasury Management Investments I would like Drop down menu #2 options to be limited. For example, drop #1 choice is Treasury Management, then drop #2 options are limited to Treasury...
  6. Cowboysooner

    Can Access 97 identify users & limit access

    Is it possible, when opening access 97 for the program to ask the user his name (or other identifier) and then auto populate fields with the user's info (for example division, location, name, address) [maybe using autoexec] while allowing the user to only look at data he has input? I don't need...
  7. Cowboysooner

    In Access 97can I combine three date fields into one field?

    Works great. I was able to combine columns using IIF but your method is much easier. Thanks for your help.
  8. Cowboysooner

    In Access 97can I combine three date fields into one field?

    My query calculates due dates and must use three fields due to the large size of the formulas. Consolidating the formulas to one or two fields results in a "too complex" error message. I would like to combine the results of the three fields into a single field. The formula output for...
  9. Cowboysooner

    How to calculate dates using info from columns

    Your suggestion worked. How can I use a wildcard in a formula to account for spelling differences? For example: Audit, Audited, or a misspelled variation. I tried to use "Aud*" but this didn't work. Thanks for your help!
  10. Cowboysooner

    How to calculate dates using info from columns

    I agree, DateAdd()is easy to use. I am able to add a specific number of months etc. to every date in a column containing dates. What I can't figure out is how to add different numbers of days to the date in the Last Date Received column based on the type of financial statement listed in the...
  11. Cowboysooner

    How to calculate dates using info from columns

    The formula in the Date Next Due column causes syntax errors and does not work in Access 97. It works just fine in Excel 97. Please help. Required Last Date Document Frequency Received Audit Annually 12/31/01 Compilation...
  12. Cowboysooner

    IF statement problem in Excel 97

    That works. Thanks for your help.
  13. Cowboysooner

    IF statement problem in Excel 97

    Are the logical tests in excel 97 limited to numeric fields only? The following IF statements produce a FALSE result but field A4 does equal Audit and A5 does equal Compiled. 1 A B C D 2 Date Last Date Next 3 Document Frequency Received Due 4...
  14. Cowboysooner

    Can Access find and combine duplicate fields when one of the fileds co

    I have two tables. One with Company Name, Number of Employees and Address, the other with Company Name, Sales Size, Address and Phone Number. The tables are from different sources. Can I combine the records of these files based on a 70%-90% match of characters in the company name field? The...
  15. Cowboysooner

    Please Help, Read Only Problem in Access 2002

    This is very annoying. I have created numerous queries of an extremely large database but Access 2002 will not allow these queries to be exported to Excel or any other program. It says the database or object is read only; however, I am able to delete the queries which makes no sense if it is...
See more

Part and Inventory Search

Back
Top