Search results

Sorry I'm relatively new to Access so I've probably created this report all wrong. What I'm trying to do is have a yearly report that has a sum (or count in this case) of the total number a "Y" in the "Decision - Our Favour?" field and the total number on "N". I wanted to seperate this for...

Actually after ammending all the text boxes in the report, they all only show 0. So, something is not quite right. Sorry about that, I should have checked all of them before coming back to you!

Works like a charm! Thank you very much.

I've ammended the expression but I still get the #Error message. FYI the report is linked to a query that uses a paramter to search by the year if that changes anything. I just can't understand why the code would work in Access 2010 & not in Access 2003.

I still get a #Error message in the text box. But it's just really strange that it works perfectyl in my 2010 database but not in 2003. I'm affraid I'm in no position to change the name of the "Month" field.

Okay thanks. So am I right in believing that the code should now be written as follows: =Count(IIf([Complaints Table]!Month=1,IIf([Complaints Table]![Decision - Our Favour?]="N",0),0)) I have tried this and it still gives a "#Error".

Hi All, I am currently using Access 2003 and have an unbound text box in a report with the following code: =Count(IIf([Complaints Table]![Month]=1,IIf([Complaints Table]![Decision - Our Favour?]="Y",0))) The problem that I am experiencing is that I keep getting a "#Error" message in the...

Thank you for your reply. I'm not quite sure what you mean by "Break"? Thanks J.

Hi All, I have many forms in my database, three of which completely freeze the database if I edit the slightest thing on them. These forms are all the same, and are unique to any other type of form in my database. An example of one of the forms is the following: The form is an "Edit...

Hi all, I'm trying to show the modal value of a column in a query that only has text in, not numbers. I want to present this in a text box in a report. My report already has a query as its record source that only shows data for a given year and given month, these are chosen using parameters...

Hello all, I am having trouble creating a chart within a report. Let me start off by explaing my report. I have many unbound textboxes on my report that all have the code very similar to this: " =Count(IIf([Complaints Table]![Month]=1,IIf([Complaints Table]![Decision - Our Favour...

I have now solved this problem! So for anyone that was interested here is the solution: My details are as follows: Currently my dropdowns work so that; cboDealerType is based on cboDealerGroup and cboDealer is based on cboDealerGroup BUT I needed cboDealer to be based on both cboDealerType...

I have recently found this thread http://www.access-programmers.co.uk/forums/showthread.php?t=250011, which shows exactly what I'm trying to acheive. However, I have only just started using access within the last 2 weeks and can't seem to get it to work for me. My details are as follows...

Brilliant thank you. I am having trouble with the drop downs though. I have looked thoroughly at your example and copied it into what I need for my database. I have created the SELECT DISTINCT queries for all 3 dropdowns, and used the exact code you used too. The first dropdown is fine, and...

Thank you for your reply JHB. That's almost what I need, but without having duplicates within the dropdowns. Is there any way to remove the duplicates? (edit) Also the third drop down (FieldNo3) doesn't work. (edit) Actually, scratch that last sentance. It does work, but once you have chosen...

Hi all, I have a form with various input boxes, three of which are combo boxes. These combo boxes need to affect one another. So let's call these cmb1, cmb2 & cmb3. Hypothetically let's say: Within cmb1 the list is A, B, C & D If the user was to choose A, cmb2 would show the options 1...

Works an absolute treat! Thanks for your help. As for the spaces in the forms/queries etc.. I will change them right away, thanks for the heads up. Best, J.

Not quite sure what you mean. Are you askign me to show you the code i have for the button? If so here it is: Private Sub Search_Click() Dim Msg As VbMsgBoxResult If DCount("*", "Search Form Query") > 0 Then DoCmd.OpenQuery ("Search Form Query") DoCmd.Close acForm, Me.Name End If If...

That code is exactly what I'm looking for! Thank you. But, there is one small problem. When i search for a record that is 100% in the database, the search button now doesn't search. Any help on that? Thanks, J.

Hi All, Bear with me as I'm am relatively new to access. I have a search query that searches for different results based on 3 criterior. I have set up a form so that the user can input the text into the form and then once the Submit button (that i created) is clicked the query table will be...