• 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:
  • 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:
  • 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       ...

    Ahejazi5 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:
  • How do I copy an Access 2003 database and table?

    I'm using Microsoft Access 2003. How do I copy a database and table? They were set up by someone that's no longer with the company.

    Secretary15 pointsBadges:
  • Creating Access table

    How do I create an ERDiagram from this table of information? Table=CUSTOMER- Customer_ID LastName FirstName Address PhoneNumber ContactNumber Email Address and add the following tables with this information: Table names: COSIGNEE -DRIVERS- PICKUPMANIFEST-DELIVERY_TRUCK_DETAILS-DELIVERY_MANIFEST

    CyberFly5 pointsBadges:
  • In Access 2007, how do I increase the file lock capacity so I can split an existing table into smaller ones?

    In Access 2007, how do I increase the file lock capacity so I can split an existing table into smaller ones? Thanks

    Kadiddlehopper5 pointsBadges:
  • Subquery in Microsoft Access

    [em]   Trying to create a subquery for a table in Access.   I am trying to pull out of a table all records where Sales amount is greater than 1000 and the discount rate is less than 5%. I have to calcuate the discount percentage in the  table, and don't want to create another table with that...

    Miltonfung5 pointsBadges:
  • Query that uses input data from another form

    OK..I need to query a data form that is set to extract data from one table, but I have other fields on the same form that needs to extract data from another table. I have a query that I intend to use to reference the data I need...but my question is what is the syntax to make this happen. Here is...

    DaChosenOne5 pointsBadges:
  • In Microsoft Access is there a way to put IIF statement criteria into a table for easier management and reference?

    I have some data with a list of Product IDs and I want to assign the Product IDs a category name based the criteria below. <br><br> IIF Product ID = #*C#* then category name = Cable<br><br> IIF Product ID = 00#* or 497* then category name = Component<br><br>...

    As2301495 pointsBadges:
  • Linking Carrier and Products in Access 2003

    I have a carrier table and a product table. The Carrier table i have CarrierID and Carrier Name. In the Product Table I have ProdID,Carrier, and Product name. What I want to accomplish on a form is when I select a carrier in a combo window and then select Product in another window , I want to only...

    Jasmine15 pointsBadges:
  • Report Page Header tied to Field in a Make Table in Access 2000

    In Microsoft Access: How do I write the control in (properties) of an unbounded box created in a report header to display the a month I query (Criteria -Enter: Month) which then converts to a Make Table?  When I run the query and am asked, "Enter: Month" and I type in "May", I want May to...

    Cappythequalityguy15 pointsBadges:
  • Assign Indicators to an Access Table

    I have a table in Microsoft Access that has duplicate customer numbers. I want to auto assign a number to the records,i.e. 1 thru 6. But reset to 1 each instance the customer # changes. Is there any easy way to do this?. Thanks

    Dash145 pointsBadges:
  • Joining 2 tables in MS Access and Searching & Retrieving records using ComboBox in VB and ADODC control

    How can I join 2 tables in MS Access (e.g,tbl1 and tbl2)and Searching & Retrieving records using ComboBox and will display in a textbox after i click Search button in VB? I am using ADODC control as datasource

    Pisceaneffect5 pointsBadges:
  • in Access 2003, adding data in a table affect queries?

    Hi, I am using Access 2003. I am working on a database that already exists. I want to add a name of a location in a field in some existing tables. Basically I want to add a name of a location to a field that is a drop down list of locations. There are queries linked to those tables, would the...

    Sujun5 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following