More Office coding help...

[(Shovel)]

This time for Access.

I'm keep my bank acount record in an access database and I track each transaction - like my own bank statement really.

I want to make a report that will show transactions for this week - starting on monday but I really don't know how.

Each transaction has a "Date" property in Date format and I know I can estalish what day of the week that falls on (from 1 to 7) but I really don't know where to start with coding an algorithm to find the "start date" of this weeks monday. I might also want to look at transactions week by week and be able to look back. Short of having it prompt for "What was the date of monday this week" can someone help me get it working as described?

 

[Scooba Da Bass]

Uhm, it's been literally years since I looked at Access, but I imagine you could do a check based on today's day and work back that way, ie if today = wednesday then -2 from the date and begin looking there etc..

 

[xane]

There is a function called DayOfWeek() I believe.

 

[Chalky's_Wife]

In Access go to help and then look for 'DateGrouping Property' this should take you through various options to set propertys to pick up from monday to sunday. would love to go into more detail but will probably go ott on instructions and get told off by someone!!
Good luck

 

[Penry]

school project ?

 

[~Lazarus~]

Originally posted by Penry
school project ?

ROFL.

Keeping track of pocket money

 

[(Shovel)]

replace pocket money with student overdraft and you're bang on.

Thanks very much for the help, I shall look it up and see what I can do!

Cheers.

 

[wolfeeh]

if it's like VB (which is should be)...

you want to do something like;

dayToday = weekday(date)
which should implicitly declare a variable, and fill it with which day of the week it is (in the form of an integer 1-7 (1 being sunday)).

then use a select case statement, with case dependancy on which day it is, to determine the startdate, e.g.

wednesday == 4, so if dayToday is 4, then startdate = date - 4 days (3 days?)

make sense?

 

[Mellow-]

Every version of Microsoft Access comes with a handy "help" function. This can be used to remedy any problems you may have in the planning, construction, entering of data and report building of your database.

 

[Testin da Cable]

everyone who uses access of their own free will should have their eyes laved in molten burning plastic.



yes, that means me too

 

[Testin da Cable]

btw, I found this:

http://www.experts-exchange.com/Applications/MS_Office/

seems cool

 

[dysfunction]

Anyone know how you can open a Microsoft Works file if you dont have the software???

I would have thought something from MS Office could open the files but it doesnt work!!

 

[~Lazarus~]

tried this :

 

[dysfunction]

Originally posted by ~Lazarus~
tried this :

Nah that didnt work...

Although I could use it to hit the person who sent the file...