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 derfloh 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: Advisedwolf
  • Order by date
  1. Advisedwolf

    Reducing RPM's on IDE interface HDD

    Hi, I have a general query, relating to two HDD's... one Western Digital IDE 80GB (P/N: WD800BB) and a samsung SP0802N again IDE 80GB, Both of these drives have an RPM of 7200k. I know that on SCSI interfaces, the RPM of the disk can be regulated so that it matches any board settings. in...
  2. Advisedwolf

    Help with calculated field

    ok great. will go with that then... at least it'll mean someone will have to actually read my report before getting to the summary's Ta! Have a great New Year!
  3. Advisedwolf

    Help with calculated field

    sorry, worded that last one wrong.... "I tried referencing the text box in the header to the footer (txtstatus)," --- sorry, Not textstatus, but the name of the box in the footer... Ta
  4. Advisedwolf

    Help with calculated field

    lovely, I see where your going with that one and it works in the footer.. i get the correct value of 428 records as opposed to the complete 865. I tried referencing the text box in the header to the footer (txtstatus), the header then producing a result of "0" .. is there no way to reference...
  5. Advisedwolf

    Help with calculated field

    in the report header.
  6. Advisedwolf

    Help with calculated field

    Thanks Tom, However, it still produces the full amount of records, Any ideas, don't know if you need any further info off me, but I can state this report is being driven directly off the main source data table (only one table), and the field name is that as mentioned. Doesn't seem the most...
  7. Advisedwolf

    Report/Email

    Thanks for your help here Ginger. You've given me a great starting point on how to achieve this. I will explore down this avenue as it sounds like an ideal solution on how i'd like this to work! Thanks!
  8. Advisedwolf

    Help with calculated field

    Hi, Am trying to write an If statement in a text box on a report. If a field matches a certain criteria, then count the records. I could easily do this in a query, but for other reasons, I would prefer to get this to work in the report itself. My expression doesn't work, as it always displays...
  9. Advisedwolf

    Deleting tables

    also, just noticed, sorry for adding this post relating to a table query in the "reports forum"
  10. Advisedwolf

    Deleting tables

    Hi, I have a database that a couple of users use to import data from Excel. This import operation is actioned through a switchboard command, as they do not have access to the database window. When these spreadsheets are imported, there are normally a couple of import errors, due to some of the...
  11. Advisedwolf

    Report/Email

    In response to the first thread, At this stage, I only have a select query created that lists all the open purchase orders. I have then created a report from this query, that has a grouping level per each vendor, this forcing a new report page on each vendor change. I wasn't sure where to go...
  12. Advisedwolf

    Report/Email

    I have a database of purchase orders. What I need to do is run a report that lists all purchase orders per supplier. Then, I need it to email the relevent purchase orders to each supplier. I.e: All purchase orders for supplier A, get emailed to supplier A, I have a seperate table, that lists...
  13. Advisedwolf

    Query On a date range

    Thanks for your assistance, however when entering this criteria [date closed]<=Dateserial(year(Date(),month(Date())-3,day(Date()) It states there is a missing ] in the statement.. I cannot see where this is missing from Sorry for delay in responding... Ta
  14. Advisedwolf

    Query On a date range

    Hi, Sounds simple, but what is the criteria expression in a query I use to display all records that are older than 3 months. I have a "date closed" field, and I need to query this to show all records closed over 3 months from "todays date" Thanks
  15. Advisedwolf

    UDATE QUERY PROBLEM

    i did try, but got a bundle of missing code errors. this is my attempt.... but get syntax errors. UPDATE [TBL - FINANCE QUERY LOG] INNER JOIN [TBL - PURCHASING LOG] ON [TBL - FINANCE QUERY LOG].[INVOICE NUMBER]= [TBL - PURCHASING LOG].[INVOICE NUMBER] SET [TBL - FINANCE QUERY LOG].[OVERALL...
  16. Advisedwolf

    UDATE QUERY PROBLEM

    Sorry, one more favour to ask. Can you look at this code for me, its a similar scenario. If the record gets rejected in the purchasing log, then the status for that record in the finance log needs to be changed to "Rejected" there too.. UPDATE [TBL - FINANCE QUERY LOG] LEFT JOIN [TBL -...
  17. Advisedwolf

    UDATE QUERY PROBLEM

    Nice One! seems to work! Thankyou for your assistance, Gavin
  18. Advisedwolf

    UDATE QUERY PROBLEM

    good point, Just tried this and it doesn't seem to work Here is a copy of the SQL statement of the update query. UPDATE [TBL - FINANCE QUERY LOG] LEFT JOIN [TBL - PURCHASING LOG] ON [TBL - FINANCE QUERY LOG].[INVOICE NUMBER] = [TBL - PURCHASING LOG].[INVOICE NUMBER] SET [TBL - PURCHASING...
  19. Advisedwolf

    UDATE QUERY PROBLEM

    Hi, I have a record status field, the options within this combo box are: Open, Closed, Rejected, Re-Opened If a record is Re-Opened, then I have an update query that updates the appropriate status in two other tables. The macro running this query is actioned upon the "On Close" property of...

Part and Inventory Search

Back
Top