If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MAJOR Trouble with Design of Database
Hello,
I am having quite a day with Access. My problem is as follows... I have used combo boxes throughout my MAIN table. In each look up table there are three columns (one has a number, text, then number). I have (or at least I thought I had) identified for the first column number to be the bound or stored column. The problem I am having is that when I go to export the data into excel all of the numbers are either starting at 0 where previously started at one OR exporting as text. Also, in some cases even the number being stored in the MAIN table is one off. For example, if someone selects county Camden which = 4 then 3 is stored in the table. PLEASE, PLEASE, HELP! |
#2
|
|||
|
|||
MAJOR Trouble with Design of Database
If you are talking about a lookup field at table level, you just ran into one
of many reasons to not use them. Below is a great list of reasons to dump them. http://www.mvps.org/access/lookupfields.htm Further check out the second commandment he http://www.mvps.org/access/tencommandments.htm Your best bet is to create relationships between your table in the Relationships window (hopefully with Referential Integrity enabled) and create lookups or subforms on your forms. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Sharon W" wrote: Hello, I am having quite a day with Access. My problem is as follows... I have used combo boxes throughout my MAIN table. In each look up table there are three columns (one has a number, text, then number). I have (or at least I thought I had) identified for the first column number to be the bound or stored column. The problem I am having is that when I go to export the data into excel all of the numbers are either starting at 0 where previously started at one OR exporting as text. Also, in some cases even the number being stored in the MAIN table is one off. For example, if someone selects county Camden which = 4 then 3 is stored in the table. PLEASE, PLEASE, HELP! |
Thread Tools | |
Display Modes | |
|
|