Search results

Hello, I have a tblShowCosts and in that has the Event ID and the Show tax rate. In my tblShowSales I want access to take the subtotal and times it by that shows tax. Not sure how to tell access if the Show name = such-and-such then times it by the Tax Rate. This sounds easy, and im sure it is...

I looked at that, and I have no idea how I would integrate that into what I need.

I want the user to be able to look at the all the sales, then at the click of a button, just look at the sales per day.

Hello, I have a list box that has lots of results (shows) and I have a macro set to open them upon double click a macro runs and opens up another form that has the details about the show. In the attached image there is the macro. The problem I have, is I also have a search...

Hello, I have 4 query's, each of them having the SQL code of: SELECT tblShowSales.EventID, tblShowSales.Date, Sum(tblShowSales.Quantity) AS Quantity, Sum(Nz([Gross Sales],0)+Nz([Tax],0)) AS [Total Sold5] FROM tblShowSales GROUP BY tblShowSales.EventID, tblShowSales.Date HAVING...

Ok, I looked, and I cant find anything that is helping me.

Hello! I was wondering if its possible to change a query, using VBA. I want to change this: SELECT qryAdminEvents.EventID, tblShowSales.Item, Sum(tblShowSales.Quantity) AS SumOfQuantity, Sum(tblShowSales.[Gross Sales]) AS [SumOfGross Sales] FROM tblShowSales INNER JOIN qryAdminEvents ON...

Yes, I did it, and a couple others I found. No idea. But, I can see what you mean, I should plain on what I want, then do it.

Ok, after looking at that, I should be using the Relationships tab under Data Base Tools, correct? Because, that could be some of my problem, seeing as I dont ever use it. Also, how long does it take one to normally learn access, and be able to create a data base? And some questions about the...

I would like to know, if all I wanted to do was impute date and not fix the errors, and im the only one doing the date base, how much do I need to do? Now, I plan on doing it, but, I would like to know, how "bad" is it really if all I want to do is use it myself? Again, I defiantly plain on...

I know, just got a ways ahead of my self sorry about that. Also, meant to respond earlier, but I have been a little busy. Ok, what I did in the time I had was remove the tables TblStatus, tblCategory. tblOnlineShow and tblShowType. I am pretty sure that is what you guys wanted done. I also...

Ok, im thinking that I could just set the code on load to load certain labels to a certain type. So, it would look like Private Sub Form_Load() Label22 = "Booth" Label23 = "Electric" Label24 = "Other Fees" End Sub Would that work? It would take a TON of code, and I would have to change it...

Ok...I really, really dont want to have to ask this question, or any for that matter. The question is, how do get access to enter Booth as the CostType after I enter X amount of dollars on my form? The posts on the other thread didn't have this question, nor answer. Are the pictures how it...

Sorry! Going to go read it, and try to do it all. Sorry again.

With the tables tblStatus (Should be tblItemStatus) should I change that and tblCategory to any thing? Or are those fine?

Ok, so, I wouldn't make a new table, just change my current ones setup. Just noticed, is Cost_ID a PK auto-number? If so, that is...better then my current one :) Also, were would I get the CostType options? A drop down menu? Most likely not...Or would it just auto choose when some one enters...

Re: http://www.access-programmers.co.uk/forums/showpost.php?p=1423548&postcount=2 If I understand you, I should have a field that is (like in the example) costID and in the cost ID I have...lets say, booth costs, and the id for booth costs is 1. so I should have...

In that attached .zip file, I have my data base, and I im needing help with my tables. I am now going to be naming the tables and telling you what there for, and you can tell me what im doing wrong here. (I will not be including forms or query's, as I dont think those are needed) Starting from...

Ok, the thing that I need, is I can have just a table named item, and in that table, I can have the all the items in it, BUT, I want to be able to import all of my items into it. Not just copy and paste it. But, I am seeing that that is not going to be a viable solution for what I need. So, I...

So...what does that mean? I...er, not sure that you mean. I should have 1 table, with lots of fields, but...I should...Confused here, sorry.