| View previous topic :: View next topic |
| Author |
Message |
KaleKYlssen
Newbie
Joined: 31 Jan 2004
Posts: 19
|
 Posted: Mar 4th, 2004 02:12 PM Post subject: creating a report |
 |
|
| I have vb program that is linked to an access db, in my vb program i have a textbox which holds the date of the start of the week. What i want to do is create a report that i can print from vb that will show all records where the compund key is the same as the date in the textbox. I know how to print the report i just need to know how to create the report that will display what i want |
|
| Back to top |
|
Avis
Junior Poster
Joined: 07 Oct 2003
Posts: 510
Location: India
|
|
| Back to top |
|
Avis
Junior Poster
Joined: 07 Oct 2003
Posts: 510
Location: India
|
|
| Back to top |
|
KaleKYlssen
Newbie
Joined: 31 Jan 2004
Posts: 19
|
| Posted: Mar 9th, 2004 08:31 AM Post subject: |
|
|
i'm having problems figuring out a SQL statement that checks a field against the date of the start of the week. To display the date in my program i used
| Code: |
MondayDate = DateAdd("d", -Weekday(Date) + 2, Date)
txtWeek.Text = MondayDate
|
I tried this in access but it doesn't work is there an equivalent for this code that can be used in access |
|
| Back to top |
|
|
