Goodday All
I am having a bit of a problem with one of my tables. I am using VBA code to add data to one of my tables, my problem is that even when I manually sort the table, it still gives me problem.
For example, I have a table that stores mobile numbers by year and month. I manually sort it by year- Ascending, but it still gives me this jumbled up table. I even tried writing a query to pull out the data and set the Sort by ascending and yet still it gives me this. What am I doing wrong?
Thanx for all the help
Kind Regards
I am having a bit of a problem with one of my tables. I am using VBA code to add data to one of my tables, my problem is that even when I manually sort the table, it still gives me problem.
For example, I have a table that stores mobile numbers by year and month. I manually sort it by year- Ascending, but it still gives me this jumbled up table. I even tried writing a query to pull out the data and set the Sort by ascending and yet still it gives me this. What am I doing wrong?
Code:
MobileNo Year Month Rental Fees
+2724121428 2004 Dec 0.00 89.60
+2724587374 2004 Dec 0.00 607.89
+2725680161 2004 Dec 0.00 607.89
+2724599866 2005 Feb 0.00 246.00
+2724679023 2005 Feb 0.00 246.49
+2724927556 2005 Feb 0.00 335.96
+2727811585 2005 Jan 0.00 782.04
+2724944253 2005 Jan 0.00 357.40
+2727810066 2005 Jan 0.00 137.70
Thanx for all the help
Kind Regards