Search results
-
T
linking table to itself?
:confused: Hi, How can I handle data in access that relates to itself: example: I have a device. The device has drawings and parts as follow: main drawings: draw1 (device1) draw2 (device2) draw3 (box1) draw4 (box2) sub drawings and parts: under draw1: draw5 (PCB) draw6 (electric outlet)... -
T
many-to-many - revisited - crazy
Hi Everyone, I'm trying to figure out a sane way to build a database that seems more and more complex as I'm looking at it. I understand the basic principle of many to many relationship with the little middle table trick. But the way I need it isn't that simple So here it is: There are... -
T
Excel cells to Access tables - help
Hi, I'm trying to import specific cells from MS Excel 2000 spreadsheets to MS Access 2000 tables then move the spreadsheets to a different directory. I'm very new to this and I'm having trouble to implement this. I have worked out so far the code to import certain cells into 1 table, but I do...- thadson
- Thread
- Replies: 2
- Forum: Modules & VBA
-
T
query to break data apart
Hi. I have a table that has 1 field called IP it containes IP addresses as data like this. IP 255.254.253.252 255.251.250.0 Is it possible to have a query that would break this up so it becomes a new table with 4 fields like this: IP1 IP2 IP3 IP4 255 254 253 252 255... -
T
How to get get data from one table to another?
Hi, I have 2 tables "customers" and "cancel" the cancel table comes from a third party. Customers table has CustID CustName SignupDate CancelDate CancelReason CancelTable has CustID CancelDate CancelReason RoomCode Promocode As the Customers table is the original Table it contains no cancel... -
T
Automate true/false field
I have struggled with this for a while now and I finaly realized that I need some pointers, so please help. I have a table called "membership" that contains the following fields: custID, activationdate, active, canceldate The "active" field is a true/false field. "canceldate" is always a newer... -
T
querry nightmare
Hi, I'm having a very hard time to figure this ridle out and maybe there is no solution, or I'm just going in the wrong direction, however here it is: I have to calculate the number of deals that come in every day, for that week, month, and year. Than some deals are rejected and I have to do...