I have an Access project created on my desktop at home. I can connect to my remote SQL database using Access 2000. When I try to set up an Access project on my laptop (both using Windows XP Pro, desktop has DSL, laptop shares that connection via network) I cannot connect to the remote database...
Thanks to both of you. I don't have the weeknum formula, and I ended up creating a new column in my database for week so I'm using that but your formula will be great for the next time.
John Fitzgerald
I have a list of dates that I want to summarize by week in a pivot table. Is there any way to calculate the week based on a date?
Thanks,
John Fitzgerald
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.