T
TechyGal
Hi there,
I am hoping that someone may be able to assit me in sourcing a
solution to the following problems:
I have a table, in a database (the database is in SQL but I am using
Access as the front end), which contains a field called 'Room_ID' of
type 'nvarchar' set to a max of 20.
This 'Room_ID' is the primary key for the 'Room_Schecdule' table and
needs to consist of two different elements:
1). A Project ID - Required by us - e.g. 1, 2, 3, 4 etc...
2). A Room code - Specified by the client - e.g. AD01, AD02, AD03
etc...
The Room_ID currently looks like this: 1~AD01
1~ Signifies the Project id;
AD01 Siginfies the Room code;
I have set it like this in the hope that I can sort the records
firstly in order of projects and secondly in order of Room codes.
This brings me to my first question:
Is this the best way to achieve this and how do I sort in two levels?
The second issue I have is that I need to be able to generate a
report, which will be presented to the client.
On this report I need to display the Room_ID but I only want to show
the Room code element of this field!
Is it possible to 'Not show' the first two or three characters of a
record within this field?
If so, how can I achieve this?
I would really appreciate a 'dummys guide' as I am still just a baby
in the field of database development!
Many Thanks in anticipation!
TechyGal
I am hoping that someone may be able to assit me in sourcing a
solution to the following problems:
I have a table, in a database (the database is in SQL but I am using
Access as the front end), which contains a field called 'Room_ID' of
type 'nvarchar' set to a max of 20.
This 'Room_ID' is the primary key for the 'Room_Schecdule' table and
needs to consist of two different elements:
1). A Project ID - Required by us - e.g. 1, 2, 3, 4 etc...
2). A Room code - Specified by the client - e.g. AD01, AD02, AD03
etc...
The Room_ID currently looks like this: 1~AD01
1~ Signifies the Project id;
AD01 Siginfies the Room code;
I have set it like this in the hope that I can sort the records
firstly in order of projects and secondly in order of Room codes.
This brings me to my first question:
Is this the best way to achieve this and how do I sort in two levels?
The second issue I have is that I need to be able to generate a
report, which will be presented to the client.
On this report I need to display the Room_ID but I only want to show
the Room code element of this field!
Is it possible to 'Not show' the first two or three characters of a
record within this field?
If so, how can I achieve this?
I would really appreciate a 'dummys guide' as I am still just a baby
in the field of database development!
Many Thanks in anticipation!
TechyGal