Search results

Thank you arnelgp! That really, really helped shorten the code! Thanks again! Yes, I do.

So, no one has any ideas? Ive been thinking, looking up, and I still cant find any way reason its not.

I fixed it I think. All I had to do was change it from GROUP BY and/or SUM to LAST. That seems to have gotten me all the data I wanted, as I wanted it. I think

Ill just give you a quick example. I have a 22 Pistol that sold for $5. But, the retail price is $6. What I want is the wholesale, and the only way to get wholesale cost, is to first figure out the retail cost. So, I would change that $5, to $6, as that is the retail price. I should start...

You are correct, but when I change it to sum, it gives me a odd number. $38.41. I have no idea what that is. That is also, the wrong number, but with the correct amount of records. One step closer.

Hello! I currently have: Work: IIf([Date]>[RStartDate] And [Date]<[REndDate],[RCost]*[Quantity],[Price]*[Quantity]) What is supposed to happen, is I have a retail price per item, and a default price per item. We have change the retail price in the last couple of years mulitple times, so I...

I have a Very, very long code to do as follows: Private Sub Show1_Label_Click() '====================Each click the multiplication factor is increased by 0.25======= If Me.ShowOne = "3" Or Me.ShowOne = "One" Then Me.Text34 = Me.BaseShow * 0.5 Me.ShowOne = 0.5 Me.Show1_Label.Caption =...

Hello! I have a form, and in there is a couple of text boxes, and labels. I want the user to click on the label, and I want Private Sub Show1_Label_Click() Me.Show1 = Me.BaseShow * 15 End Sub But, when I click that, only the selected record is updated. I have 60 records, and I want the user...

I see your post, and I raise you one :) Okay, I didn't know that the table had to be IN the query to use it. My problem is, I want to be able to change a number, and I want that query to get its multiplication from that number. But, I want to not have to change that number in the query. Is...

tblitemwholesale is per item wholesale tblWholeSale is the wholesale if the date of the item sold is not in between the tblItemWholesale Start and End date.

Yes, I tried using the expression builder. I tried to get the number from the main table, and the form. Using the expression builder. I'm really confused why it isnt working...I tried Text, Number (all field sizes and formats for number) and Currency. When I tried each of those, the query (or...

The code that @arnelgp posted has not helped. I still have the same problems I described in the very first post. I am pretty sure I had the first post down pretty good. I explained what was wrong, the field, and what it says. And what I would need to fix it.

When I go to run the query it asks for a parameter value. That is not what I wanted.

Expr1: IIf([Date]>=[WStartDate] And [Date]<=[WEndDate],Format([GrossSales]*[WCost],"Currency"),[GrossSales]*Nz([tblWholesale]![WholeSale Percent])) That also doesnt work. Expr1: IIf([Date]>=[WStartDate] And...

Any luck? I'm trying, but it still wont do it. Even when I try to reference to the table its getting its numbers from.

That is still not working :( Im not sure why though...I have 1 form, and in that form, is the text box, and that text box gets its records from one table. So, it should be doing everything fine. Im just not sure why its not...

SELECT qryItemsSold.Show, tblItems.Model, IIf(([Date]>=[WStartDate]) And ([Date]<=[WEndDate]),Format(([GrossSales]*[WCost]),"Currency"),Format(([GrossSales]*[Forms]![frmWholeSale]![Text2]),"Currency")) AS Gross, qryItemsSold.Quantity, qryItemsSold.Date FROM (qryItemsSold LEFT JOIN tblItems ON...

Got it! Thanks!

Private Sub lstShows_DblClick(Cancel As Integer) If Me.lstShows.ItemsSelected.Count > 0 Then MsgBox "Select a show please" Exit Sub End If If Me.Check30 = -1 Then DoCmd.OpenForm "frmEventsEdit1", , , "EventID = " & Me.lstShows '.Column(0) Else DoCmd.OpenForm "frmEventsEdit", , , "EventID = "...

I added that but its not doing anything, just erroring, showing the message box, and not opening it.