Search results

So, I have a table with 3 columns. Item____Cost1___Cost2___Cost3 One_____$10____$14____$2 Two_____$3_____$17____$15 Five_____$1_____$6_____$7 What I would like to do is get something to get me the top of those. That something can be a query or a SQL code. Anything in access will work for me...

Work: IIf([RT ID]="Amazon",IIf([RT Fulfillment Channel]="Amazon",0,[RT Gross Sales]+[RT Shipping Cost Received]/[RT Quantity]*0.15*[RT Quantity]),0) I am trying to get that to work, but I am getting an Overflow error. No idea why. Does anyone have any idea why? Thanks!

Hello! I have 3 tables, and each table (for reasons) has individual sales, quantity, etc, etc. Now, how would I combine each of those into 1 total? Each of those has a different ID, and I have a query that has all those IDs in 1 query. I just don't know how to have the totals in 1 column of 3...

As the title says, I would like to know how to change list boxes multi-select to either A: Simple or B: Extended. Also, through VBA. I have tried: Forms("Order Entry").Controls("Country").MultiSelect = 2 ' Extended. and that doesn't work. Gives me a Run-time error 2448 Thanks for the help!

In this post, I would like to know HOW to stop a query for running. http://www.access-programmers.co.uk/forums/showthread.php?t=283902 In that post, I apparently mistyped my first question, so it was taken in the wrong context (in NO part to the responder(s)) What I want, is the have to data...

In excel your able to turn of the calculations from running, unless the user specifies to. Is that possible to do that with access? Thanks!

As the title says, I am trying to save a .txt file as a .xlsx file. I have looked around a lot before asking this, and I cant find anything that is working for me. The path for the file would look like this: Dim FilePath As String FilePath = Dir("C:\Users\Joshua\Downloads\!Import Sales From...

Hello! How would I go about importing .xlsx files? I want a code that would do this. Something the user can just click, and it would import him the .xlsx file. The way im getting the .xlsx file is from this code: Private Sub Command10_Click() Dim csvFile As String Dim txtFile As String Dim...

Hello! I have the following code: Private Sub Command10_Click() Dim LWordDoc As String Dim oApp As Object 'Path to the word document LWordDoc = "C:\Users\Username\Downloads\" & "order_export_" & "*" If Dir(LWordDoc) = "" Then MsgBox "Document not found." Else...

Hello! I have this query: Work: First(IIf([Date]>[RStartDate] And [Date]<[REndDate],[Price]*[Quantity],[RCost]*[Quantity])) And I will explain what I want it to do, and upload a small database so you can see what it should do. If you open the database, you will see the qryItemRetail. That is...

Hello! I have a tblShowSales, and it has sale dates, gross sales, and quantity. I want to get the totals of those by date, but I want ALL the dates. So, lets say I have 2 sales as follows: Quantity-Gross Sales---Date 1---------$9.97--------- 11/2/2015 1---------$9.97--------- 11/4/2015 I want...

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...

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...

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...

Hello! I have a list box, and if the user doesnt select a show and double clicks on the top of the list box, then it gives the whole Run-time error '3075': Syntax error (missing operator) in query expression 'EventID = '. Now, what I would like to know is there any way to block that error...

Hello! I have lots of shows, and each show has dates. A start date and a end Date. I am trying to figure out how to get access to show me days per show. For instance, if the show start on 6/1/2015 and ended on 6/4/2015, when I create a query that shows that shows dates, and lets say the gross...

Hello! I have 2 fields, Start Date and End Date. I am trying to figure out the "true" days between them. The problem is, im using date diff, but most of my days have other dates that happen on the same, or during the other show dates. Am am trying to figure out, how many days do we "truly" go to...

Hello! I have a subform that has my daily sales per show, and what im trying to do is, click a button, and have it copy the daily sales for that show, so I can easily paste it else were. I know its possible, I just dont even know were to start looking to begin. I looked some, and the problems...

Hello! I have lots of items, and each item has a label for it that I can print out. What I would like, is that I can have a command button named "print labels" And when the user clicks that, it prints the correct label for that gun. How would I go about doing that? I also have around 80 items...

Hello! TRANSFORM Sum(qryItemsSold.Quantity) AS SumOfQuantity SELECT tblItems.Model FROM tblItems INNER JOIN qryItemsSold ON tblItems.ModelID = qryItemsSold.ModelID WHERE (((Format([Date],"yyyy"))=[Forms]![frmreports]![Text22] Or (Format([Date],"yyyy"))=[Forms]![frmreports]![Text24] Or...