|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
|
|
#1
October 2nd, 2003, 11:31 PM
|
|||
|
|||
|
MS Access (helping a friend)
I have a friend who found out about MS access, next to trying to get her to stop using it, I told her I would help her out. So does anyone now if or how you can write something either in a single select statement or some query that
a. counts up all the rows in a table and then b. selects some fields in the the same table where field_1 = field_2. c. then produce a report using MS access.
|
|
#2
October 3rd, 2003, 01:08 AM
|
|||
|
|||
|
RE: MS Access (helping a friend)
a."SELECT COUNT(fieldname) as numrecs FROM tblname"
b."SELECT fieldname3,fieldname4 FROM tblname WHERE fieldname1=fieldname2" c.I don't use M$ Access.. I write my own PHP code to produce reports on the results from the above queries.. 
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > MS Access (helping a friend) |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
