Sort by yes / no field

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

I am new to Access programming. I would like to setup a
report from data acquired from excel and loaded/imported
into Access. A field has a yes or no answer. I want to
preview and or print a report based on the yes or no
answer. HOw and where do i do this. Also, if you know of a
good book to acquire, I would appreciate knowing of it.
 
In the subject you indicate "sort" by yes no.
This would be best accomplished in the report design
view. Right Click on the left top little square of the
design window and a selection box will drop down, here you
select the sorting/grouping selection and indicate
variable in the "Filed/Expression" slect box. Than
indicate ascending or descending as appropriate.
In the description you gave, you indicate you may want to
print the report for either "yes" or "no". This is best
accomplished by basing the report on a query. Assuming
you have not yet done this, Just open the report in design
view, dbl click on the same small square described above
in order to open the properties window. Select the data
tab, and click in the record source block, now you see a
little square qith three dots to the right of the line.
click this square and build the query , select all
applicable variables required for this report, including
the "yes/no" variable. In the criteria row below
the "yes/no" variable type "[Enter Yes or No]" (without
the dbl quotes). Now each time you run the report you
are promted to type yes or no in order to select the
desired parameter.
Hope this helps you. Sorry if I am a bit too detailed but
I am not sure of your level of experience with Access.
Fons
 
Thank you. That did help. However, it no longer shows any
data when I enter either yes or no. I appreciate the
detail that you went into for me. Until I learn more that
is the appropriate amount of detail. Thanks again. I will
keep trying different things until my training CD and book
arrive. Sam

-----Original Message-----
In the subject you indicate "sort" by yes no.
This would be best accomplished in the report design
view. Right Click on the left top little square of the
design window and a selection box will drop down, here you
select the sorting/grouping selection and indicate
variable in the "Filed/Expression" slect box. Than
indicate ascending or descending as appropriate.
In the description you gave, you indicate you may want to
print the report for either "yes" or "no". This is best
accomplished by basing the report on a query. Assuming
you have not yet done this, Just open the report in design
view, dbl click on the same small square described above
in order to open the properties window. Select the data
tab, and click in the record source block, now you see a
little square qith three dots to the right of the line.
click this square and build the query , select all
applicable variables required for this report, including
the "yes/no" variable. In the criteria row below
the "yes/no" variable type "[Enter Yes or No]" (without
the dbl quotes). Now each time you run the report you
are promted to type yes or no in order to select the
desired parameter.
Hope this helps you. Sorry if I am a bit too detailed but
I am not sure of your level of experience with Access.
Fons
-----Original Message-----
I am new to Access programming. I would like to setup a
report from data acquired from excel and loaded/imported
into Access. A field has a yes or no answer. I want to
preview and or print a report based on the yes or no
answer. HOw and where do i do this. Also, if you know of a
good book to acquire, I would appreciate knowing of it.
.
Click to expand...
.
Click to expand...
 
If you wish to show all records and only show a summary at
the bottom of the report for the yes entries, you can take
the "[Enter Yes or No]" out of the query and put the
following in a text box in the report footer:
=DCount([Yes/No],"yourtable name","[Yes/No]=Yes")
If you named the variables different substitute your names.
Hope this helps.
Fons
-----Original Message-----
Thank you. That did help. However, it no longer shows any
data when I enter either yes or no. I appreciate the
detail that you went into for me. Until I learn more that
is the appropriate amount of detail. Thanks again. I will
keep trying different things until my training CD and book
arrive. Sam

-----Original Message-----
In the subject you indicate "sort" by yes no.
This would be best accomplished in the report design
view. Right Click on the left top little square of the
design window and a selection box will drop down, here you
select the sorting/grouping selection and indicate
variable in the "Filed/Expression" slect box. Than
indicate ascending or descending as appropriate.
In the description you gave, you indicate you may want to
print the report for either "yes" or "no". This is best
accomplished by basing the report on a query. Assuming
you have not yet done this, Just open the report in design
view, dbl click on the same small square described above
in order to open the properties window. Select the data
tab, and click in the record source block, now you see a
little square qith three dots to the right of the line.
click this square and build the query , select all
applicable variables required for this report, including
the "yes/no" variable. In the criteria row below
the "yes/no" variable type "[Enter Yes or No]" (without
the dbl quotes). Now each time you run the report you
are promted to type yes or no in order to select the
desired parameter.
Hope this helps you. Sorry if I am a bit too detailed but
I am not sure of your level of experience with Access.
Fons
-----Original Message-----
I am new to Access programming. I would like to setup a
report from data acquired from excel and loaded/imported
into Access. A field has a yes or no answer. I want to
preview and or print a report based on the yes or no
answer. HOw and where do i do this. Also, if you know
Click to expand...
of
a
good book to acquire, I would appreciate knowing of it.
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top