Search results

OK, I've made some possible headway but it's still not working right. I confirmed that the wildcard (*) is being passed to the query from the combo box if it's typed in so I tried both of the following to allow for it in my results. I tested that it would work by doing the following in the...

Yeah, I spent about 2 hours searching and didn't find a relavent thread already in existance. I did not run across this one, all depends on what you search for. As that thread suggested, Left() and Right() functions might allow me to put an iif statement in there to do what I need, as long as...

ok, so I felt like being slightly poetic.. :D On to the problem. I have a form that's fairly complex and drives a report our sales and management departments use to determine a lot of business decisions. The form has a couple of date fileds and 10 combo boxes. Each combo box get's its list...

How about- Pkg Qty: IIf([QTY]<=99,"10 PER",(IIf([QTY]>999,"200 PER","100 PER"))) test for below the minimum, above the maximum and the rest falls in between?

Looks like that solves my issue. Guess that's what I get for letting my SQL knowledge get rusty by not using if for about 2 years and then jumping back in quickly. Thanks!

I've got a query that is defeating me, but that might be due to a week's worth of insomnia related sleep problems. My issue exists in the following query, of the four IIF statments in the HAVING portion of the query and the need to select all if the statement is false for each one of the four...

Unforunately that only closes the error message and nothing further happens. I've also just on a whim run the compact/repair tool and that doesn't have any effect either. I did however randomly find the cause but don't understand why the problem occured. A 'On Lost Focus' event had been set on...

I have a database that suddenly has a new error this morning that might have been caused by another user while I was not in the database. When an event procedure is triggered by a form the following error is given, regardless of the code or the event that triggered it: "The expression on [event...

I'd use an IIF statement in the value field of the crosstab that checks for the result to be true or at least not null and instead of the result include "x". rough example IIF([test_column] is not null,"x",)

Thanks! that seems to be the key to solving this issue. The hazards of having the developer's box that was built for me that isn't configured the same as everyone elses' in the office.

I've been building a report that has the option to export the report per employee into a seperate file and to add more functionality to it I found this sample database and used the directory select to allow the user to define where the reports export to. It works beautifully on my computer but...

OK, I realized I was restricting my search criteria too much and ended up finding this: http://www.access-programmers.co.uk/forums/showthread.php?t=85319 It looks like a possible solution to my problem but as I can't find any issues similar to mine that are on here that actually have some sort...

Does the source table(s) with this information have a record that says oranges if it is 0 or is it skipped? If it has a record that says oranges but for quantity is blank you could always put an IF statement in the field something like: FieldName: IIF(IsNull([FruitQuantity]),0,[FruitQuantity])...

In the printer's driver settings is there an option to define it as continuous feed as the paper source? It seem to me that the last system I used with a printer using that type of paper there was a configuration option to define it so that it would take the feed into account for where pages...

Date() is the correct format to return today's date in a query, you can also use Now() which returns not only today's date but also the exact time the query is executed. That should do it for you, otherwise you need to get into a slightly more complex method of adding 30 days to the date you...

I've faced that situation myself. The solution I used was to use the Criteria options when developing the query. I set a where statement in the query that checks the combo box eg: [Forms]![DateRangeForm]![managerList] Where Is Null In the field that you are testing the combo box against leave...

I may not be fully understanding what you need but my approach would be to use the Columns feature in reports and depending on the specific needs of the rest of the report use them in a sub report to display the detail records. You can define them in the page setup while editing the report and...

I just inherited an old database report, I have a report that breaks down monthly sales for each of our vendors and starts a new page for each vendor. Currently it creates a report roughly 700-1000+ pages each month. In an effort to save paper and postage we are wanting to export a seperate file...