How to set a Default Value?

[deejabram]

The theory is simple, but the issue has been racking my brain for days.

I have a table named STANDARDS with multiple fields. To include but not limited to:
"WrkArea"
"Picks"

I have a table named ATTENDANCE with multiple fields. To include but not limited to:
"AttenDate"
"PickStan"

I want the default value of the field "PickStan" in ATTENDANCE to be whatever Value us stored in the field "Picks" in STANDARDS.

How do I do this? Any suggestions?

 

[vbaInet]

Copy the Default Value property from the field, create an UPDATE query and update the relevant field in the Standards table.

 

[deejabram]

I'm sorry. I don't quite understand. Where is the "Default Value property" located at? How do you create an "UPDATE" query?

 

[deejabram]

The entire field has multiple default values as each Work area has a different "pick standard"

 

[vbaInet]

A field cannot have multiple default values so you must be using the wrong terminology. Elaborate on your thoughts.

 

[deejabram]

Attached is an sample extracted from my database and converted to Excel. This table shows my fields in columns with the cooresponding value. Maybe that is my problem? I am trying to set this table up as a spreadsheet, which reads across rows as well as columns?

 

[vbaInet]

I still don't understand what you're trying to do. Data is fetched in a row-wise manner. If you want to handle things the Excel way then you will need to do it in Excel.

What do you mean by Default Value? Do you mean you want to update the PickStan field in Attendance to the values stored in the Picks field in Standards?

 

[deejabram]

That is exactally what I am trying to do. (=

 

[vbaInet]

Have you looked at the UPDATE query?

By the way, why are you needing to duplicate data?

 

[deejabram]

I dont know where to look at the "Update Query".

I am sure that this database isnt completely normalised. I am still somewhat of a "rookie". From my research I have determined that my database is best qualified at best as 2NF...perhaps 3NF...meaning that situationally, with the complexities in my environment, and my still expanding knowledge of database priciples have deemed it necessary to do such.

So now, the only thing I am trying to determine is simply how to update the PickStan field in Attendance to the values stored in the Picks field in Standards?. I think once I get this database done and working, I will see so many ways to improve upon it. This is just the prototype

 

[vbaInet]

I dont know where to look at the "Update Query".

You know that Google is your friend

http://lmgtfy.com/?q=update+query+ms+access

 

[deejabram]

Yes indeed it is. Will look into it some more and post here if/when I achieve the desired results.

 

[deejabram]

By the way, I got a real kick out of the link you posted. Myself and the co-workers cant stop laughing.

 

[vbaInet]

Let us know how it goes.

By the way, I got a real kick out of the link you posted. Myself and the co-workers cant stop laughing.

It's a good laugh.

 

[deejabram]

In my defense though, I used google to get this far....

Let us know how it goes.

It's a good laugh.

At a glance, I cant even believe I didnt know how to use this type of query. This seems to be the exact answer I was looking for. I cant be 100% sure until I have played with it for about....oh say 6 years.......but in the meantime I will say that you hit the nail on the head. Thanks!

 

[vbaInet]

This seems to be the exact answer I was looking for. I cant be 100% sure until I have played with it for about....oh say 6 years.......

By which time you would have become an expert

 

[deejabram]

I will never claim to be an expert on anything. By the time I master something, another product comes along to replace the previous version.

Looking at this update query is awesome. I like this tool and it will absolutely be useful, but I dont believe this is going to accomplish what I am trying to do. This is good for updating everywhere, but what if I just want the default value in one area of the database to be the exact same value as another?

Not sure the proper terminology to use, but I will use something I am familiar with......."cells" I have one "cell" in one table and I want it's default value to be whatever the current value is in another table's "cell". Make sense? Will update query allow me to do that?

 

[vbaInet]

but what if I just want the default value in one area of the database to be the exact same value as another?

Could we please refrain from the word Default Value. It's not being used in the right context and confuses me whenever I read it Just call it value.

Not sure the proper terminology to use, but I will use something I am familiar with......."cells" I have one "cell" in one table and I want it's default value to be whatever the current value is in another table's "cell". Make sense? Will update query allow me to do that?

Filter it down to that particular value using the Criteria.