Search results

Thank you thank you thank you. That was awesome.

I just got my program to show me what needs to be mailed for the day. (Can you believe we've always hand written them!) Well, I want to print them on labels and stick em to the book. Great awesome all set! My problem is, I only mail a few a day and I don't use up the whole sheet. Is there a way...

I feel like the answer is staring at me but I can't figure it out. I have a number of reports to create based on different dates. Since the dates are confusing, I made a table that looks a little like this (of course I simplified it) Reporting Month ... Start Date ... End Date...

Thanks for your reply :)

I have a similar problem...I was able to create a macro Action-RunCommand and the Command is OutputToExcel. When I do this, it does open excel and you see the data there, but I'm not able to put it in a specific file location. And I don't know how to write the VB code. So maybe you know more...

Can someone direct me to help with setting up User rights? I've always been the only user, but now I have multiple people working from my database and want to limit there authorizations. Also, is it possible to have someone actively using the database while I continue to make changes for forms...

Not-So-Quick Fix. I think my above goal isn't going to work because of the dates being different for each cancellation. So I just ran another query after the date parameter is made to remove the duplicates and then run my count query off of that. <sigh> I'm getting so lost in my own database.

Goal - Show how many policies (dbo_Policy22.Policy.Number) were cancelled during a certain time period (Invoice Date). Problem - a policy can be cancelled more than once and I don't want to count it after the initial cancel status (885). Question - Below is my query. I'm thinking I type...

I'm not an expert :) but it I had to do something, I would create a macro to do it. Not sure if that was helpful though. And if you need any help with that let me know.

answer http://http://support.microsoft.com/?scid=kb;en-us;303257&spid=2509&sid=global An answer? Yipee. At least I wasn't losing my mind. I thought it was my programming. Thanks for helping out.

They are both queries from the same table. One has an expiring date of 01/01/05-01/31/05 and the other has an expiring date of 01/01/06-01/31/06 to show if someone renewed their policy this year.

I use a LookUp table. I create a table that just contains Autonumber ID and the name of the towns you use. Then in the table, under the town field, change it to a combo box, or list box. And use your lookup table as the source. Then when you add it to your form etc, it will have the data ready...

I am trying to Right Join two queries which are basically from the same exact table, but when I do that I get the following error. ODBC--called failed. [Microsoft][ODBC SQL Server Driver][SQL Server] The column prefix 'MS1' does not match with a table name or alias name used in the query...

This is sort of a general how to fix it question. I have a database that holds all of my companies information regarding policies. For accounting reasons, they have seperated some policies and created an entire new database. So there is Company 01 and Company 02. I have been asked to create...

Is this not possible? Is there a way to include in the statement to show Is Null fields?

I need to run a query counting how many policies a client cancelled. But I need the query to include zeros. Is this possible? Here's my SQL Statement currently. SELECT DISTINCTROW Pqry_CancelledPolicy01.Number, Pqry_CancelledPolicy01.Name, Pqry_CancelledPolicy01.POLICY_STATUS...

Holy (insert swear word here)!!! It works. It's the Group By Format part that made it work. How do you learn these things. Thank you so much for the help. It's greatly appreciated.

I have been through this board looking for an answer, I've come close but not quite getting it.:confused: I (obviously) need to count how many records each user has completed (easy) I need to count how many they did in a months time. I need to report multiple months in one report. A little...

You need to run the report of a query, not your table. The query has options to Set Criteria or your paramenters and calculate your columns. Hope that helps.

I may have an answer I know this is an old post, but it seems to get a lot of views, so I thought I would put what worked for me, in case there are still people without answers. I had the database on a share drive in my work, and when someone from another workstation open it, the linked tables...