I have converted data from DOS FoxPro to Access 2002
We have a field in the DOS that I also use in the Access 2002. The field is a sort field, but it looks like the information is not sort as it did in DOS.
What it was: the dash is the one in question.
Now it is: the dash with a name after is not sorting the same as it did in DOS above
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple. The final solution for this task involved creating a custom text parser and then reading…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…