Author |
Topic |
saidev
Posting Yak Master
101 Posts |
Posted - 2006-09-25 : 13:56:23
|
Solved |
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-09-25 : 19:01:38
|
The code you are showing has nothing to do with creating a sql statement, generating a report, or grouping or sorting or formatting on a report. It is simply setting start date and end date variables with some values. (strEndDateVar and strStartDateVar! Great names! Hungarian prefixes AND suffixes!)- Jeff |
|
|
saidev
Posting Yak Master
101 Posts |
Posted - 2006-09-25 : 19:11:27
|
t |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-09-25 : 20:08:19
|
Again, why is the sql being constructed like this? Why is it all being concatenated together in a big, long ugly and hard to read set of VB statements? You should create a regular query using MS Access, add parameters if needed, test it, save it, and then base the report on the query. This way you can troubleshoot and/or edit the query iself visually and be sure that it all works, test out the joins and criteria and grouping and you have MS Access's query designer to help you,and you can do it all without code and separate from the report. Then, Once the query is returning the data that you need, then you can focus on formatting the report just the way you need it. Doing this like the way they are being done now just makes a big huge mess of code that is hard to read and manage. I'm sure that you've discovered this by now. Is this code that you've written or inherited? Have you read any introductionary books on MS Access and/or SQL Server?Time to educate yourself, read up on the fundamentals of the technoliges you are working with, and to use and implement best practices to start cleaning up some of these messes.- Jeff |
|
|
saidev
Posting Yak Master
101 Posts |
Posted - 2006-09-25 : 21:19:13
|
t |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-09-27 : 12:54:58
|
Why are you deleting your posts? Others can learn from these threads, that's the whole point of these forums; it's not as a place people can come and get free, private individual advice ... if that were the case we'd be emailing each other back and forth .... It's considered pretty rude to go back and delete everything that you wrote.- Jeff |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-09-27 : 13:19:25
|
google didn't cache the pages either..should we have a blacklist?-ec |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-09-27 : 20:40:13
|
quote: Originally posted by saidev Solved
Why did you edit the question?If you solved the problem, you should have posted as new replyIt seems you edited your other replies alsoMadhivananFailing to plan is Planning to fail |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-09-27 : 20:41:32
|
quote: Originally posted by saidev t
What is t?MadhivananFailing to plan is Planning to fail |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-27 : 22:55:41
|
I think some people are now scared of being included on the twit list. |
|
|
|