Recent content by Cmacvp16

  1. C

    Query Field Value Based on Min Date

    I still am unable to fiqure this out. On the surface this seems rather simple. Sorry :(
  2. C

    Query Field Value Based on Min Date

    I need to run a simple query to pull one record and their value, for each member, based on Service Date. Table Client DOS Receipt J. Smith 01/01/2003 $295 J. Smith 02/15/2003 $215 H. Jones 03/18/2003 $415 H. Jones 03/15/2003 $400 Query Results Clint DOS...
  3. C

    Set a Field's Index

    I have a macro that "Drops Table" and then "TransfersText" to build the replacement table. Can I use SetValue to set table fields - "Indexed" to "Yes (Duplicates OK)"? Everytime I create the table I have to manually change four fields Index setting to "Yes (Duplicates OK)".
  4. C

    Find space location in a text string

    Thanks!!!
  5. C

    Find space location in a text string

    What function in Access is equivalent to the Find function in excel? I need to identify the position of the first space in a text string. ex. North Florida Office ( Answer 6, the space location between North and Florida) Or How can I simply pull the first word in a text string in a Report...
  6. C

    TopValues

    I am trying to query a table with monthly values over a year. I need to return the Top 5 values in each month (60 records). Instead I am return the Top 5 values for the whole year (5 records). Do I need to run 5 seperate queries or can this be done in one?
See more
Back
Top Bottom