Search results

Man, how frustrating! I double checked and I forgot a space inbetween the words, but it didnt help. The #Error is gone, but now its just blank.

I tried this for the control, in the text box, in the form, in the footer: =Sum([UnitsReceived]-[UnitsSold]) and Im still getting this message "#Error" Stumped... The only thing I can think of is that, in my table for the subform, does the properties for these have to be any thing special...

In my query Im trying to put this: Field: UnitsOnHand: Sum([UnitsReceived])-([UnitsSold]) And I keep getting errors. #Error Any other ideas? Thanks for the reply.

I have a subform with these two fields: 1. UnitsReceived 2. UnitsSold I want to keep an running sum of what I have on hand. I created a text box and put it in the footer of the subform with this control: =Sum([UnitsReceived])-([UnitsSold]) Its staying blank. Am I suppost to add anything...

Hey Pat, Of course I didnt try to use your column names. But what was missing was the parenthesis. Got it to work now. Thanks a mil. John

I got it to work! I used a macro, please dont slap me. But I used a where condition and when Im done entering data into the form, I made a button to reference the macro and it works great. The report for that form pops up. Thanks all for pointing me in the right direction. john

Yes I have Quantity and Unit Cost fields. In the Total Cost field is the expression: =[Quantity]*[Unit Cost] I think what youre telling me is that Access cant take this further and give me a sum of the Totals for a final cost. Is there any way of doing this? I tried your expressions and they...

I searched in Report forum and couldnt find help, and figured this is a general topic. I have a report with a subform in it. I want to run a sum of a field in the subform. I made a text box inside the subform footer. And put this expression for the control: =Sum([Total Cost]) The field box is...

I made the report from a form. I dont have an underlying query for this. Is it still possible to do this? And not have to design the report over? In the query, what do I put in the criteria to make it print the selected report? Thanks. john

Thanks Rich, I rearranged the looks of the report.....to look more like a report. How do I make a macro to open the report thats based on the form (record) that Im currently in? So far the report lists all of the forms.

I have a form with a subform inside. I need to make a single report from this record. What do I need to do to start this? Thanks

Or is there a way to set it up to store each record? Or would this make the file to large to handle over time? I order about 10 times a week. So i a year I will have about 500 entries.

When I put "Active Status" in the criteria, I then get an error. The expression is wrong" Would it be okay to send you my database? To see if Im missing something.

Im going with Davids idea on the Active Part Number Query. When I change a description, I dont want it active anymore, so I uncheck it and then create a new part number/description and check it active, but in doing this, the old records that had this part number disappear.

David Can I email you my database? Its a little unfinished because I dont want to go any further until I get this problem solved. Let me know. Thanks. john

Yup, I missed the Parenthesis. I got the text box to show the description now. And I locked it. But I made an attempt to edit a part number and now instead of just the part number disappearing, everything is gone now on the older record. Does this have something to do with the query and the...

Hey thanks for sticking with me and working on this with me. I did all you said and the combo box is working but I cannot get the text box to work. I have this: =Combo14.Column3 I figured out its 3 for sure by putting a number in the third row for the widths on the combo box. I also tried...

I guess I need more detail on how to link the query to the PartID which is a field that actually exists. And how to set up the Subform Table without the Part Number and the Description, because thats where the parts will be entered. I think thats whats confusing me the most.

Heres what I got: Purchase Order Table: Parts and Description Table: Subform Table: Query based on Parts and Description Table; Containing fields - Part Numbers, Descriptions, Active (True) It works for only the "Active" Parts will be selectable. But again I tried to edit the list. I...

I just got the Query to work okay. I ran it and its showing me all the "Active" Parts that I checked in the table.