how to create easy tables in ms access reports

[kasim]

hello access fans.
i am still using access 2000 on windows 2000 machine.
firstly, how are you. everybody asks his-her question and go back.
this should be changed
my problem is placing the objects in ms access reports in excel-like
cells.
i collect various information from various tables as it requires. but
what i want is placing the objects in table cells. Of course this can
be done through the borders of the controls, but i want a better and
more convenient solution, as i cant create convenient tables with the
previous solution (shaping the borders of controls)
the second problem i encounter is giving numbers to the returned
records in a report. the sorted records in the report should be
numbered from 1 to n, n being the number of records. the problem is
that much simple.
the third problem is with date formats. I am merging some texts with a
given date. but changing the format of the original date field does
not affect the result of merging. I am changing the format of original
date field as 23 October 2007, but the merged cells, created by a
query, shows "the order date is 23.10.2007" how can I make it "the
order date is 23 October 2007" or, better "the order date is 23
OCTOBER 2007", a date format not listed in the format list of date
fields.
thank you for your kind responses.
if i am wrong to assume that this group is convenient for newcomers'
questions, excuse me for bothering you.
take care of yourselves.

 

[fredg]

hello access fans.
i am still using access 2000 on windows 2000 machine.
firstly, how are you. everybody asks his-her question and go back.
this should be changed
my problem is placing the objects in ms access reports in excel-like
cells.
i collect various information from various tables as it requires. but
what i want is placing the objects in table cells. Of course this can
be done through the borders of the controls, but i want a better and
more convenient solution, as i cant create convenient tables with the
previous solution (shaping the borders of controls)

I'm not sure of what you are attempting to do here.
Perhaps you should look at the Line method in VBA help and use it to
place lines on the report in the Report's Page event.

the second problem i encounter is giving numbers to the returned
records in a report. the sorted records in the report should be
numbered from 1 to n, n being the number of records. the problem is
that much simple.

Add an unbound text control to the report.
Set it's control source to:
=1
Set it's Running Sum property to
Over All

the third problem is with date formats. I am merging some texts with a
given date. but changing the format of the original date field does
not affect the result of merging. I am changing the format of original
date field as 23 October 2007, but the merged cells, created by a
query, shows "the order date is 23.10.2007" how can I make it "the
order date is 23 October 2007" or, better "the order date is 23
OCTOBER 2007", a date format not listed in the format list of date
fields.

="the order date is " & UCase(Format([DateField],"dd mmmm yyyy")