Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Starting Month

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
Go to Top of Page

saidev
Posting Yak Master

101 Posts

Posted - 2006-09-25 : 19:11:27
t
Go to Top of Page

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
Go to Top of Page

saidev
Posting Yak Master

101 Posts

Posted - 2006-09-25 : 21:19:13
t
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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 reply
It seems you edited your other replies also


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-09-27 : 20:41:32
quote:
Originally posted by saidev

t



What is t?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

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.

Go to Top of Page
   

- Advertisement -