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.
9  1455 
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.
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.
"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
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
"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
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
"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.
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: lawrence |
last post by:
I had some code that worked fine for several weeks, and then yesterday
it stopped working. I'm not sure what I did. Nor can I make out why it
isn't working. I'm running a query that should return 3...
|
by: lawrence |
last post by:
I posted before, but have now narrowed my problem down to this method.
At the start of the method, I test to make sure that I have a
resource, a pointer to data returned from a database. This test...
|
by: lkrubner |
last post by:
I have a webserver through Rackspace. I create a domain. I create an
FTP user. I upload some files. I create a database called
testOfSetupScript and then I create a database user named setup.
I...
|
by: Clay Beatty |
last post by:
When you create database diagrams in Enterprise Manager, the details
for constructing those diagrams is saved into the dtproperties table.
This table includes an image field which contains most of...
|
by: John Ortt |
last post by:
Hi everyone.
I have a database which I have developed in Access 2000 which is working
nicely.
The problem is that my customer only has Access 97. I tried to convert the
database but the main...
|
by: azmiza |
last post by:
Hi everybody,
I need your help.
I want to view my sql database and its work very well which is display in my web browser
but once I want to press button yes, its not working, I check the...
|
by: basestring |
last post by:
Hi I am busy now for many hours without luck
I have a database and when I use PHP to add date to it, it works only one time
when i want to add the next data, It doesn't work. but i don't get any...
|
by: rustyc |
last post by:
Well, here's my first post in this forum (other than saying 'HI' over in the hi forum ;-)
As I said over there:
... for a little side project at home, I'm writing a ham radio web site in...
|
by: Atli |
last post by:
You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t.
In situations where your PHP application...
|
by: alex |
last post by:
I've converted a latin1 database I have to utf8. The process has been:
# mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore
--skip-set-charset mydb mydb.sql
# iconv -f...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
