Search results for query: *

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

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!

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

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

in the report header.

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

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!

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

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

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

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

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

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

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

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

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

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

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

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