Search results

I have 3 tables tblAccountNumbers tblAccountValues tblAccountFees I need to build a query that pulls the account value for each account number and pull the correct % Fee. The account fee that is getting pulled in from tblAccountFees should be the fee that has an effective date that is <= to...

I have an access db that has the following tables Symbols Prices Transactions The symbols table shows all possible symbols SYMBOL A B C D E The prices table shows closing price for all symbols for all dates DATE SYMBOL PRICE 9/30/2020 A 1 9/30/2020 B 2 9/30/2020 C 3...

I've attached a sample DB and a spreadsheet which shows what the Query results should be. I've been banging my head against the wall on this for several months now. I don't know if i have a major design flaw or if i just don't know how to write the Queries. There is a user form and the user...

I've attached a picture showing a basic view of the 2 tables and how I would like the query results. I have tblAccountValues and tblFees I want a query to return all the AccountValue info and Fee info for all the AccountNumbers on a given date. This part i can do, where I'm having problems is...

I have a table, tblFees, that has the following columns: ID = AutoNumber AccountNumber = 8 AlphaNumeric digits FeeChargedEffectiveDate = Short Date DateEntered = Date and Time I'm using the following to count how many times an account number chosen from a user form appears in the table...

I've got a user form with the following cboNewOrExist = combobox for selecting New Relationship or Existing Relationship txtNewRel = text box for entering New relationship name. cboExistRel = Combobox for selecting Existing Relationships txtNewRel is only visible if cboNeworExist =New...

I have a db with a couple of tables. Production ID, Date, Bucket, Revenue Production Calendar ID, Start Date, End Date, Business Month, Calendar Year Our monthly business does not go on calendar months. It ends on the next to last Friday of most months. I created the Production Calendar table...

I'm using Access 2010 and making a web database for sharepoint. This is my first time with this and with the elimination of many of the features i'm use to it is taking longer than I expected. I have a table with Employees listed in it. That table has a check box field for Active or Inactive...

I'm continuing a post that I had under Queries but it turns out it is a table issue. Link to other post:http://www.access-programmers.co.uk/forums/showthread.php?p=1228190#post1228190 I have created 4 tables now tblPOS tblOpenClose tblBartenders tblBartenderTips tblPOS has the following fields...

I have a db with just 1 table. The Headings in the table are as follows: ID Business Date Food Sales Liquor Sales Beer Sales Daiquiri Sales Wine Sales T-Shirt Sales Tax Comp Disc Visa American Express Discover Master Card Cash Paid Out Cash Paid In Total Cash Donation Gift Certificates Open...

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

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

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

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

Is it possible to use a update querry to enter data into a particular column. For example the table has 10 rows. The first column is autonumber the second is Product. The third column is the one I would like to update. It will be updated with a 1 or a 2. The products are tv, stereo...

I have a table with 4 columns. ID Date Category Product Price The table has information in the first 4 Columns. I need a user form where you can select a particular; Date, Category, & Product from the table. Then have a text box where you can enter a Price. There will be a Command...

I have a table with many columns; Master, L1, L2, L3, L4, P2, P3, T3, U, . The Master column will have entries of 1-8. If the Master column is 1, then the report needs to pull column L1. If the Master column is 2, then the report needs to pull column L1, L2, & U It goes on like this with...

I have the following code of which I have a button on a excel worksheet that is supposed to email the active sheet. I can get the email. I can even get attachments. I just can't get it to work properly with the active sheet. Any help would be greatly appreciated. Thanks Sub SendMail()...

I have a table with the following columns Type, Sport1, Team1, Score1, Sport2, Team2, Score2, Sport3, Team3, Score3, Sport4, Team4, Score4 If Type = 1, 2, or 3 Then there will only be information in Sport1 and Team1 If Type = 4 or 7 Then there will only be information in Sport1, Team1, Sport2...

I have a db with 9 different forms all very similar. Each of the similar forms has a log bet button on the bottom of each page. When i open the db up and go to click log bet it returns a event procedure error. When i open vb up it has the code open for 2 forms; line and under. If i close...