Search:

Type: Posts; User: hohepa; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.02 seconds.

  1. Replies
    1
    Views
    460

    I have a string of text separated by a...

    I have a string of text separated by a semi-colon, maybe 50 separate items.

    I want each item to haveits own separate row.

    How might this be done?

    I found this macro:
    Sub MyReplace2()...
  2. I want to send a message to a large group of...

    I want to send a message to a large group of people at work but would rather not take any responses. Is there a way to do this in Outlook?
  3. Re: SUM function not working for lookup field (2003)

    I'm gonna try that. Thanks!!
  4. Re: SUM function not working for lookup field (2003)

    The field I am trying to summarized is the field "altered_consciousness" in table "injury_information_tbl". The field "altered"consciousness" is a lookup field of type Long Integer. The field looks...
  5. SUM function not working for lookup field (2003)

    Problem: I have a lookup field that holds numbers (options are 0 or 1). In a query, I would like to use the SUM function to add the values. For example, if I have entered two 1's and three 0's, I...
  6. Re: Report not showing all records from query (Acc

    Thanks a lot for your response and that does make it so all records show. But it does lead to another issue, I need to have the report ordered by the last name of the registrant.

    So, I want all...
  7. Re: Report not showing all records from query (Acc

    Thanks for sticking with me on this. I have stripped down the DB, including just those records that are not showing. Again thanks, Joe
  8. Re: Report not showing all records from query (Acc

    Yes, the report is grouped by last name. The records show registrants for a dinner and their guest(s). So, one registrant can have more than one guest.

    The Hide Duplicates is set to No.

    I...
  9. Report not showing all records from query (Access

    Hello, I have a report that draws from a query. However, the report is not showing all the records listed in the query. If there are records that have the same last name the report is skipping one of...
  10. Replies
    4
    Views
    315

    Re: DISTINCT statement (2003)

    Thanks, that will do the trick
  11. Replies
    4
    Views
    315

    Re: DISTINCT statement (2003)

    What I really want is to display all the fields for the record. But I just want to see the records where the EncounterNumber is distinct. Is that possible? Thanks
  12. Replies
    4
    Views
    315

    DISTINCT statement (2003)

    I know I should know this but I am drawing a big blank.

    I want to create a query that pulls a number of fields from a table. But I want a certain field (the EncounterNumber) to be distinct.
    ...
  13. Re: problem with repeating autonumbers (Access 97)

    Thanks, your tool solved the problem. It was my mistake but this was for an Access 2000 issue. Sorry for misleading everyone. Take care
  14. problem with repeating autonumbers (Access 97)

    Hello, I built a simple database for a friends dog boutique so she could keep track of her customers.

    She told me that when she goes to add a new contact that she receives a message that the...
  15. Re: Top value for each disting ID (Access 2003)

    Thanks, this did the trick.
  16. Top value for each disting ID (Access 2003)

    Hello,
    I have a table that records when a user logs into a message board. I have fields that record the userID and the time of their login.

    I want to write a query that shows all the distinct...
  17. Replies
    8
    Views
    448

    Re: looping through a query (2000)

    Thanks Hans, I appreciate you looking at this. I have requested a document that provides more information on this process and will post it when I have it.
  18. Replies
    8
    Views
    448

    Re: looping through a query (2000)

    This report is completed as a stored procedure on the department's SQL Server. The setup is that there will be a local desktop version that uses Access. The data is then sent to the SQL Server. Is it...
  19. Replies
    8
    Views
    448

    Re: looping through a query (2000)

    The record being evaluated has to do with surgical data. Each record has 22 fields that are evaluated through a fairly complex algorithm to determine the category in which they belong.

    The...
  20. Replies
    8
    Views
    448

    looping through a query (2000)

    I need to build a query that takes a single record and evaluates it for about 10 different criteria before assigning it a specific category. After it is assigned to a category then I need to do the...
  21. Replies
    1
    Views
    240

    Losing grid in Query view (2002)

    Hi,

    Every now and then I design a query on my PC that has a screen resolution of 1600x1280. When a user with a lower screen resolution tries to view that query they often cannot see the grid...
  22. Update table field based on event (Access XP)

    Hello,

    I am using Access XP as back end for a Web-based calendar application. I want to be able to enter class information in tblClasses and enter a maximum number of students who can attend...
  23. Re: Creating a sum calculation for a particular month (Access XP)

    Thanks, this works and helps with one issue.

    Now another issue, how would I write the expression if I wanted to set the month myself rather than ask the user for the criteria.

    For instance my...
  24. Creating a sum calculation for a particular month (Access XP)

    Hello, I want to sum the number participants in classes we offer for just one month. I can write the query so that all months show but just need one particular month to show.

    So I want to write...
  25. Replies
    2
    Views
    304

    Re: importing from Word table (XP)

    Thanks that did the trick!
Results 1 to 25 of 39
Page 1 of 2 1 2