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

database - what else

P: n/a
Folks,

I'm looking to build a database for my local drama group to sell tickets on
line, now I'm falling at the first hurdle as I need a sort of spreadsheets
view not a table view. So row A would be tickets 1 to 22, B 1 to 22 etc. Any
ideas how I could replicate this as I would want a single recurred in A1, A2
etc.

Help appreciated.
Jul 16 '07 #1
Share this Question
Share on Google+
9 Replies


P: n/a
TblRow
RowID
RowNumber

TblSeat
SeatID
RowID
SeatNumber

TBlEvent
EventID
EventDate
EventDescription

TblEventTicket
EventTicketID
EventID
SeatID
PatronFirstNane
PatronLastName

To get your "spreadsheet" view you need a crosstab query that includes
TblEventTicket, TblEvent, tblRow and TblSeat. To create a crosstab query
opento the database window, go to Queries, select New and select Crosstab
Query. Then follow the instructions. You would set a criteria for the
EventID field to display the tickets sold for a selected event. Rows would
be RowNumber, Column would be seat and Value would be a calculated field in
your query to dispay what you want in each "cell of the spreadsheet".

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com


"Dave Cox" <da*****@tiscalinotospam.co.ukwrote in message
news:VS****************@newsfe4-win.ntli.net...
Folks,

I'm looking to build a database for my local drama group to sell tickets
on line, now I'm falling at the first hurdle as I need a sort of
spreadsheets view not a table view. So row A would be tickets 1 to 22, B 1
to 22 etc. Any ideas how I could replicate this as I would want a single
recurred in A1, A2 etc.

Help appreciated.

Jul 16 '07 #2

P: n/a
Brilliant!!

Many thanks....

"Steve" <so***@private.emailaddresswrote in message
news:my*****************@newsread3.news.pas.earthl ink.net...
TblRow
RowID
RowNumber

TblSeat
SeatID
RowID
SeatNumber

TBlEvent
EventID
EventDate
EventDescription

TblEventTicket
EventTicketID
EventID
SeatID
PatronFirstNane
PatronLastName

To get your "spreadsheet" view you need a crosstab query that includes
TblEventTicket, TblEvent, tblRow and TblSeat. To create a crosstab query
opento the database window, go to Queries, select New and select Crosstab
Query. Then follow the instructions. You would set a criteria for the
EventID field to display the tickets sold for a selected event. Rows would
be RowNumber, Column would be seat and Value would be a calculated field
in your query to dispay what you want in each "cell of the spreadsheet".

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com


"Dave Cox" <da*****@tiscalinotospam.co.ukwrote in message
news:VS****************@newsfe4-win.ntli.net...
>Folks,

I'm looking to build a database for my local drama group to sell tickets
on line, now I'm falling at the first hurdle as I need a sort of
spreadsheets view not a table view. So row A would be tickets 1 to 22, B
1 to 22 etc. Any ideas how I could replicate this as I would want a
single recurred in A1, A2 etc.

Help appreciated.


Jul 16 '07 #3

P: n/a
"Dave Cox" <da*****@tiscalinotospam.co.ukwrote
Brilliant!!
Well, Steve... many words have been used here to describe you, but
"brilliant" isn't often one of them, so that ought to give you a glow of
pride. Congratulations on getting such a response.

Larry
Jul 16 '07 #4

P: n/a
And how about this one ---

His (... i.e. Steve) technical answers in these forums are good.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/


"Larry Linson" <bo*****@localhost.notwrote in message
news:aZPmi.786$I76.658@trnddc05...
"Dave Cox" <da*****@tiscalinotospam.co.ukwrote
Brilliant!!

Well, Steve... many words have been used here to describe you, but
"brilliant" isn't often one of them, so that ought to give you a glow of
pride. Congratulations on getting such a response.

Larry

Jul 16 '07 #5

P: n/a
"Steve" <so***@private.emailaddresswrote
And how about this one ---

His (... i.e. Steve) technical answers in these forums are good.

Tony
To receive such an assessment from Tony should "warm the cockles of your
heart." Of course, it would be provable that it had actually been posted
had it been linked rather than copied.

I'm sure I would disagree with Tony if the implication was that your
technical answers are _always_ correct, because I've seen quite a few of
them corrected in recent times. On the other hand, providing answers rather
than just trolling for business is a step in the right direction!

Larry

Jul 16 '07 #6

P: n/a
Why are you trying to hold me up to a perfect standard? Even frequent
responders like Tony Toews, Allen Browne, Douglas Steele, Marshall Barton
and yes, Larry Linson occasionally error. I guess they are only human but
you want me to be more than that!

Steve

"Larry Linson" <bo*****@localhost.notwrote in message
news:wlTmi.7828$fj5.6660@trnddc08...
"Steve" <so***@private.emailaddresswrote
And how about this one ---

His (... i.e. Steve) technical answers in these forums are good.

Tony

To receive such an assessment from Tony should "warm the cockles of your
heart." Of course, it would be provable that it had actually been posted
had it been linked rather than copied.

I'm sure I would disagree with Tony if the implication was that your
technical answers are _always_ correct, because I've seen quite a few of
them corrected in recent times. On the other hand, providing answers
rather than just trolling for business is a step in the right direction!

Larry

Jul 17 '07 #7

P: n/a
"Steve" <so***@private.emailaddresswrote
Why are you trying to hold me up to a perfect
standard? . . . I guess they are only human but
you want me to be more than that!
You are whining about something I didn't do. The "poor, poor pitiful me"
role doesn't become you.
Jul 17 '07 #8

P: n/a
As usual, steve is only giving part of the message. Check with Tony for the
full story.

John... Visio MVP

"Larry Linson" <bo*****@localhost.notwrote in message
news:wlTmi.7828$fj5.6660@trnddc08...
"Steve" <so***@private.emailaddresswrote
And how about this one ---

His (... i.e. Steve) technical answers in these forums are good.

Tony

To receive such an assessment from Tony should "warm the cockles of your
heart." Of course, it would be provable that it had actually been posted
had it been linked rather than copied.

I'm sure I would disagree with Tony if the implication was that your
technical answers are _always_ correct, because I've seen quite a few of
them corrected in recent times. On the other hand, providing answers
rather than just trolling for business is a step in the right direction!

Larry

Jul 17 '07 #9

P: n/a
No one is trying to hold you up to a perfect standard, far from it. We are
just trying to get you to meet the minimum standard for decent behaviour in
these newsgroups by having you stop your solictiation.

John... Visio MVP

"Steve" <so***@private.emailaddresswrote in message
news:JW*****************@newsread3.news.pas.earthl ink.net...
Why are you trying to hold me up to a perfect standard? Even frequent
responders like Tony Toews, Allen Browne, Douglas Steele, Marshall Barton
and yes, Larry Linson occasionally error. I guess they are only human but
you want me to be more than that!

Steve

"Larry Linson" <bo*****@localhost.notwrote in message
news:wlTmi.7828$fj5.6660@trnddc08...
>"Steve" <so***@private.emailaddresswrote
And how about this one ---

His (... i.e. Steve) technical answers in these forums are good.

Tony

To receive such an assessment from Tony should "warm the cockles of your
heart." Of course, it would be provable that it had actually been posted
had it been linked rather than copied.

I'm sure I would disagree with Tony if the implication was that your
technical answers are _always_ correct, because I've seen quite a few of
them corrected in recent times. On the other hand, providing answers
rather than just trolling for business is a step in the right direction!

Larry


Jul 17 '07 #10

This discussion thread is closed

Replies have been disabled for this discussion.