Search results

Sounds like you are combining strings instead of adding currency. What's the rowsource for the combo boxes?

Ah, well in that case since you have the cost in the Combo box... Control Source for the component cost would look like: =([ProcessorComboBox].[Column](2) + [RAMComboBox].[Column](2) + ... + [CDDRIVEComboBox].[Column](2))

Can you see the costs of the components on the screen? If so then ComponentCost = me.ProcCost + me.RAMCost + ...

A text box with this in the form footer. =Sum([QtySold)*[Cost])

Should be something like this:

replace your field of EndDate in the query with the fldEndDate Then in the criteria section of the Date you want to look up use the Between

After you have the field written correctly, like this (I was brain dead when I wrote it the first time) replace your criteria of >start date <=end date with BETWEEN [RPT_NAIC_AF1]![StartDate] AND [fldEndDate]

You need an inventory Query. They can get rather bulky, but basically it ends up being a sum of everything you've bought minus the sum of everything you sold.

fldEndDate:IIf([RPT_NAIC_AF1]![EndDate] Is Null,Now(),[RPT_NAIC_AF1]![EndDate]) I also use this instead: BETWEEN [RPT_NAIC_AF1]![BeginDate] And [fldEndDate]

Well, sometimes we "bill" ourselves for a negative amount when I magically find material in inventory. We also ship a negative amount if a customer sends material back.

Depending on the numbers Fix() may be a better option. From the 2007 Help File: I know, not for this particular instance, but it may turn up in a search function, if anyone uses that on here anymore. ;)

Which one Bob? :) I work in electronic manufacturing distribution. I'm also a flight instructor and airport manager.

Is that an attached txt file or just text in the e-mail? I transfer attachments in to my database from outlook with a couple macros in outlook.

Are you using the sigma (totals) button in the query, or are you trying to put the min() in the criteria? If you try Min(FieldName) in the Where you get the "Cannot have aggregate function in WHERE clause..." dont you?

When I ran into this problem, I had to make a query based on the query. Probably not the best way to do it, but with experience at the time. Or what about a filter on the form that displays the information?

Let's just say that I have no fewer than 20 tables that are on the the many side of at least two 1-to-many relationships. Oh, and I have spaces in field names, and my table names don't start with tbl and in order to view it you need a screen resolution of at least 2600 pixels wide. :D

Oh man, I am never, ever, ever posting my relationship screen shot. :D

Is the form tied to a table/query, or is it a dummy form? If the form is tied to a table/query, then the data should automatic update the table when you are finished entering. As for closing the form. DoCmd.Close

How about do it in code instead of an IIF statement?

Make the relationship 1 to many from the DVD collection --> Borrow and just have a single primary key on the borrow table. Then you should be able to delete from the borrow table w/o it coming off the collection table.