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 strongm 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: dkmidi
  • Order by date
  1. dkmidi

    How to Subtract 2 Dates in a query?

    Thanks for the help Rudy! And thanks for the great solution PH, worked like a charm! Derek
  2. dkmidi

    How to Subtract 2 Dates in a query?

    Thanks Rudy! It works now.. but not sure if it's good? I kept the code the same but changed ON Start.Date = Stop.Date to ON Start.Date <= Stop.Date It worked! 53 days. But I shouldn't JOIN on Date you say? My real table has several different start stops actually and I'll need to calculate the...
  3. dkmidi

    How to Subtract 2 Dates in a query?

    Hi, I created a small table to try the code but it returned no results. What am I missing? Thanks! Derek Table: [T_Logfile] TableTest_ID Date Type 1 2005/01/01 Project Start 2 2005/02/23 Project End Query Code: SELECT Start.Date , DateDiff("d"...
  4. dkmidi

    How to Subtract 2 Dates in a query?

    Hi Everyone, I have a query filtered down to two records each with a date. The dates are in the same field, one on top of the other. (Not side by side) Example: Jan. 1 Project Start Feb.12 Project End Does anyone know how I can subtract the two dates to find the number of days between...
  5. dkmidi

    How to select most recent record update from multiple records?

    Hi! I was wondering how I can do the following: I have a table that logs different statuses for files. First I filter a column for “Leave Status” only. Example: Jan 1 Bob Pending Leave Status Feb 1 Bob Off work – planning Leave Status Mar 1 Bob At work – Temporary Leave Status Apr 1 Jim...
  6. dkmidi

    How to filter for records with more than 1 entry?

    Thanks for all the help! It works now. I couldn't understand the SQL to wrap it up nicely in 1 query so I created 2 queries as suggested by dhookom. Here's the resulting SQL from SQL view. DQ_Filter Query 1: SELECT T_Leaves.Staff_Id, Count(T_Leaves.LeaveTypeId) AS CountOfLeaveTypeId FROM...
  7. dkmidi

    How to filter for records with more than 1 entry?

    I'm sorry PHV.. I'm a beginner at SQL. Where does table B come in because I only have 1 table. :( SELECT tblEmployees * FROM tblEmployees WHERE 1<(SELECT Count(*) FROM tbl?? WHERE ??.EmployeeID=tblEmployees.EmployeeID); I don't quite get where the tblB comes in. Thanks for your help! Derek
  8. dkmidi

    How to filter for records with more than 1 entry?

    Hi, I have a table for Employees where the EmployeeID is sorted Ascending. How can i just have the EmployeeID records with more than one record shown? I don't want the EmployeeIDs grouped but need to see the unique entries in another Comments column. All I could think of was to Count it but...
  9. dkmidi

    Exporting Access Query to Excel

    Can anyone help? I'd like to know how to program a module in Access to do the following: Save two Access queries to specific tabs in an Excel spreadsheet. Example: Open Excel workbook myData.xls Run module to save myQuery1 to tab myQuery1 in myData.xls. Close workbook. Run seocnd module to...
  10. dkmidi

    2 Column Output on Access Form?

    Hello All! Is it possible to have an Access form output information side by side in 2 columns on the same page? Ie. A telephone address book where on the left hand side it lists the names starting with A, then B, C, etc.. then once it reaches the bottom of the page continues on the second...
  11. dkmidi

    Customize Access html Templates?

    Hi there! Does anyone know how to customize an Access Template's display? ie. colours of the table header, the table border, table content font.. I can adjust the background properities in the <body> tag but any ideas how to format the table itself because access generates that. Below is a...
  12. dkmidi

    MsgBox to Enter Criteria for Report

    Hi Everyone, I've seen this done with another persons reports where a msgbox pops up asking which month's data they would like to see. How can I do this too? Is it done using the original query that the report pulls the data from? Thanks! Derek
  13. dkmidi

    Hi! Can anyone please explain which

    Hi! Can anyone please explain which actions/scripts to use in order to generate a movie clip that appears randomly on the stage for x number of times? ie. a movie clip fades in and fades out in 3 random locations and then stops. Thanks! DK
  14. dkmidi

    Calculate a value from 2 fields to a 3rd field in same table.

    Thanks all! All your help has been very useful... a query calculation it is then. Thanks again! DK
  15. dkmidi

    Calculate a value from 2 fields to a 3rd field in same table.

    Hi there! I set up 3 fields: wage1, wage2 and avgWage. How and where can I set a formula up so that the avgWage field will automatically calculate the avg value for wage1 and wage2? All three fields are in the same table. Is this possible? I've been trying to stick an expression in the...
  16. dkmidi

    Suggestions to handle Dates? Text or Date/Time Data type?

    Wow! Thanks Bob for the great explanation and the little tricky things! Much appreciated! DK
  17. dkmidi

    Suggestions to handle Dates? Text or Date/Time Data type?

    Hi all! I see that the sample databases that Microsoft offers all use the Text datatype for things like phone numbers and dates. But wouldn't it make more sense to use the Date/Time data type for dates? Is there any difference in how it sorts or what things you can do with one data type that...
  18. dkmidi

    Need help refining code/expression to fit into query design.

    Hi Dalchri! I'm trying out your suggestions but everytime I do something like <Expr> As ExprName it displays that table in the query output though right? How do I use this method to store long expressions but also for them not to show up in the query output as a field column? Any other ways...
  19. dkmidi

    Need help refining code/expression to fit into query design.

    Thanks dalchri~!! Great suggestions. I knew I had a lot of repetition that could be simplified but didn't know how to do it. I'll work on my code and let you know how it goes. Thanks again! DK
  20. dkmidi

    Need help refining code/expression to fit into query design.

    Hi Codemasters! I have this expression I'd like to put into my query but since the query has 2 tables it pulls info from I have to put the table name for each field! Can anyone either help me to refine my code or teach me how I might be able to do this through vb dynamically? The expression is...

Part and Inventory Search

Back
Top