Search results

  1. A

    Count criteria

    Is it possible to stop the values from grouping when the count query is run? Trying to end up with: 12345 2 12345 2 67890 1 So keeping all the original values listed but just adding a count in the next field according to how many times the value in the first field appears - seems...
  2. A

    Count criteria

    Looks like it can just be done with trimming actually, thanks though
  3. A

    Count criteria

    Ah, damn, this is more complicated than I thought - some of the values have the format 12345 (ABCDE), some just have 12345, no parentheses - is there a way of returning all the values, whichever format they're in?
  4. A

    Count criteria

    Genius! thank you, my mistake was trying to solve it with a single query
  5. A

    Count criteria

    Hi, Just after a bit of help please: I'm trying to create a query that counts the number of duplicate records in a table, but that only looks at values outside a set of parentheses, so for example, the table field looks like this: 12345 (ABCDE) And I want to count the number of times 12345...
  6. A

    Problem importing ODBC data tables

    Hi I wonder if I could ask for a bit of help - I'm trying to import an ODBC data source into a new table, and one of the fields contains quite a lot of text. Access only seems to import a certain number of characters, not the whole text, which I need in order to run the queries I'm trying to...
  7. A

    Date Query

    That's brilliant, thanks for your help. Think I've got it working now
  8. A

    Date Query

    Hi Forgive me if this seems like a bit of a rookie question - I'm trying to write a query in access that will delete records that have an entry older than a certain date (eg older than 6 months) If possible, I'd like to make it dynamic, so that when you run the query on any given day it...
  9. A

    Macro dates

    Forgive me for being a bit of a chump... DELETE * FROM tblYourTable WHERE Yourdate <= DateAdd("m", -6, Date()) ...Do I just copy the code and change the table name or do I need to change anything else? Sorry, this is all a bit new to me. Cheers
  10. A

    Macro dates

    Genius Thanks very much
  11. A

    Macro dates

    Brilliant thanks - I'll have a go at that Is there any way of making it dynamic, so that it'll, say, remove entries from 6 months before today's date, and then 6 months from tomorrow's date if I run the same query tomorrow?
  12. A

    Macro dates

    Hi Forgive me if this seems like a bit of a rookie question - I'm trying to write a macro in access that will delete records that were created before a certain date (eg older than 6 months) Any ideas how I might go about making one? Thanks in advance
Back
Top Bottom