A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

RelationShips Queries and joins



 
 
Thread Tools Display Modes
  #11  
Old May 12th, 2010, 06:46 PM posted to microsoft.public.access.queries
John W. Vinson
external usenet poster
 
Posts: 18,261
Default RelationShips Queries and joins

On Wed, 12 May 2010 03:55:01 -0700, Merge
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/acc...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]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:21 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.