info needed in multiple lines

[CMcGrann]

I have a table that has information in a line that I need to see in the lines
below it, the problem is that there is multiple "headers" that I need to move
to the rows below it. Example:

Heartland Store #1234
Flowers
Candles
Candy
Samantha's #4234
Flowers
Candles
Candy
Tylor's Store #8558
Flowers
Candles
Candy

I want the correct store number to appear on the lines directly below it.
Realizing that the store number needs to change when it reaches a different
store name in the table.

Hope I am making sense, sort of new at this!!! Can this be done????

 

[Stefan Hoffmann]

hi,

I have a table that has information in a line that I need to see in the lines
below it, the problem is that there is multiple "headers" that I need to move
to the rows below it. Example:

Heartland Store #1234
Flowers
Candles
Candy
Samantha's #4234
Flowers
Candles
Candy

Hope I am making sense, sort of new at this!!! Can this be done????

Create a new report based on your data, goto Grouping and Sorting in the
menu/toolbar. Create a group based on your store and set group header to
yes. Place the fields from the store into the header, and the other
fields into the detail section.


mfG
--> stefan <--

 

[Al Campagna]

CMcGrann,
If I understand correctly....
You appear to have a grouping on the StoreName.
Use that StoreName Group Footer to repeat the Store Number.

If you've stored the StoreNo along with the StoreName in your table
(ex. "Samantha's #4234") then you should break the number out from the
StoreName (ex. [StoreName] = "Samantha's" and [StoreNo] = 4234)
That would be the ideal solution.
But...
You can still programmatically break out the StoreNo from the StoreNAme.
If ALL your store numbers consist of a # and 4 digits... try this in the
Store Footer.
=Mid(StoreName, InStr(StoreName,"#"))

Heartland Store #1234 'Header
Flowers
Candles
Candy

#1234 'Footer

Samantha's #4234 'Header
Flowers
Candles
Candy

#4234 'Footer
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[CMcGrann]

Yes, the store number is broken out in a seperate field from the store name.
I need this in a table/query not a report. What I need to see is:
Heartland Store #1234
Stock Store #
Flowers 1234
Candles 1234
Candy 1234
Samantha's #4234
Flowers 4234
Candles 4234
Candy 4234

If it makes it easier, I just want to fill in the blank lines with the
number above it using a query.
I see: I want to see:
1234 1234
1234
1234
4234 4234
4234
4234

Thanks again!!!

CMcGrann,
If I understand correctly....
You appear to have a grouping on the StoreName.
Use that StoreName Group Footer to repeat the Store Number.

If you've stored the StoreNo along with the StoreName in your table
(ex. "Samantha's #4234") then you should break the number out from the
StoreName (ex. [StoreName] = "Samantha's" and [StoreNo] = 4234)
That would be the ideal solution.
But...
You can still programmatically break out the StoreNo from the StoreNAme.
If ALL your store numbers consist of a # and 4 digits... try this in the
Store Footer.
=Mid(StoreName, InStr(StoreName,"#"))

Heartland Store #1234 'Header
Flowers
Candles
Candy

#1234 'Footer

Samantha's #4234 'Header
Flowers
Candles
Candy

#4234 'Footer
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

I have a table that has information in a line that I need to see in the
lines
below it, the problem is that there is multiple "headers" that I need to
move
to the rows below it. Example:

Heartland Store #1234
Flowers
Candles
Candy
Samantha's #4234
Flowers
Candles
Candy
Tylor's Store #8558
Flowers
Candles
Candy

I want the correct store number to appear on the lines directly below it.
Realizing that the store number needs to change when it reaches a
different
store name in the table.

Hope I am making sense, sort of new at this!!! Can this be done????