Search results

I just add some more fields to the main table, instead of creating a new table, and then having to reference to it. So just 1 giant table is good?

Hello! I have currently 5 tables, and each one is for sales. They are as follows, tblAmazonOrders tblEcwidOrders tblVendorsMart tblEarthOutdoors tblShowSales Now, all of those are are just tables for sales, what im trying to figure out, is it okay for me to have 5 different tables, all for the...

SELECT tblItems.Model, Sum(tblAmazonOrders.quantity) AS SumOfquantity FROM tblItems LEFT JOIN tblAmazonOrders ON tblItems.Model = tblAmazonOrders.description GROUP BY tblItems.Model; That is the query for all 3 of those. EcwidTotal, AmazonTotal and ShowTotal. I also just checked (changed one)...

OK, guess there is nothing that you can do on your end to help me. No problem, either we will have to change those names, or im on for a lot of replacing :) Either way, thank you for helping me so far! Thanks!

Hello, I have that. Problem I have is in the picture, its kinda weird, never had it before. Any idea what im doing wrong?

Not sure why we do, but when we create a new product, we dont know the name till we think of one, so we just have random product till we name it, but we still sell random product. Because, like I said, I import the product sales, and they only have the product name.

I do have that, in all the tables that I can use a ModelID I have it being used. BUT, in the table that I am referring to, I cant have a ModelID because I have to import data into that table, and what im importing from has just a name of the model, and other date, but none of it useful to what...

Ok, back to square 1. The problem I have now is, I have a 22 cowboy Pistol. And I can see I have sold 200 of them. Now, if I change the 22 Cowboy Pistol to a 22 Pistol, access (and me) have no idea how many 22 Pistols I sold. So I (And I hate this to) for the time being, have to have a drop down...

@burrina I tried that, but it was really confusing me, so I just changed the GasID to the date, and I have the user just enter the date of the year if there going to be doing anything with the gas prices. Thanks for you help though!

Err....not sure how/were to use it. In a field using the builder? Or a query. Pretty sure it isn't a query. And what do I place in Me.SomeDate, Me.Somevalue and IsDate? Also, my fields for dates are ShowYear and it is a ShowYear: Format([StartDate],"yyyy") That is my field name, and as you...

Hello! I have a tblGasCost for the cost of gas, and I also have how many miles they travel, how many vehicles, and the date. I have a ID for the tblGasCost. Example. the Van traveled once, on 2/12/2012 to a show that was 20 miles away. The IRS cost per gallon for that year was $0.555, so in the...

Hey, I got (I think) the aliases working. I just need to know how to tie them all to the item ID. in the Picture 1, you can see what I have for the query, but in picture 2, nothing is working.

Question, I am trying to figure out how you did this. I can work with it, but I would like to know how, I saw you had the the Field called [Forms]![frmItems]![Frame16] and its criteria was "Is Null" and you have the other field "StatusID: Status" and its criteria is [Forms]![frmItems]![Frame16]...

The code that opens it is a macro. The macro is in the picture. Just look at the pics, should explain what you want. Not sure what you mean by that, sorry :(

SELECT tblItems.Model, tblItems.Price, tblItems.OnlineShow, tblItems.Category, tblStatus.Status AS StatusID, tblItems.Status, tblItems.FitPerSheet, tblItems.Wholesale, tblItemSizes.ModelWidth, tblItemSizes.ModelHeigth, tblItemSizes.ModelArea, tblItemSizes.ModelPerimiter, tblItems.ModelPicture...

I have a quick question, when using the search code you gave me, something is not working. I have the items in my form, and I have it so when I double click, it opens up another form to edit it. But, if I have John Doe Smith and I search for Doe, and double click John Doe Smith, it opens up a...

Thats just what I wanted, thank you very much!

I would do that through VBA or Macro? And if VBA (Or macro) what is the code? If its not either of those, then were in the settings? I cant seem to find it.

You mean "I'd" not "I've" ? And, how would have you done that?

Just looked at that (really looked at it) and im not sure it is what I want...Would it be possible to have....Maybe another query duplicate? I know that would be a waste and I probably shouldn't do that, cause any changes to the main query I would have to change on the 2nd query also....just...