Search results

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...

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

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...

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...

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...

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 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...

Can you help me with the thread listed below. Thanks. Eva

I am trying to do a query that would time periods from a combo box but I can't get this to work. I have a table for quarters. With Quarter 1 set between #1/1/01# and #3/31/01#. I want the user to be able to chose 1st quarter from a combo box and for the report to query during those dates...

Is it possible to have a report showing the last 13 months but only summing the last 12 months. I was able to do it with a subreport but was wondering if there was another way since I also have to do it by employee. Thanks, Eva

Can anyone tell me how to manipulate dates so that if November, 1 2001 is entered I can make a txtfield November, 1 2000. I am making a form that will summarize data for a period of time but I also need to be able to automatically query data for the same period the previous year. One thought I...

I need code to automatically print a report after it is open. Can anyone help. In other words after clicking on a radio button for a person, I want to open the report, print it and then close it. Thanks, Eva

Thank you in advance for your suggestions Eva

Why is this code not working. The program accepts the code but the text is not coming out bold. Thanks, Eva If [Text357] > [Text406] Then Me![Text406].FontWeight = ExtraBold Else Me![Text406].FontWeight = Normal End If

Hi, My precessor has written a bunch of macros but they do not show up anywhere. The reason why I know they are hidden is because if I try to copy a report into a new database it looks for the macro. Any suggestions on finding them? Thanks, Eva

Hi, I just compacted a copy of my database and it went from 35,000,000 bytes to 10,000,000 bytes. Just want to make sure that it is safe. Eva

Hi, I asked this a few weeks ago but never got an answer. In SQL, is it possible to do a Select Top 10 By Person. Thanks, Eva

Hi, I am trying to normalize a collection database that has 10 years worth of data. In Table 1, I have data on client that owes money, plus the following fields, collection agent, date sent to agent, amount sent to agent. In Table 2, I have Payment Number Payment Date Payment Amount I want to...