Search results

I found it. Thanks. Eva

Hi, I am trying to make a query Select Top 10 for each person. I can do a select Top 10 but not for each person. I think the only way is to do it in vba code. Which is to run a report for the top 10 for the first person and then run the top 10 for the next person. Can I otherwise do it in...

I finally got it to work. I revised the query so that I don't have a null value.

Because of a query where I am avoiding duplicates, (Date3: IIf([Last]=[Date1],"",[Last])), I have a date field that is in text format instead of date format. How can I write the query to save it as date format. Thanks, Eva

actually the date field is in somebody else's table so I can't change that. I basically once the first, second and third dates for a store to be inventoried. Her table has a list of all the dates for stores. Is there a way to do first, second and third

actually is there a better way I could have done that query? Can I do first date, second date and third date Thanks Eva

Hi, I am having trouble in the following query to make the date query a date. That is because I am doing different things, I am selecting first date as date1 and Last Date as Date 2. If the second date equals first date,it is null. Doing that makes the field a text field. Do you have any...

Hi, I have a query with two criterias. The first one is by Company and the second is by type.(monitored or not monitored). I want to be able to give three choices for the second criteria, monitored, not monitored or all. I tried using an IIF statement, if monitored is null, value is * but it...

I just want to thanks Rich, Pat, Ian, Jack, Harry, David R and all the people who have helped me. Thank you for donating your time to us beginners. You have given me some great code. I hope I can start doing more of this on my own. Eva [This message has been edited by asp_learner (edited...

Thank you. Wow I am the one that is brain dead. I didn't think of that. I hope this experience will help make me understand programming better. Have a great day Eva [This message has been edited by asp_learner (edited 01-25-2002).]

Rich, I tried it in both the group footer where the label is and in the main report. I tried it in all different events. Eva

Hi Rich, I still can get the HasData Property to work. I tried writing the code several ways but the label still stays invisible. What event should I put the code in. This is one way I wrote the code: If Me![SubKnownLosses].Report.HasData = 0 Then LbLNoData.Visible = True Else...

Hi, I was really trying to do this on my own but I can't get this to work. I have code in the subreport where if there is no data I can make a label visible. when I run the subreport alone the code works. I can't get this to work from the main report. Basically I am trying to write code if...

Thank you very much. You have been so help ful to me since I started using this forum. I was hoping not to have to do additional queries but I see I have no choice. Thanks, Eva

Hi, I have two queries that I am having trouble joining. there are three options and I don't know why we don't have a forth option. to be able to join both ways. to include all in one query and only those that are equal and to include all in the other query and include those that are equal. It...

You made my day. That worked great. Many Thanks, Eva [This message has been edited by asp_learner (edited 01-09-2002).]

I have a form where I am allowing the user to either user a combobox for a date period or to chose from two text boxes for a start and end date. On the report I have a textbox with the followingsource: =[Forms]![Request Date for Quarterly Report]![cboWhatQuarter].[Column](1) Or [Forms]![Request...

I just answered my own question. I made a query with two unlinked tables, one with the fiscal year dates and the other with the employment dates and in the criteria for employment date I used between [Start Date] and [EndDate].

I am trying to do a report by Fiscal Year. If a date of employment starts during a fiscal year it it will know the Fiscal Year to choose from. The dates for my company vary from year to year. I know I could do this with an IIf statement but would like to know if there is a way to tie it to a...

Thank you Harry and everyone who answered. I finally got it to work in an individual report. I also got it to work in subreports by putting code in the on open event for each subreport Thanks again and have a wonderful day Eva [This message has been edited by asp_learner (edited...