Search results

I want to generate three reports each based on current month, previous month and the next month. The report is based on a query so what criteria/condition shall I put in the query to achieve the desired reports. Thanks in advance.

Thanks JHB for your time and patience, it finally worked, actually the query/expression was alright but there was some issue with that report. I deleted it n number of times and re created, finally its fully functional now. Thanks alot

Of course I sent you the original by deleting most of the records and as I dont have Zip and the data is too much to send without zip.' I deleted that report and query and constructed another one from scratch. Still the problem exists. Wondering what could be the issue.

Yes, I have variety of dates in the original report. I copied your expression and pasted it in the main db, no change at all. The same expression works in a new db but not on the main. There is some corruption or some reason, cant figure that out.

Made a simple db from scratch and applied formatting, it worked but when tried to apply the exact same formatting on the required db, in vain. Did compact and repair quite a few times as well. Thats the only formatting involved. No other formatting has been applied.

Done that, even a simple condition doesnt work, thats what is making me worried

here's the file. Sorry for not zipping, my zipper expired and not letting me zip.

Tried that already, doesnt work. Lemme send u the original db

I imported all the relevant tables, queries and reports into a new db and still nothing works. Its getting on my nerves now.

Did Compact and repair as well. Lemme import it into another db and see if that works.

I came across a situation yesterday where I had to work around conditional formatting in reports. after jotting my head a lot, I sent a question here yesterday. I got few replies and tried all but nothing worked a bit. Then something came up my mind and I tried the simplest conditional...

Thanks JHB but this works here in the sample db I hv made rather all the formatting works here. But the problem is that in the main db none of the formatting works. What could be the reason?

here's sample database I want that if the deliver date is within the next 7 days and Cut is still unticked then status should be highlighted. I hope I hv explained it well.

Did exactly the same. The report is as blank as it was earlier. Nothing is working.

Hi friends i want to apply conditional formatting on my report, the fields involved are three: Dont know how to go about it. Delivery Check box Status I want the status to highlight if the check box is unticked and delivery is Date()+7. If Delivery is after a week and check box is unticked...

That worked. thanks

Hi friends Im working on a query that returns the date field records excluding null that is if the said date field is null, query wont extract that record in the report. Im using <>"" and Not IsNull() but both are not working. The type mismatch error comes whereas <>"" works in other text...

Missinglinq: Here is the code that Im using: Dim COLOR1, COLOR2, COLOR3, CUSTOMER As String COLOR1 = Nz(DLookup("[ColorOne]", "order", "[SalesOrderNo] = Form![DOCKET]"), 0) COLOR2 = Nz(DLookup("[ColorTwo]", "order", "[SalesOrderNo] = Form![DOCKET]"), 0) COLOR3 = Nz(DLookup("[ColorThree]"...

sneuberg I have been using this forum and getting help since April and have posted some 80 plus posts and replies. Anyways thats not my concern, my concern at the moment is to get my issue sorted.

I asked this question before in this forum but didn't get any answer. Actually I have two separate databases and the second one pulls few records from the first db using DLookup(). Everything is working fine except the field pulling the record from the combo box. After pulling, the second db...