Search results for query: *

Hi lespaul I've tried what you've suggested - but access returns the error - syntax error - missing operator. SELECT Form No, 'Daily Life', Daily Life FROM visit table UNION SELECT Form No, '', "Contact", contact FROM visit table UNION SELECT Form No, 'Clothing',clothing FROM visit table...

select groupfield ,Sum(IIf(satcomments="Yes" and daily life="Yes",1,0)) AS dailycountyes, Sum(IIf(satcomments="No"and daily life = "Yes",1,0)) AS dailycountno, Sum(IIf(satcomments="Partly"and daily life = "Yes",1,0)) AS dailycountpart from visit table group by groupfield I've also tried If...

Ok - I've used PH's method in the query and it works great, until I come to a point where I have to use 2 criteria in the IIf statement - Access reports either I've written the syntax incorrectly or the argument is too complex

Hi I need to create a report to produce the number of complaints / compliments based on at least 19 different criteria in one table. Essentially each one of the 19 criteria have 3 options - Yes, No & Partly and I need to return a figure for each. This will require a ludicrous amount of...

I've tried searching for earlier posts like this but to no avail. I've got a list box on a form - list box is called "themelist" Form is called "visitinfo" Users can select up to 14 different options, which I then need to update a table with 14 different "yes/No" fields. (Other fields in this...

Hi I have a report that displays several text fields one under the other down the page. When certain criteria are met, some of these text fields are set to Visible = false. The problem is that there are gaps left where the fields do not display. Unfortunately Can Shrink and Can Grow don't work...

Aaargh! I had this working before lunch and now its just stopped! The value is null it appears when I use the "watch function" The code is in the report "on activate" event - it seems to work wen I switch in the report from design to normal view, but not when I activate the report from the...

Thanks! Much clearer now :)

Thanks very much guys - working great now!

I have a report that keeps on crashing with 2427 error. I need a text box (Statutory Books) to be invisible if another field (satstat) = "Yes" (its a lookup text field in the table) or visible if it reads "no" or "partly" The field definately has Yes / No in it, but for some reason access...

I'm trying to start a new Microsoft access 2000 project. The wizard keeps prompting me to select an SQL server, but none are listed in the drop down box. I'm assuming none of the SQL server programs are loaded, but the IT department are being notoriously slow in responding to me. Please help!

Hi, I'm using a form with multiple search criteria, some or all of which can be left blank. When all fields are left blank, the query returns all records. However, there are likely to be several thousand of these records in the future. How can I get the query to return NO records if all fields...

I've had my Access files updated at work and previously when using access I'd be prompted for a password. Now this screen is missing and I can't use the programmers level password I need. I think the problem is that I'm now logging on as Admin automatically - apparently this means you're not...