By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,508 Members | 1,823 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,508 IT Pros & Developers. It's quick & easy.

Creating Custom Report in Access

P: n/a
Hi Everyone,

I need some help!! I'm not sure if you could do this, but I want to be
able to create a report based on one field in the database. This field
contains File Paths like for example:

default.htm
/en/example/aboutus.htm
/fr/example/bonjour.htm
/en/google/help/aboutus/findus.htm

I want to be able to sort in alphabetical order, and display a report
on the root level of the file paths.

So just to show you and example:

CUSTOM REPORT

------------------------------------------------------------------
ROOT

default.htm

------------------------------------------------------------------
EN

/en/example/aboutus.htm
/en/google/help/aboutus/findus.htm

------------------------------------------------------------------

FR

/fr/example/bonjour.htm

------------------------------------------------------------------

And so on and so forth.
I want to be able to seperate them by their root level folder. The
files that have no paths just the filename means it's on the root of
the drive. So, Can I have another header called ROOT which displays all
the files that are actually on the root itself? Then from there, I can
start picking out the root level folder names and displaying them in
seperate rows.

Could anybody give any suggestions on how to go about doing this?

Justin

Oct 31 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Ralph
Develop the report you want and then add a Grouping/Sorting level
which you assign as "=Mid([path],2,IIf(InStr([path],"/")>0,2,0))"

Add a Group Header
and put a control in that group header with the value
of "=Mid([path],2,IIf(InStr([path],"/")>0,2,0))."

Kevin C

"Ralph" <ju*********@gmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Hi Everyone,

I need some help!! I'm not sure if you could do this, but I want to be
able to create a report based on one field in the database. This field
contains File Paths like for example:

default.htm
/en/example/aboutus.htm
/fr/example/bonjour.htm
/en/google/help/aboutus/findus.htm

I want to be able to sort in alphabetical order, and display a report
on the root level of the file paths.

So just to show you and example:

CUSTOM REPORT

------------------------------------------------------------------
ROOT

default.htm

------------------------------------------------------------------
EN

/en/example/aboutus.htm
/en/google/help/aboutus/findus.htm

------------------------------------------------------------------

FR

/fr/example/bonjour.htm

------------------------------------------------------------------

And so on and so forth.
I want to be able to seperate them by their root level folder. The
files that have no paths just the filename means it's on the root of
the drive. So, Can I have another header called ROOT which displays all
the files that are actually on the root itself? Then from there, I can
start picking out the root level folder names and displaying them in
seperate rows.

Could anybody give any suggestions on how to go about doing this?

Justin

Oct 31 '06 #2

P: n/a
I'm sorry, I'm not sure what you mean by a grouping/sorting level?

J

Kc-Mass wrote:
Ralph
Develop the report you want and then add a Grouping/Sorting level
which you assign as "=Mid([path],2,IIf(InStr([path],"/")>0,2,0))"

Add a Group Header
and put a control in that group header with the value
of "=Mid([path],2,IIf(InStr([path],"/")>0,2,0))."

Kevin C

"Ralph" <ju*********@gmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Hi Everyone,

I need some help!! I'm not sure if you could do this, but I want to be
able to create a report based on one field in the database. This field
contains File Paths like for example:

default.htm
/en/example/aboutus.htm
/fr/example/bonjour.htm
/en/google/help/aboutus/findus.htm

I want to be able to sort in alphabetical order, and display a report
on the root level of the file paths.

So just to show you and example:

CUSTOM REPORT

------------------------------------------------------------------
ROOT

default.htm

------------------------------------------------------------------
EN

/en/example/aboutus.htm
/en/google/help/aboutus/findus.htm

------------------------------------------------------------------

FR

/fr/example/bonjour.htm

------------------------------------------------------------------

And so on and so forth.
I want to be able to seperate them by their root level folder. The
files that have no paths just the filename means it's on the root of
the drive. So, Can I have another header called ROOT which displays all
the files that are actually on the root itself? Then from there, I can
start picking out the root level folder names and displaying them in
seperate rows.

Could anybody give any suggestions on how to go about doing this?

Justin
Oct 31 '06 #3

P: n/a
I have a table called ZeroHit with a field in it called ID_Path.

When I put the "=Mid([path],2,IIf(InStr([path],"/")>0,2,0))" value into
the control source of my text field in the header, it returns #Name.

J

Oct 31 '06 #4

P: n/a
If you open your report in design view you can right click on
the top band of the report. One of the options is "Sorting and Grouping"
Select that and in the area where you are asked to enter
a Field or Expression, enter the expression below without
the Outermost quotation marks. (Also substitute the real field name
for the phoney "Path" that is in the expression).
In the Group Properties area change groupHeader to "Yes".
Kevin C

"Ralph" <ju*********@gmail.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...
I'm sorry, I'm not sure what you mean by a grouping/sorting level?

J

Kc-Mass wrote:
>Ralph
Develop the report you want and then add a Grouping/Sorting level
which you assign as "=Mid([path],2,IIf(InStr([path],"/")>0,2,0))"

Add a Group Header
and put a control in that group header with the value
of "=Mid([path],2,IIf(InStr([path],"/")>0,2,0))."

Kevin C

"Ralph" <ju*********@gmail.comwrote in message
news:11**********************@b28g2000cwb.googleg roups.com...
Hi Everyone,

I need some help!! I'm not sure if you could do this, but I want to be
able to create a report based on one field in the database. This field
contains File Paths like for example:

default.htm
/en/example/aboutus.htm
/fr/example/bonjour.htm
/en/google/help/aboutus/findus.htm

I want to be able to sort in alphabetical order, and display a report
on the root level of the file paths.

So just to show you and example:

CUSTOM REPORT

------------------------------------------------------------------
ROOT

default.htm

------------------------------------------------------------------
EN

/en/example/aboutus.htm
/en/google/help/aboutus/findus.htm

------------------------------------------------------------------

FR

/fr/example/bonjour.htm

------------------------------------------------------------------

And so on and so forth.
I want to be able to seperate them by their root level folder. The
files that have no paths just the filename means it's on the root of
the drive. So, Can I have another header called ROOT which displays all
the files that are actually on the root itself? Then from there, I can
start picking out the root level folder names and displaying them in
seperate rows.

Could anybody give any suggestions on how to go about doing this?

Justin

Oct 31 '06 #5

P: n/a
I just sent you an email with some screenshots of what I have done so
far. It doesn't seem to be working. It gives me a back screen?

J

Nov 1 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.