User Profile

Collapse

Profile Sidebar

Collapse
Wiredboy
Wiredboy
Last Activity: May 18 '12, 04:47 PM
Joined: Jan 11 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Wiredboy
    replied to Importing Data from Excel to Access
    in Access
    Hi Mariostg, I formatted all columns and fields exactly the same as in the Acces tables, the problem is that the ID field is formatted as autonumber, I don't know if i should try to leave that field blank and let the database insert the correspondent number in there. All fields that I have a combo box frmatted on the lookup properties tab are giving me problems. Suggestions?
    See more | Go to post

      Leave a comment:

    • Wiredboy
      started a topic Importing Data from Excel to Access
      in Access

      Importing Data from Excel to Access

      Hi to All!!

      I need to inmport a Data from Excel to Access but the tables in Access are defined with a primary Key [ID] that is formated as an auto number (I'm using a template that I found on Internet!!) and it is giving me an error when i try to import it to my database, I can't. Also there are other fields on the table that are formatted to make a link to a list on the lookup properties than when i try to make the process, it deletes...
      See more | Go to post
      • Wiredboy
        replied to Convert a date range to number of days!
        in Access
        Thanks!!! Worked like a charm!!!!! Eventhough I made some adjustments to the function but it worked!!! Thanks again!!!!!
        See more | Go to post

          Leave a comment:

        • Wiredboy
          replied to Convert a date range to number of days!
          in Access
          Here is the query:

          Code:
          SELECT INTERVALREP.Date, SKILLS.DEPARTMENT, INTERVALREP.INTERVAL, SKILLS.SKILLID, INTERVALREP.CALLS, INTERVALREP.ABDNCALLS, INTERVALREP.SVL
FROM (SKILLGROUPS INNER JOIN SKILLS ON SKILLGROUPS.DEPARTMENT = SKILLS.DEPARTMENT) INNER JOIN INTERVALREP ON SKILLS.SKILLID = INTERVALREP.SKILLID
GROUP BY INTERVALREP.Date, SKILLS.DEPARTMENT, INTERVALREP.INTERVAL, SKILLS.SKILLID, INTERVALREP.CALLS, INTERVALREP.ABDNCALLS,
          ...
          See more | Go to post
          Last edited by NeoPa; May 27 '11, 05:30 PM. Reason: Added mandatory CODE tags

            Leave a comment:

          • Wiredboy
            replied to Convert a date range to number of days!
            in Access
            Thanks Smiley but i'm not very good with VBA codes and I've tried calculating directly on the query but it is not working. I think I'm missing something. What i'm trying to calculate is an average of calls during a period of dates that are not the same each time you run the query because the query itself ask for the date range.
            for example: Between [from] and [to],

            using from as date1 and to as date2 when the query ask for...
            See more | Go to post

              Leave a comment:

            • Wiredboy
              started a topic Convert a date range to number of days!
              in Access

              Convert a date range to number of days!

              Hi all, I needt to convert a date range on an ACCESS query to a number that represents the amount of days on that range to use it to make an average. for example:

              from 5/23/2011 to 5/25/2011 = 3 days

              Please let me know if there is a way to do this.

              Thanks!!!!
              See more | Go to post
              • Wiredboy
                replied to How to calculate the average of 5 columns on a database (access 2007)
                in Access
                Thank you guys! It's really working now!!!
                See more | Go to post

                  Leave a comment:

                • Wiredboy
                  replied to How to calculate the average of 5 columns on a database (access 2007)
                  in Access
                  Thanks NeoPa but i've already tried that and is not working for me since not all of the times all of the columns have a value attached to it. for example maybe it has to calculate the Avg of only 3 columns instead of 5??!!!
                  See more | Go to post

                    Leave a comment:

                  • Wiredboy
                    started a topic How to calculate the average of 5 columns on a database (access 2007)
                    in Access

                    How to calculate the average of 5 columns on a database (access 2007)

                    Hi, i'm pretty new in this and i hope somebody can help me with this:

                    i have a db with 5 columns with different values and i want to calculate the average of them. I've tried to create a formula directly on the query but is not working ( ex. MONTOTAL : Avg([MON1] + [MON2] + [MON3] + [MON4] +[MON5]) )

                    al it does is giving me the sum of the columns and not the average. Maybe i have the formula all wrong, that is why i...
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...