Search results

Is it possible to have the top value be a parameter. I created a query that give me the top 10 records. Works fine..... Can I make the top value a parameter for the user to input their own value? Example parameter value 50 would be the top 50 or 20% would be the top 20%.

Brian - Thanks. That worked..... Bob - My mistake you are of course correct it is a control and not a field. Thanks to ALL

Brian and all.... The field being used is called [Cash Flow] the running sum field is text26. [Cash Flow] is formatted and works fine. You are right I get the #name error when I try to format [text26]. The control source for [text26] is [Cash Flow]. Is that what you mean by setting the control...

Field value is less than 0 then apply format. I am trying to apply the format to the running sum field. The value being added to the running sum is both negative and positive and the conditional format works fine on that field.

I tried that. The textbox next to it works fine. There is something? about it being a running sum.

I have a report that has a field with running sum over the group. When I try to set the Conditional format to RED BOLD for negative values I get an error. The current format for the text box is currency. How do I set the conditonal format for running sum text box? Thanks.

That is MUCH better!!! I just didn't know how to do it.

I would prefer to do that. However I guess I don't know how to link a field [month 5] to a field [Date 5/11/2011]. How does month 5 relate to 5/11/2011? If I join the tables using month to date i get nothing.

Thanks for your help. I figured out a work around where I use an update query and get the month value 5 and the year value 2011 from the date field 5/13/2011 to populate the fields after the date 5/13/2011 is entered.....All is working as needed now.

I only get a report of the sales figure once a month from different vendors. Then the Sales are recorded for the month. Example ABC company send a report that says Sales in May 2011 were $20000 DEF Company send a report saying Sales in May 2011 were $4000. I have a column for Budget Sales and...

Well not really many tables but some. Example: Tbl[Sales] is recorded by month not by monthdate Sales: month 5, Year 2011, Actual Sales $20000 Tbl[Expenses] is recorded by monthdate [name],[Date 5/11/2011],[Amt $511] I want to query Sales-Expenses for May. However in tbl[Sales] the date...

My problem is I have many other tables that only have [month] and [Year] with values that need to be added. Ex: Month Year Sales 5 2011 $1000 Date Expenses 5/24/2011 $100 I need to calculate the net for May $1000 - $100 = $900

I have records that have a date field mm/dd/yyyy. I also have fields named Month and Year. How can fill in the Month and Year field from the date field using an update query? I have Need to fill in Date [Month] [Year] 5/24/2011 5...

As am I. 1997 Jordan for me. You desereve it.

That would do it...... Thanks.............

I have a simple form with a header with 2 fields 1 unbound for year and 1 combobox for vendor. I have a button with this code: Private Sub Command36_Click() Me.Requery End Sub In the detail section I have the fields I want to see and edit from a query with the detail section default view set...

That worked ! :D It also added the .txt better solution. I was looking at your Code Store on your site. You should call it COOL CODE STORE. I am going to use it and continue to add to it. I am not really a programmer but can "borrow and revise to fit my applications". This will help alot...

I thought I would give that a try and I get a Type Mismatch error.

Thanks for the response. I have been beating on it for a few hours now and finally got what I wanted. Here is what I used. Set rs = db.OpenRecordset("filename", dbOpenDynaset) rs.AddNew rs.Fields("Filename") = Mid(sPath, intlen + 2, Len(sPath) - intlen - 5) rs.Update

I am importing a .txt file into a table "MasterAging". I would like to add the filename to another table called "Filename". What would the code be to write the filename of the file being imported to the table "Filename"? Would the code be place just after the this: DoCmd.TransferText...