I am building a contacts DB and each contact falls into one or more categories, which I have set to yes/no (this displays the little tick box in the...

Is there any way to set up a report so that only records with a ticked field will be displayed on the report? I was thinking something like this in the query,...

Hi i was wondering if anybody can point me in the right direction. I would like to know if there is anyway of using a yes/no box that when a user changes its...

I am building a recruiting database for a department at work. In one area on my form, I have a series of Yes/No toggles and check boxes for certain skill...

I have a report - where I have a yes/no field. I can total the number of records no sweat - but I need to total the number of records that are "Y".

Hi all, I convert the application from Dbase to Microsoft Access. It has a field name field name Plist (Hazardous Materials) Data type is Yes/NO (Yes=-1,...

I am using Access 2007. I have created a custom Yes/No field in a table by setting the DataType to Text and then inserting a combo-box in my form. I have...

Hello, I have a Yes/No field but in all queries and reports it appears with the value -1/0. I need that it appears as Yes/No. How can I do this? Thanks in...

Hello Everyone, I have several yes/no fields in a table and I am displaying them in a listbox. One user on the network sees the words yes and no. All other...

Hi. In the format box for a field, instead of Yes/No, I have entered ;"Male";"Female" And I have changed the Lookup to Text box. But in datasheet, only Female...

I have a combo box on a form with a Yes/no format. The Row source is "Yes";"No". The Drop down is fine (Yes/No) The table is Yes/no with a Yes/No format. Yet...

I have a YES/NO check box called 'merchandisereceived" on my form. How can I have the sum of the ones that = False (merchandise received) in my report...

How do I use a Yes/No button on a form to set the Yes/No value of a specific record in a table? I've got several of these buttons which I'll need to place on...

I'm working on a record-keeping system for a traditional Chinese medicine practice and am trying to work out a way of recording the needle points used in each...

I shortly have to tabulate the results of a survey that contains a number of Yes/No questions. The answers to these, I assume, will be best represented by...

Hello, Is there any easy way to lose the (-). I would like Yes=1, No=0. (as a check box) thank you. Yo

Hi, Please advise how best to count Yes/No data. Regards. Rayh

Hello, It has been a while since I opened my database, but now all of the Access Objects in the navigation pain have a small yellow symbol at the bottom...

YearsService: DateDiff("yyyy", ,DateSerial(Year(Date()),12,31)) I use the above statement in a query to calculate the length of time an Employee has been...

In northwind 2007 template, yearly sales report summary show total sales for whole year but in Q1, Q2, Q3 and Q4 then Total. Great appreciated if anyone can...