Jim-
Then you need a table with three columns:
StepID AutoNumber
HiringProcessShortName
HiringProcessDescription
Be sure to load the rows in ascending order from earliest step to last step so that the AutoNumber reflects the correct sequence.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Nov 19, 2014, at 2:25 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
At this time the table has not been built. I have the data in a spreadsheet and was not sure how to design the table(s). They have mentioned that the long description will probably be used on reports frequently as well as the short description. Currently there are 6 columns in the spreadsheet. 4 columns are not being used. The first column has a header of Steps on Hiring Process Checklist. The second column has a header of Short Name for Forms. There are 49 rows in the sheet. each of the fields will be dates. Several of the rows consist of
ATH Form to Hiring Official ATH to HO
Approved ATH received from Hiring Official Rec'd ATH from HO
Draft job posting to Manager for Approval Draft posting to Mgr
Jim Wagner
On Wednesday, November 19, 2014 1:22 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jim-
If this is variable data to display, it doesn't seem to make much sense to put "data" in a field name. Are there multiple rows in this table? What's in the actual field as data?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Nov 19, 2014, at 12:33 AM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hello all,
I have just received a strange request from our users. It never ceases to amaze me.
The users request that they have a table that has two columns currently. The first column has a long description of a step below is an example
Final applicant list/screening sheet approved by Manager/ready to interview
The second column has the short description. Below is the equal to the long description above.
AL/SS final
So I thought that I would put the short description in the Caption of the field. Then I would put the long description as field name or vice versa. But the problem is that they have a report that they want as a check list the long description as the label and a form they want the short description to show.
So my question is how do I see both?
Jim Wagner
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar