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 » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"groups" in table and text field size



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old November 21st, 2004, 09:47 AM
Mimi
external usenet poster
 
Posts: n/a
Default "groups" in table and text field size

I created several tables differentiated by YEAR. They're pretty much the
exact same fields (survey questions), just different years (there's no
relationship). Within these YEARS, there are questions for different DAYS.

So with each ID, I added fields for all the questions for all 5 days. Now it
turns out that the ID's are grouped by DAY, not YEAR...meaning that a person
who answered the survey on DAY 4 did not also answer the survey on DAY
1,2,3,or5 (since the surveys were given different days and are anonymous).

So is it wrong to keep it the way it is on my YEAR table? The way I
separated it on my form is by creating a form for every year and using tabs
to separate the days. SO this means I would have to keep all the days on the
same table, right?

Any suggestions would be great on how to 'group' the days (on the table).
Thanks.

PS. I'm also having issues with the text field size. I originally used the
default 50 to created a whole bunch of text fields. But now, I need them to
be about 150 characters. I changed my default on my options, but this did not
go back and change my existing fields...kept them at 50. Is there any way to
change them all w/out changing the size one by one?
 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicate data Rob Green Database Design 3 November 7th, 2004 03:08 AM
Here's a shocker Mike Labosh General Discussion 2 October 26th, 2004 05:04 PM
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. HDW Database Design 3 October 16th, 2004 03:42 AM
Must # of fields in the 2 tables in an Append Query be equal? CreativeImages Running & Setting Up Queries 3 October 1st, 2004 05:16 PM
Text (not headings) that needs to appear in TOC Linda Formatting Long Documents 2 June 4th, 2004 08:03 PM


All times are GMT +1. The time now is 09:38 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.