Search results

This creates a list of all Order numbers that are present in the Orders table (tblOrders), and uses a left outer join and a calculated field named 'Present' to indicate whether each Order has a ProductNumber that matches a ProductNumber in the sales table (tblSales). SELECT...

Then you likely need to use one query to obtain the minimum rank for each combination of containment, date, and employeeid (do not include the value field in this query). Then create another query that is joined to the results of the first query (create an innner join on all of the fields...

Like Banana, I'm a bit lost by the original description. But if your report always has Credit, NCR, and Customer then the information pertaining to these entities ought to be in the main report itself. And information pertaining to the other entities (Invoice, Item, Tag) should be contained in...

Or alternatively, just use a pivot table...

Assuming that Sheet2 has two fields: Company_Name and Order_Number and Sheet1 has Company_name in column A: then I would simply sort Sheet2 by company name/id (Asc) and then by Order_number (Desc). In Sheet1, I'd simply use vlookup to return the value in the Order_number field of the other...

Not sure what all the extra zeroes are doing in your source table for a date field. However, if it were me I'd simply base my report on a query instead of directly on the table and convert the date in that query as you have already discussed. Or am I misunderstanding your problem?

If you mean to re-query the recordsource of a form/subform for the new records then you can use the Me.Requery vba command to force the form to requery the underlying data.

Have you tried using the Vlookup worksheet function? This should be able to do a basic lookup like you describe as long as the information is correctly sorted and organized.

First up...avoid using reserved words as names for table/query fields. http://support.microsoft.com/kb/286335 Both 'Date' and 'Value' fall foul of this principle. Something else to consider: What will you do if two records have equally low ranks within your grouping of the other fields? Do you...

And to state the obvious, you need to replace the [Date1], [Date2] part with the actual names of the fields that you're using. e.g., replace [Date1] with [Maturity Date]

Personally, I generally like the rep feature. It is one of the only aspects of the forum that encourages me to return and provide assistance anymore. (Although, I have been away for the last few months due to work commitments.) The most irritating part of it is where someone leaves you a glowing...

The way you tyically handle more than one parameter criterion in a single field is to use the In operator. Eg. In(1,2,3) would limit results to rows containing either a 1, a 2, or a 3 in that field. If you wish to use a form control to achieve that effect then I suspect you're either out of...

The general approach I'd take would be to create a calculated field that determined the absolute difference in days between the lab_date and the target date. Then sort the results in ascending order of the calculated field and select the result from the first record using either Dlookup, or...

I would imaging you'd call a custom function from the after-update event of the controls that you require to be filled out that would first check to see if all required fields have been completed, and then enable of disable the secondary fields depending on the result. Bear in mind that you'll...

The general approach you will likely need to take is going to involve using vba code in your data entry form to run an append query that will add the relevant list of Attributes to tblAttributes whenever you select a new item to test on your form as part of your audit (you will lilkely then need...

And if that fails, try something like: IIF(Sum([ValueFieldNameHere]) & "" = "",0,Sum([ValueFieldNameHere])) ...assuming you're summing the results. If you're using count or something else then replcae the sum parts with the relevant aggregate function. You'll likely need to use 'Expression' in...

Thanks George :) I'll check out the link and see what I can learn :) Cheers!

ok...provocative title I know. ;) I'm working on teaching myself php/mysql and have gotten some functional php scripts working on my local copy of WAMP. I can get query results, and do basic insert/update etc on a mysql database. The problem I'm faced with is wanting to write a php page that...

thanks for the nice comment about the post of mine which helped you. Not sure why you gave me a negative reputation at the same time though. :(

Out of curiosity, how would one go about linking a local Access frontend with a web-server running mysql with the backend database online?