• Apply 2 mathmetical operators on Access fields

    Hi all, could you help me to create new field on Access table calculating the sum of two other fields and divide it by 2? I am struggling with its syntax. Thanks a lot.

    Knowledgeislight5 pointsBadges:
  • Paste from Microsoft Excel cells to Microsoft Access table successfully but…

    When I perform a Paste Append into the table, the field I need that is a hyperlink is being truncated, thus link fails. How can I get the link to pates exactly as is from Excel?

    Lpjedpp5 pointsBadges:
  • How do I convert rows to columns in aAccess using Ms-access query(select statment)

    Hello all, please I want help with the following issue: I have the following table named "CHECKINOUT" in ms ACCESS USERID      NAME        CHICKTIME 1          K1        5:45:11 AM 1          K1        3:45:12 AM 1          K1        6:45:11 AM 1          K1...

    Ahejazi5 pointsBadges:
  • How to link to different tables based on an index in the first table in Microsoft Access 2010?

    I am setting up a database of photos and fine art prints made from those photos. I have a table that lists each photo and its related data. Each photo can then have a number of prints made from it (each one can be different size, material etc.) They should each be numbered individually and...

    agelidis5 pointsBadges:
  • Creating correct relationship for report

    I am creating a report that states a taskcard # plus the panels and zones that need to be inspected under that number. All are originated by an MPD #. I have 3 tables - a taskcard/MPD #; access panels/MPD #; zones/MPD#. My intention is that the MPD# gathers the taskcard # associated with it, plus...

    hhoman5 pointsBadges:
  • Help with relationships in Microsoft Access 2010

    I am office manager in a service company that installs internet. A customer orders internet from the store, the store places the order and equipment is sent out for that job. There is a cantenna serial number, and IMEI and a router serial number that is unique to each order. There is also an order...

    AmWireLa35 pointsBadges:
  • Creating tabbed forms with data from different tables in Microsoft Access

    Hi! I'm a beginner on Access. I'm designing a database for school management system. I have a tables; Student Information, Math, Physics, Chemistry, Biology..... I want to create a form with student information then have 7 tabs for subjects information.

    Pegsoonline5 pointsBadges:
  • Relational Database

    What kind of tables are used in a membership database other than name & address.

    4jab15 pointsBadges:
  • Getting data from two sources into one table

    I have a form that will add data to say mainTable. In the form, I want to get some data like last name, first name and client_number from a linked master table (using a combo box) and have that data added into mainTable . I would also like to enter data (last name, first name and client_number)...

    handlewhat5 pointsBadges:
  • Update query doesn’t update table

    This is a really basic question, but I can't seem to make it work. I have a simple table with 3 fields. StartTime EndTime ElapsedTime Each field is defined as a date/time datatype. StartTime and EndTime are manually entered. I'm trying to use the DateDiff() function in an update query to populate...

    bonesie15 pointsBadges:
  • Formatting Cells individually in a Table – Microsoft Access

    I am currently in the process of using a Table to track employee annual leave, I need to be able to highlight all the weekends (saturday and sundays) in a different color to make easier to read. How do I do this?

    azuby2420 pointsBadges:
  • Cannot find tables

    I am working with a ms access file. When I look at the objects in the access objects window using a category of "object type" I only see one table, when I use the category "Tables and views" I see three tables, these extra two tables are in the dropdown list if you try to create a new relationship....

    Chucky6665 pointsBadges:
  • Date format in table

    I record dates of birth and death from headstones. Often I only know the year, or sometimes the month and year. How can a create a table field to accept the info I have and not require a full date (month, day, year). I also would like to have a DateDiff field that will show the age at death from...

    LostSpring5 pointsBadges:
  • Access

    How do I change the selected columns to be required pieces of information?

    gooman5 pointsBadges:
  • columns in table (Access)

    I am trying to create a table in Access and every time i do, my field/columns are starting from the right side instead of the left side.  Nobody seems to know how to change it.  Help.

    Beck5 pointsBadges:
  • Writing to multiple fields with one text box

    I am trying to find a way to get a single text box to write to multiple fields within a table. The reason I want to do this is for graphing purposes (with an outside source) and to not over crowd/complicate a form for the operators who will be using it. If this is not possible is there a way to...

    Manalyn35 pointsBadges:
  • Linking Fields from different tables (one table empty)

    So I have 3 tables (table 3 being the issue but I have to explain the relationships for clarity): Table 1: Information is provided by Home Realtors into our online database and updated automatically to an access database on my computer. Info given: Home Serial # Home sq footage Home Location Table...

    JRob15 pointsBadges:
  • Access or SQL Server tables

    Yes I am consultant for a small business, and currently they have a Access database that works pretty decently. At the current situation, the owner needs another database. I really do not want to have to ask the developer to keep creating different databases that includes him having to put more...

    Imjnice15 pointsBadges:
  • Combining Access 2003 Queries for Dates Criteria

    I have a MainInfo table and 3 different Log tables (PleadingsLog, LitigationLog and DiscoveryLog) that are linked to the MainInfo table by an IDnumber. Each of the log tables contains a date field and a notes field. I am trying to find a way to query all records from the MainInfo table that show a...

    GCIB15 pointsBadges:
  • Get the latest unique entries for user ID in Access database

    I have a database with a table that lists message entries. Each entry has an autonumber field ID, and a UID field that groups messages. My question is, how can I get the latest entry for each UID? Example Table: ID UID Message 1  1     Some Text 2  2     More Text 3  1     Message...

    Steveo2255 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following