Prev: Join on a calculated field
Next: Crosstab column data count
From: John W. Vinson on 12 May 2010 13:46
On Wed, 12 May 2010 03:55:01 -0700, Merge <Merge(a)discussions.microsoft.com>
wrote:

>My problem is the data format is different on both reports
>Doing this concatenate The pay code on one reports references the pay code
>and on the other report you have to figure out the code by what type of hours
>they have worked. then for the nameJohnson Dominick is on one and Johnson
>Dominick Jr is on another this is why I take the first 10 digits
>
>I want to keep it simple I may just export the query to excel and import it
>back as a table. I do not have much support from my IT group so I am tackling
>this on my own (Novice user)
>
>I am just using this to match Data to create coding for payments received.

You're unfortunately making it more complicated, not simpler!

Don't confuse data STORAGE with data DISPLAY. You should not - cannot! - let
the desired format of a report drive your table or database structure. YOu
should have a table of People, with a unique PersonID, so that Dominick
Johnson is in a table with a structure like:

PersonID 312
FirstName "Dominick"
LastName "Johnson"
Suffix "Jr."
Nickname "Dom"


which can be displayed on a report any way you like.

This structure would also allow you to accommodate the case that you might be
dealing with Dom Sr. and Dom Jr., different people doing different things.

You might want to look at some of these resources:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

Crystal's and Allen's tutorials in particular might give you a good
foundation.
--

John W. Vinson [MVP]
First  |  Prev  | 
Pages: 1 2 3
Prev: Join on a calculated field
Next: Crosstab column data count