Two things you need to do
Create an input mask for your textbox
Set the autotab property of the textbox to Yes/True
This means that as soon as the 9th character is pressed in the input string the cursor will go to the next field in the form.
Relationships a generally created and maintained in the back end. When you link the tables and create queries the relationships are represented in the front end even though they are not visible in the relationships window.
Design your original crosstab query then bring down the date field you want to extract the year from.
Place this in the first column and code as follows
Make this a row item
Group by this field as well
If this is only going to be a one off exercise then a bit of hard work is required. However if this is going to be an ongoing event then that multiplies the work ten fold.
Which option are you looking for?
Dim stMessage as String
Dim stSubject as String
Dim stTo As String
stTo = "SELECT DISTINCT tblCoordinator.CoordinatorEmailAddress " & _
"FROM tblRSS INNER JOIN (tblRSSRenewal INNER JOIN tblCoordinator ON tblRSSRenewal.CoordinatorID = tblCoordinator.CoordinatorID) ON tblRSS.RSSID =...
You can create a single report that is grouped by specialty and telling it to start a new page after each specialty.
When you say you have to "separate tables of each speciality to the customer."
How are you presenting the data to them?