Re: Date Question
Tech-Archive recommends: Fix windows errors by optimizing your registry
On Wed, 20 Apr 2005 07:29:02 -0700, TJ wrote:
> I will have a query that will give me the most recent date that each of my
> contacts has been contacted.
>
> I would like to print a report that will list each contact, and this date in
> the format (month, year) IE April 2003.
>
> What procedure do I need to set up the report to do this. Here is an
> example of the table.
>
> John Doe March 1997
> April May September 2004
> Gus Line July 2002
> etc. etc.
>
> Most specifically I am interested in the date format.
>
> Thanks.
In the report, set the Format property of the control that is
displaying the date field to:
mmmm yyyy
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Relevant Pages
- Re: step through table and select data for reporting values
... I set the dates to "mmdd" vs the output the query is currenly giving me ... I've tried to include the format in the expression itself but this ... I have a report with an unlimited amount or rows. ... > 3) Add the Primary key field and the "Jobs" table foreign key to the grid. ...
(microsoft.public.access.modulesdaovba) - Re: Four Report Problems
... I changed to the query like I thought I had, ... I just typed the names of the banks in the Lookup tab. ... Field List into the Report. ... Don't use an expression to format a value. ...
(microsoft.public.access.reports) - Re: OutputTo to Excel question
... replace qryExport with the name of your table or query ... If Macro is going to keep on giving the format error problem, ... However, once I trigger the Macro to OutputTo the Query into Excel, it ... Save a query that pulls the same data as the report. ...
(microsoft.public.access.macros) - Re: OutputTo to Excel question
... Excel file and opening up ... clicks Ok and your query is exported) ... If Macro is going to keep on giving the format error problem, ... Save a query that pulls the same data as the report. ...
(microsoft.public.access.macros) - Re: Calculate a date based on period and year
... "Trevor Shuttleworth" wrote: ... when the report is pulled in the first quarter of any given year, ... How can I change the formula to show the period and year (format - ... Acct # Curr Period Prev Qtr End Prev Period Curr Period ...
(microsoft.public.excel.worksheet.functions) |
|
