Search results

You should bring the query with averages in the main query and use an iif statement to replace the nulls with the average. I just uploaded an example database for for a generic customer costs that does the same thing. Search my user name here, can't get the link right now.

I handle this with a couple if queries. Query one, customer with max of visit date (using the group button in a query) 2nd query uses query one and the table. When you join customer to customer and date to max of visit date you will only get the results from the last visit. Query 3 off of...

Don't you need a union query? It joins two tables together. Fairly easy to do. Can throw an example together if google doesn't explain it clear enough.

I think an option for the combo box event property is "not in list". So if you enter a new supplier, you can have it run a macro that opens your supplier form so you can add the supplier. Create a macro that opens the form you want and goes to a new record. Go back to the property of the...

Yes, summary queries for each table.

Yes it's only finding exact matches. As i was doing it, wondered if you'd pull from a machine with extra parts. I can try to make changes to it tomorrow if you dot figure it out.

It can probably be done with less queries, but this works. These queries first match the number of parts in each machine, both must be equal. Then it makes sure each of the parts match.

I've attached the sample.

Yes, it's possible.

For this: For any record, I need to compare the number in those 3 fields to each other, and choose the largest number and group by that rating. More if statements are needed, four for each of the three items. flam4: iif([Nfpaflammability]=4,1,0) Flam3: iif([Nfpaflammability]=3,1,0) And so on...

Sorry only three tests for the above instead of four.

I would do several queries and then join them together. First query for this: I need to ignore blanks; if 1 of the above fields is blank, they will all be blank. I would do an if statement for the values. Test1: Iif([yourfield] is null, 1,0) Repeat for all fields, and call test2, test3...

Use iif statements in Access. If customer doesn't have a match, set the customer to "generic". In the price table you should have item, price, and customer. Every item should have a customer called "generic." If you need a sample I could throw one together quickly. Hope that helps.

Why doesn't cross tab work? Another question, how many different countries. Mike Alexander has a trick I make your own cross tab in a select query but it's kind of a pain if you have too many countries.

You can create a form from the query( your search results). Your query will be the record source of the form. Instead I opening the query when you search, open the form instead. You can do all this with a Macro. Hope that helps.

Not sure exactly but I think it works this way: Brad hosts the SQL server database on a website. The website has all the back end tables for the database. The front end program is Access and as long as you can connect to the web you can use the database. Multiple people can add/edit data. Brad...

Glad you got it to work. The make table query will create a table for you. Test it out, comes in handy every so often.

Why not do an append query?

Sue, not knowing Vba in my early days I did this using several queries and a macro. My UPC code table would have the following fields. Id-auto number , UPC, used, date used. First query. Get max Id number from above table where date is null. 2nd query match the first query Id field which...

It always helps me to do several if statements in queries and build off the previous if statement. Do one at a timers get the end result.