Help...
I have a table as shown below
Week | Start | End |
1 |1/4/2004 |7/4/2004 |
2 |8/4/2004 |14/4/2004 |
3 |15/4/2004|21/4/2004|
4 |22/4/2004|28/4/2004|
etc......
I need a Query / Function that would return the number for any given date i.e...
I am trying to format a field in a table which is created from a query. The field needs to be formatted as currency as an update query is used to enter monetary amounts from another table. At present when I run the update query the amounts change to whole numbers and not currency amounts.
If I...
