Search results
-
J
Returning Sum Only in Report
Thank you for your reply. I just figured out the summing in the query and have the following. SELECT [Forms]![BetweenDates].[StartDate] AS ["Start Date"], [Forms]![BetweenDates].[endDate] AS ["End Date"], Sum([Food Sales]) AS ["Total Food"], Sum([Liquor Sales]) AS ["Total Liquor"], Sum([Beer... -
J
Returning Sum Only in Report
I am trying to transfer all of my excel bookkeeping data to a access db. I have the table built will all of the data in it. My columns are as follows: ID, Date, Food Sales, Liquor Sales, Beer Sales, Daiquiri Sales, T-Shirt Sales I have a form where you can select two dates and it will run a... -
J
Query to search all columns and rows in a table
A little more complicated than that Im affraid. Depending on the event sometimes there is just 1 team per a row other times there could be as many as 4. Everywhere there is a team listed there should be a score. The search would have to be something like this. If there is a value present in... -
J
Query to search all columns and rows in a table
The problem is that this is the best way to structure the table. Please look at this thread. http://www.access-programmers.co.uk/forums/showthread.php?t=178144 -
J
Query to search all columns and rows in a table
I need a query that will search all the rows and columns in a particular table. The Table has the following columns: Sport1 Team1 Score1 OpScore1 Sport2 Team2 Score2 OpScore2 Sport3 Team3 Score3 OpScore3 Sport4 Team4 Score4 OpScore4 The sport and team data all come from the same table so... -
J
Using a Form to query data and enter a price into a data table
I understand that calculated values should not be stored and I think that I have my data as normalized as i need it to be for what I am trying to do. My big problem is how to enter the scores into the table after the bet has been entered and the game has been played. The simplist way I can... -
J
Using a Form to query data and enter a price into a data table
1. I was hoping to not keep track of who the oposing team is. 2. I'm confused as to where this is going the way you are showing me. Can it not be done the way I described. Search table for all teams that do not have a score in there score column. Then update the table with the appropriate... -
J
Using a Form to query data and enter a price into a data table
Attached is what I have completed so far. I'm affraid that I have only done the easy part. I can log all of the data. But I need a way after the game to enter the scores so the db can figure the winners and losers. My thoughts would be a form that would show you all of sport and teams that... -
J
Using a Form to query data and enter a price into a data table
That is pretty much how i had it structured. Here is the problem. Lets say a 3 game parlay is placed. The bet would look something like this. SPORT TEAM BetType LINE OVER UNDER NBA __Bulls __Line ___-7 NFL __Jets __Over _______44 NFL _Giants _Under _____________39 For the customer to win the... -
J
Using a Form to query data and enter a price into a data table
I'm getting a better understanding I would like to send you the real db if possible. I see where everything has a ID number associated with it and that is what is being passed around. Still a little confused. Currently there are 5 tables. Sport Teams BetType Customers LoggedBets I think the... -
J
Using a Form to query data and enter a price into a data table
I have learned from other post that I have made that some people are against gambleing. So the relation is that 1 of the things i need my db to do is similar to the other post if you replace type with sport and model with team and price with score. Now that the cat is out of the bag maybe... -
J
Using a Form to query data and enter a price into a data table
I have no idea where to go with the code. As for the normalization, I went and read about it and I think I understand, but i am in way over my head with what I am working on. Breif explanation if you do not know about sports betting. You have 2 main types of bets Over/Under and Line. Over/Under... -
J
Using a Form to query data and enter a price into a data table
I have updated the db. The first 2 combo boxes work correctly but the 3rd one is not filtering the results correctly. The 3rd combo box should only show results that match both combo box 1 and 2. I have also tried to tinker with the text box. The data that is entered into the text box... -
J
Using a Form to query data and enter a price into a data table
There is a sample db attached. I have a table with the following columns; Sale# Type Model Price Date I have a form with 3 combo boxes; Date Type Model 1 Text Box Price Command button Enter Price The combo boxes should not have duplicates in them and should narrow selection base on box... -
J
Duplicates in a drop down box
Got it. Thanks SELECT [Logged Sales].Date FROM [Logged Sales] GROUP BY [Logged Sales].Date; -
J
Duplicates in a drop down box
This makes a little more sense but my data table is seperated into 3 columns. Date Item Price Do I still need the data query? -
J
Duplicates in a drop down box
Here is what I have now. SELECT [Logged Sales].Date FROM [Logged Sales] -
J
Duplicates in a drop down box
I forgot to mention I am a novice please explain string -
J
Duplicates in a drop down box
I have a table that has a list of dates. Most of the dates are listed multiple times. example 1/1/09 TV 399.95 1/1/09 TV 185.99 2/5/09 TV 133.99 1/1/09 TV 222.99 I need a list box in a form that will let me select a date. From the data sample above there should only be items in...