Search results

  1. P

    Many-to-many tables

    Thank you for responding. I've got it figured out.
  2. P

    Many-to-many tables

    Hi - I am trying to create a database that stores inventory information for PC's and software. I have a table called Equipment which stores all my HW information. I have another table called Software to store all my S/W information. Since the relationship between the two tables are...
  3. P

    Sort records on numeric values stored in a text field

    Thank you for the info but can you give me the details of what I need to do step by step. Thanks.
  4. P

    Sort records on numeric values stored in a text field

    Hi - I would like to be able to sort a field that is currently defined as text so that the user is able to enter "player numbers". There are people who have number that are 00, 1, 30, 0, 4, 22 etc... But when I tried to sort this field in a report, the order is not correct numbericallly. Any...
  5. P

    Import an excel file

    Is there a way I can email you the files I am talking about so that you can look at it? In the error table, it said field f19 is my problem. So I then go the the excel file and delete everthing in columm 19 and still I am getting the error table. Thanks.
  6. P

    Import an excel file

    Thank you for the quick reply. I have checked and was not able to see anything wrong. I know the data field I defined in access is "text". So I tried to change the whole columm as text and it still does not work. Is there a better way of defining a field in excel so that it will see it as...
  7. P

    Import an excel file

    I have an excel file worksheet(player info sheet)that the user would input information. I then copy that info into another worksheet(player info) in the data fields that I have defined in Access. I then open up my Access database and do a file-get external data-import. I then select my excel...
Back
Top Bottom