Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Noushaba
Starting Member
2 Posts |
 Posted - 2011-09-06 : 01:58:48
|
| i have designed a dta base with the help of MS access, in this DB i have made a form which contains four fields, person name, status, priority and date. now i want to design a query with the help of which i want to select a criteria for generating a report for example if i want a report fo be genertaed by only selecting person then it should generate the report, but the problem im facing is that i have to select all the field to generate the report and if i dun select any one field even it gives a blank report plz help....i want to design such query with gives a report by selecting any field and the field which is not selected is automatically skiped.noushaba shafiq |
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2011-09-06 : 02:17:47
|
| Are you Using SQL Server..?Karthikhttp://karthik4identity.blogspot.com/ |
 |
|
|
Noushaba
Starting Member
2 Posts |
Posted - 2011-09-06 : 03:41:44
|
| no im using MS accessnoushaba shafiq |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-06 : 04:47:17
|
| please post this in ms access forum then------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
plz help