Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tbonehwd
  • Content: Threads
  • Order by date
  1. tbonehwd

    Dynamically Creating Column Names in a Query

    I guess I am just having to much fun today. First off I would like to again thank PHV for helping with the following code. But my next question, I have the user entering a date on the form in a field called txtFRMDATE and the code below will report on that week and that week -1 and -2 is there a...
  2. tbonehwd

    Enter Parameter Value "What did I Miss"

    Ok this is driving me nuts on my form I have a field called txt.FRMDATE Where I am trying to enter a date and run this code however every time I enter the date I get the famous Enter Parameter Value then if I enter the date again it works fine. I know I am missing some little thing if you see it...
  3. tbonehwd

    using a String in Select As

    When using sql in vba I want to for example Select x As strTEST. I tried: Dim strTEST As String strTEST="12/04/2005" Select Somthing As "& strTEST &" Can this be done? When I try I get an Error 3141 Thanks, TboneHwd
  4. tbonehwd

    Showing 8 weeks of weekly units

    I have a table called data in it we import the weekly units sold at our customers pos stations. The fields in the table are CMT_CODE(Customer Code), WEEK(mmddyyyy this date is always a sunday), ISBN(Item Number), UNITS_SOLD, INV_ON_HAND, INV_ON_ORDER. I want to enter a date for example...
  5. tbonehwd

    Print a Report causes ReQuery

    When ever I run a report after the report finishes I go to file print and it starts running the query again. I never noticed this until I upgraded to Access 2003 and for one of my reports it takes 10 minutes to run and it seems another 10 minutes to print anyone know anything about requery upon...
  6. tbonehwd

    Question about IIF statement

    I am using an IIF statement to do a calculation based on the order number, in our system any order below 90000000 is an order and any order above 90000000 is a credit this code works perfect for other scenarios however I am now trying to create a report that will list net QTY_SHP for all...
  7. tbonehwd

    Combining three queries with missing data

    First off I would like to thank the people on here that have been so helpful I have learned so much since I started posting however when you see the mess I have below please dont laugh anyway the code below builds and execute three queries. The first is to get a list of customers by cust-type...
  8. tbonehwd

    Group by week()

    I have queries that group by year() and by month() so I just assumed that I could group by week() well I guess I am wrong. If it can be done how do you group by week() Thanks, Terry
  9. tbonehwd

    Access 2003 stops responding when trying to use Chart Wizard

    I have a query that outputs a single line Company_Name, 1st_net, 2nd_net, 3rd_net, 4th_net, 5th_net which is the past five years of net_dollars and I wanted to create a little chart for these numbers. When I try to create a chart using the wizard my cpu goes to 100% and Access stops responding...
  10. tbonehwd

    Creating a field with a specific value In a SQL query

    Is it possible to add a non-existant field and give it a value. I want to Select a field in a query that doesn't exist and make the value of that field TEST (for example), the reason for this is to later use the value to link several queries together. If it can be done how do you do it? Thanks...
  11. tbonehwd

    Select multiple records as one

    I am sure my title doesn't make alot of sense. On my form I have a combo box called cmbADVACCT the user has the ability to enter a customer account number or chose a customer by name in the drop down listing. Many of our customers have multiple account numbers for various reasons so if for...
  12. tbonehwd

    How to use current year -1

    On my form I have a place for the user to enter a from date and an end date. I want to create another query based on the date the user enters -1 year. Below is the code I currently have to get the date from the form. If IsNull(Me.txtFRMDATE.Value) Then MsgBox "You must specify...
  13. tbonehwd

    Creating a comparison query

    I am trying to create a comparison report based on the the date the user enters. For example if a user enters a From Date of 01/01/05 and a To Date of 01/31/05 I want to display the sales for the current period as well as the sales for the prior year 01/01/04 - 01/31/04. It is possible that...
  14. tbonehwd

    Error 3122 when Select Field is not in Group By

    If I use the code in the query below it works, its just not exactly what I want. I only want to Group by PROOLN_M.ITM_NUM if I try and remove the other fields in the Group By I get "Error 3122 You tried to execute a query that does not include the specified expression 'DCS_001' as part of an...
  15. tbonehwd

    Placing Text from a form on a report

    I have a form that users enter criteria to pull data from our SQL server and get an Access report with the results. I would like to add a field to the form that would allow them to describe what they ran and then place that descriptive text on the report in the header so when they print it they...
  16. tbonehwd

    Look up based on ONE or MORE

    I am curious how other people would do the example below. I currently give the user the ability to either leave the Me.cmbADVACCT blank and get all, enter an Account Number "without leading zeros" or enter multiple account numbers "with leading zeros" like '000000777777','000000601248'...
  17. tbonehwd

    Sorting of Calculated field - sum a calculated field

    If in an Access Report you can't sort on a calculated field and in a query you can't sum fields that have already been calculated then how would one do this? In my final report I want the NET_DOLLARS sorted Descending based on the select below I am getting DOLL_PUR and DOLL_RET which DOLL_PUR...
  18. tbonehwd

    Multiple JOINS cause ERROR: 3141

    I have tracked down my problem I was previously having being caused by multiple JOINs, could someone please give a direction to look in. strSQL = "SELECT PROOLN_M.ITM_NUM, PROOLN_M.DSC_001, PROOLN_M.DSC_003, Sum(IIf(PROOLN_M.ORD_NUM<'90000000',PROOLN_M.QTY_SHP,0)) AS UNITS_PUR " & _ "...
  19. tbonehwd

    Can you SUM of Calculated field?

    For example: Select Sum(ORDERS.UNITS) as UNITS_PURCH, Sum(RETURN.UNITS) as UNITS_RET, Sum [UNITS_PURCH]-[UNITS_RET] as NET_UNITS I am just curious if you can sum a previously calculated field and if so what is the correct syntax? Thanks, TBonehwd
  20. tbonehwd

    Complicated Calculation Query that involves multiple tables

    First off I would like to thank PHV and dhookom for not killing me yet :) here it goes: I have four tables PROOLN_M, PROORD_M, CDSADR_M, CDSITM_M Sample data of PROOLN_M ORD_NUM SHP_CTM OLN_STA ITM_NUM DSC_001 DSC_003 QTY_SHP ITM_NET 11119906 601248 Z...

Part and Inventory Search

Back
Top