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!

  • Congratulations bkrike 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: EPBoone
  • Content: Threads
  • Order by date
  1. EPBoone

    The natural order of things......

    I am not even sure how to explain this, but I will try. At the end of each week I have to send to each individual customer, a list of all the requisitions that they ordered for the entire week. This list provides the customer with Req. #, Material ID info, Quantity, and the latest status...
  2. EPBoone

    Displaying query results on a form/report

    Is there a way to display the information that the user has to enter to get results from a query onto a form or report? Huh?!?! I mean, say I have a query that asks you to type in a date ('Between [Date] and [Date]'). Is there a way to have those entries displayed on the form or report that...
  3. EPBoone

    Same query information, different results.

    Alright, I have ten different queries. Here is the SQL for one of them. SELECT [DCU LOG].[Doc#], [DCU LOG].JCN, [DCU LOG].[PART NO], [DCU LOG].SERNO, [DCU LOG].[JD T/I], [DCU LOG].MCN, [DCU LOG].PC, [DCU LOG].STATUS, [DCU LOG].REMARKS, * FROM [DCU LOG] WHERE ((([DCU LOG].[JD T/I]) Between...
  4. EPBoone

    Multiuser Form

    I have a form that is used to edit and print out records. To print a record, you have tag a check box so that when you print, it will only print the records that are tagged. If two people are using it, then it will print the records that both people have selected. How can I set it up that both...
  5. EPBoone

    Date format

    We use a Julian Date for just about everything where I work. How can I format the date for this? For example, a Julian date for March 16th, 2001 would look like: 01075. 01 being the year. 075 being the day of the year.
  6. EPBoone

    Reports and forms based on several queries and/or tables.

    I feel a little stupid with this one, but I have tried just about everything I know (which isn't much), and I cannot get this to work the way I want it to. I have a form: 1348-1 which is based on a query: Q-1348-1. The query is getting information from three different tables: DCU Log, ICRL-1...
  7. EPBoone

    Editing null values from Dlookup result in Form

    On my form, I have several fields that are updated automatically with fields from two other tables by using Dlookup in the control source of the fields in the form. The problem is, when a null value is returned to these fields, I need to be able to manually input the information, but I can't do...

Part and Inventory Search

Back
Top