<div>
?Format(now(), &quot;ww&quot;)<br />
33<br />
<br />
As apparently we're in the 33rd week of the year. <br />
<br />
BUT ... this is calendar week, so if you have a different definition of week number, you'll need to spell that out.
</div>


?Format(now(), "ww")
33

As apparently we're in the 33rd week of the year.

BUT ... this is calendar week, so if you have a different definition of week number, you'll need to spell that out.

<div>
I got that to work in the query but it is formatting as a date: &nbsp;<br />
<br />
33/_/_ &nbsp; &nbsp;How do i get it to format as a number. &nbsp;the column format option has nothing in there so i can't select &quot;number&quot;.
</div>


I got that to work in the query but it is formatting as a date:  

33/_/_    How do i get it to format as a number.  the column format option has nothing in there so i can't select "number".

<div>
If you're trying to convert the 33 week...<br />
<br />
CInt(anything) converts to a small integer, which is +/- 32,000-ish. <br />
CByte(anything) converts to a byte, which is 0 to 255.
</div>


If you're trying to convert the 33 week...

CInt(anything) converts to a small integer, which is +/- 32,000-ish.
CByte(anything) converts to a byte, which is 0 to 255.

<div>
Thanks for the greade. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


Thanks for the greade.  Good luck with your project.  -Jim

<div>
<div class="content wysiwyg-content">
I would like to format a week in an access query to show the week #. &nbsp;Does anyone know the proper format?
</div>
</div>


I would like to format a week in an access query to show the week #.  Does anyone know the proper format?

Formatting da6e as week # in access query

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.