Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-14-2018, 11:36 AM   #16
MajP
Newly Registered User
 
Join Date: May 2018
Posts: 479
Thanks: 6
Thanked 115 Times in 113 Posts
MajP will become famous soon enough
Re: How to "flow" table data visually from column to another

So Billy Bob is qualified AW, E, P3. Are you using a multivalue field for that? MV fields work well if you understand them. They do a lot of stuff behind the scenes that make it hard to know what is going on. This may be an example where they work well. If that is not a multivalue field but just a single text field, you will run into problems. Also why does Jim James have two records?

MajP is offline   Reply With Quote
Old 07-14-2018, 11:41 AM   #17
Gasman
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 2,398
Thanks: 291
Thanked 374 Times in 359 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: How to "flow" table data visually from column to another

Surely if one is are using a computer system, then one would only show what is applicable?
__________________
Access novice. Sometimes trying to give something back.
Access 2007
Gasman is offline   Reply With Quote
Old 07-14-2018, 11:50 AM   #18
redridinghood
Newly Registered User
 
Join Date: Jul 2018
Posts: 7
Thanks: 5
Thanked 0 Times in 0 Posts
redridinghood is on a distinguished road
Re: How to "flow" table data visually from column to another

Correct -- those are multivalued fields.





Quote:
Originally Posted by MajP View Post
So Billy Bob is qualified AW, E, P3. Are you using a multivalue field for that? MV fields work well if you understand them. They do a lot of stuff behind the scenes that make it hard to know what is going on. This may be an example where they work well. If that is not a multivalue field but just a single text field, you will run into problems. Also why does Jim James have two records?

redridinghood is offline   Reply With Quote
Old 07-14-2018, 12:29 PM   #19
MajP
Newly Registered User
 
Join Date: May 2018
Posts: 479
Thanks: 6
Thanked 115 Times in 113 Posts
MajP will become famous soon enough
Re: How to "flow" table data visually from column to another

Quote:
Surely if one is are using a computer system, then one would only show what is applicable?
No idea what that means.

MajP is offline   Reply With Quote
Reply

Tags
multi-column

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Turning a 3 column flat file into a "3D" Table Ciaran.Hudson Introduce Yourself 3 12-04-2014 04:20 AM
If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2" shdale Queries 8 10-29-2014 05:20 AM
ALTER TABLE COLUMN with "DEFAULT"??? HorKar Queries 0 01-07-2009 12:18 AM
Queriong a table with a column named "Date" welid Tables 9 11-27-2007 08:49 AM
How to find records, name "like" keywords given in column in another table erxefera Queries 2 02-08-2006 07:06 AM




All times are GMT -8. The time now is 04:52 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World