User Profile

Collapse

Profile Sidebar

Collapse
Annerb
Annerb
Last Activity: Jan 9 '14, 02:04 PM
Joined: Jan 14 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Annerb
    started a topic Populate spreadsheet with month, day and 24 hr time in half hour increments
    in Excel

    Populate spreadsheet with month, day and 24 hr time in half hour increments

    Hi, I need to create a spreadsheet with Month, Day, and Time in Col A, B, and C respectively. My first time point is 5/17/2013 at 2200. How can I enter a formula that will populate the time in half hour increments and loop back to "0000" after "2330"? Also, I need the date alongside each time point. I entered the first day (B2) and time (C2) manually and applied this formula to B3: =IF(C3>0,B2,B2+ 1)

    A...
    See more | Go to post
    • Annerb
      replied to How to update existing table with new data
      in Access
      I am changing the existing records. Right now I have no data in the chemical fields for some samples (because the analysis is ongoing). So, I have an entry for all samples collected (i.e. "records") but need to update their chemical fields with the newly acquired data. I believe an update query is appropriate, but I'm not sure if I need to establish a relationship between the two tables first based on the unique identifier for each sample....
      See more | Go to post

        Leave a comment:

      • Annerb
        started a topic How to update existing table with new data
        in Access

        How to update existing table with new data

        Hi,
        I have a large database of environmental data. I have received the results of some chemical analyses and need to update the records in the original database with the new data. I have imported the chemical data as a new table. I have a unique identifier for each record- the same in the original table and in the chemical data table. How do I update the records in the original table with the new data? Do I need to "join" these two...
        See more | Go to post
        • Annerb
          started a topic Access adds a Date to the times in my field - how to remove date?
          in Access

          Access adds a Date to the times in my field - how to remove date?

          After importing a column of times into Access from Excel, Access adds a date from the year 1899 into each record.
          So now, my time of 18:05 looks like this:

          12/30/1899 6:05:00 PM

          How can I remove the date and change the display of 06:05:00 PM back to military time "18:05"?
          See more | Go to post
          • Annerb
            started a topic Convert time displayed as 6:05:00 PM to 18:05 in Excel for import into Access
            in Access

            Convert time displayed as 6:05:00 PM to 18:05 in Excel for import into Access

            I have a column of data in Excel with times displayed stored using the 12 hr clock. However, it is displayed in the cell as 24 hr. So, I see 18:15 in the cell but when I select it, the entry is 06:15:00 PM. I need the actual entry to be 18:15. How can I convert this to the 24 hr clock?

            Right now my cells are formatted as Time, with Type being "13:30".
            See more | Go to post
            • Annerb
              replied to set all number fields to 2 decimal places
              in Access
              Ahhhh ok. Perhaps I should send a suggestion to MS to include that option in the next version of Access... :)
              Thanks!
              See more | Go to post

                Leave a comment:

              • Annerb
                started a topic set all number fields to 2 decimal places
                in Access

                set all number fields to 2 decimal places

                Hi,
                I have a database with 20 Number fields (20 columns of number data). Is there a way to set all Number fields to display two decimal places without going through each and every field property box and changing the decimal field from "Auto" to "2"?
                See more | Go to post
                • Annerb
                  replied to Add SD column to an existing Access database with averages
                  in Access
                  Thank you both for your replies. I'm new to Access so I haven't yet figured out differences in query functions and obviously didn't realize I left out some key details in my question.

                  @Neo I see your point about using databases to calculate Avg and SD. I can then export those values to Excel and manipulate, make graphs, etc there.
                  See more | Go to post

                    Leave a comment:

                  • Annerb
                    replied to Add SD column to an existing Access database with averages
                    in Access
                    Do I go straight to making an Update Query or do I have to join these tables? I don't understand how to set up my query... Could I use the Append feature?
                    See more | Go to post

                      Leave a comment:

                    • Annerb
                      started a topic Add SD column to an existing Access database with averages
                      in Access

                      Add SD column to an existing Access database with averages

                      I have a database containing an average column. I need to add a column of data listing the SD. How to I add this column and make sure each value is matched up with the right site? The averages database is in Access. The data containing the SD is currently in Excel. Each file contains the unique ID for each site.
                      See more | Go to post
                      • Annerb
                        started a topic parsing a long ID into separate fields
                        in Access

                        parsing a long ID into separate fields

                        I am attempting to separate a unique ID into separate fields (columns) using the Right/Left command. I am able to do this when I specify to use the rightmost or leftmost characters but am getting an error message when I specify to take the 2 characters starting from the third character in. Here is an example of my unique ID: 2011_1_HeronSS_ 3

                        Using Right([unique_ID],1) returns "3". That is what I want.
                        However,
                        ...
                        See more | Go to post
                        No activity results to display
                        Show More
                        Working...