Search results

>>in the Report Footer, you can place a subreport that is based on a query that produces the count that you need.<< how do I do that? I have:StrSource= "SELECT * FROM Crinc WHERE... etc. in a CASE statement Then I have: Docmd.OpenReport "OverLoad", acPreview, strSource on a button that...

excellant explaination, best I've seen. Thank you very much. But after lookin gat it a few times, isn't: Where (date between A AND B AND field = "X") OR (date between A AND B AND field = "Y") incorrect? Doesn't this say between the dates and fields X & Y? Shouldn't there be another set of...

pardon me for jumping in but, this was a great suggestion for me. I've been trying to figure out a way to do that and didn't even know about a NoData event. Thanks

I need to get a count of all the records where the BillName <> 'Landfill' but I only want to display the records where the weights are over 14020 pounds. I'm not sure how to do that. I ran a query that gets all the records that have both requirements but then all the records show. Do I have to...

Pat:It works, but it's still weird<grin>. I did have Is Null on a separate line but it still didn't work. I started the reconstruction by pasting your code in the SQL part and then going back to design. I ran it and it worked so I started adding the rest and it added the 'Between' line twice in...

I have the following formula in a textbox in the page footer of a report: =Sum(IIf([Prod_List] Like '*Compact',[Weigh_Net]/2000,0)) the result is 694 beneath it I have another textbox with the following formula: =Avg(IIf([Prod_List] Like '*Compact',[Weigh_Net]/2000,0)) the result is 5.46 I...

assuming you have this on a form and your textbox for entering the data is called EndDate... try this: Private Sub enddate_KeyPress(KeyAscii As Integer) Me!enddate.BackColor = 255 End Sub The color will be what ever you want (probably the default white) until the user presses the first key...

I'm trying to write a query that finds any category that is not on of the ususal ones. so I have: SELECT Crinc.CENTER FROM Crinc WHERE (((Crinc.CENTER) Not Like "ER" And (Crinc.CENTER) Not Like "WR" And (Crinc.CENTER) Not Like "SE" And (Crinc.CENTER) Not Like "RO")) OR (((Crinc.CENTER) Is...

as soon as I saw your answer I remembered. Thanks again

I have the following code in a texbox called "Compact" : =IIf([Prod_List] Like '*Compact',[Weigh_Net],0) Thanks to Pat it's working fine. But in the [Date] footer, I tried to sum that textbox with =Sum([Compact]) but I get an 'Enter Parameter Compact' box. I know I've done this before...

Pat:That was it. I can't believe it was that simple. I was so close<g>. Now, one more step if you will. I have this formula in the ControlSource of the textbox called Text99: =IIf([Prod_List] Like '*Compact',[Weigh_Net],0) and I need to sum it in the group footer. I tried =Sum([text99]) but...

I have the iif statement listed below in the ControlSource of a text box in the detail band of a report, and I keep getting a Runtime error 3075 syntax error (Comma). I've used iif statements before and I pasted this one in a query and it ran and gave me the correct results. What's the secret to...

that was it. Thanks. It took a bit a tweaking. I checked OnLine help and the first time I ran it it changed everything and gave me 2720 for the year. But I finally got it. Thanks again

the dates are currently 10/24/1920 and 10/24/1900. I need them to be this year. thanks

is there a way to change just the last four digits of a date? I just need to change the year on several records.

Solved it! HEre is the solution of anyone needs it: Dim imp_file As String imp_file = Me!Text0 Docmd.TransferText , , "Crinc Temp", "C:\Access\" & imp_file, False

I can import a text file using the following code: Docmd.TransferText , , "Crinc Temp", "C:\Access\Rec_1019.txt", False but I want to be able to place a textbox on a form and have the user be able to enter the textfile name they want to import (the text file is always the date so it will...

What you're doing is way beyond anything I do but if it helps here's what error 3101 is: The Microsoft Jet database engine can't find a record in the table '|2' with key matching field(s) '|1'. hopefully that will give you a clue

The following code Opens the Fiscal Search Menu form and closes the Main Menu form. Put it on the OnClick event of a button. DoCmd.OpenForm "Fiscal Search Menu" DoCmd.Close acForm, "Main Menu" Good Luck

let me see if I can reword my question or better express what I need. I have a report grouped by [Product] and I set the select statement to ask for 'Wood' or 'Veg', but I also need 'Vegr'. However When the grouping shows up on the report I just need to group by Wood and Veg and show the...