Recent content by Infinite

Look at the attached image. I'm not sure how I can change that to any other format... And that table is the one I'm using for this query as the rest of my data is kept in separate tables like tblShows, tblShowCost etc, etc. I just have an append query running and making me the table I'm using...

Ok, I do have more than 3 columns. I have about 17 of them, and I want to get the top 3 and display them in a message saying "You lost money because of Cost1, Cost2, and Cost 3. But mostly Cost1." Pretty sure I shouldn't make an IFF statement longer than 3 IFFs ;) The attached image is what I...

I am going to bed now, will try all those in the morning. Thanks for the help! I'll let you know tomorrow if it works! Thanks!

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

That was the problem. There was about 15 records that had 0. After changing/deleting them it now works. Was about to smash my computer after the 10,000th time if seeing the Overflow error.

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!

for "good" reasons :) I didn't say good because I know it's not the correct thing to do. Thus, it's not good, but, it is "reasons" for doing it. I have decided to split a certain part of my sales into 3 different sections. 2 different (maybe 3) online venues, and 2 physical stores. And now...

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!

Well, the 8 days was a overstatement, I meant that as a example, that way people dont...Well, im not sure, it was just a large number. But the only known way is to just create a table and import it? Is that the only known way? If, so, I guess I will have to create a bunch of tables then :(

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

Thing is, that is the easy part. What I want, is the have to data already, and if I want the most recent data, then run the query. So lets say I have a frmQuery, and it is based off of qryQuery. But the qryQuery takes 8 days to run, so I only want it to run once, and see the data in frmQuery...

How would I do that?

Well yes, I could just turn it into a append query, and append it to a (for instance) tblQuery1 instead of qryQuery1. But that quickly gets cluttered.

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!