Search results

Assuming that you want the results below then the following solution should work. Required Results User Customer Uttr1 Uttr2 xx1 Ole Olsen 3 205 xx1 Ole Nilsen 3 450 xx1 Kari Karlsen 3 570 xx2 Per Persen 1 145 xx2 Nils Nilsen 1 538 First off create a make table query: SELECT Table6.User...

First off I would recommend that you create a table to store the flat rates for the first 3 services. Just a table with Service and Charge is all you need, and enter a record for each of the 3 flat rate services. In this case service matches whatever would be in the service field of your...

Should 'xx2 Nils Nilsen 1 538' not be showing as well since he is not a repeat of CUSTOMER or of UTTR2

If the import is using the TransferSpreadsheet method then it may be that there is a range specified for the import which does not inlcude the last two columns. Changing this range to include the two columns or removing the range altogether should bring the two columns through. Check the Help...

I can't see what the problem is. What version of Access areyou using, I'm doing the test query in 97 and it works fine on the sample I've tried. I've attached the sample I have working if you want to check it. I'm afraid that other than that I'm stumped at the moment as to why it's not...

Remove the space(s) after the In; Try In([Tanslatefrom1],[translatefrom2],[translatefrom3]) Also are you missing an 'r' in the first field name.

Make sure each of the field names has an opening an closing '[' as in [field1] that there is a comma between each field name as in [field1],[field2] and that there is an opening '(' and a closing ')'

The intCntr is just an integer that I declared to use in the For Next, I could just as easily have used 'i' which one would normally see For i = 1 to 10 It just keeps track of the number that should go at the end of the name. By the way don't forget to put the 'Next' at the end like so For...

Check the following post for a possible solution that might help you. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=32034

The attached image shows a query which will search through three fields for where one of the fields matches the entered language. Thus if you enter 'English' it would find all records where 'English' is in any one of the three fields. You could work on it further to do the rest of the search...

You are using the TransferText method whereas since it's an Excel file you want to import you should be using the TransferSpreadsheet method. Try the following: DoCmd.Transferspreadsheet acImport, 8, "WorkOrders", "C:\WorkOrders.xls" Check the help file for TransferSpreadsheet for full details

This might help you.

Create a query with all the details you want to export and format the date field you have as below, then export the details from the query rather than the table. format([DateField],"dd/mm/yyyy") You can change the format to whatever suits your requirements.

Assuming you mean that if they type the keywords 'step' it would return items which contain the string 'step' at any stage in the field then use the following LIKE "*" & [Enter Description Keyword] & "*" Using 'step' it would thus return items such as stepladder 4 rung steps

I'm assuming that you are trying to blank Admin and Dept if someone selects a Division, and Dept if someone selects Admin. I have a form which is used to filter reports which contain 5 drop downs involved in the filtering of the reports: Year, Week, Region Branch, Agent. I've called each of...

You haven't actually opened the recordset. Try the following Private Sub Memid_AfterUpdate() Dim rs As Recordset Dim StrSQL As String Dim db1 As Database set db1 = currentdb Set rs = db1.OpenRecordset("Clinical") rs.FindFirst "[MemberName]='" & [Forms]!MembershipUpdateForm]![Combo16] &...

if you want to get all records where the name is one of the three, Mark, John or Kate then 'OR' is what you use. In criteria in a query under your name field enter Mark or John or Kate The above assumes of course that your name field just contains the pupils first name. If it includes 2nd...

Set the format on the field to '000000' this will display all numbers as 6 digits with leading zeros to make up the 6 digits where required. Set the number of zeros to whatever you require the display length to be. The number will still be seen by Access as it was but will display with the...

Gernerally in cases where you are formatting a date in this way it is best to format it with the year first as it helps in comparisons especially if you intend doing betweens or less thans or greater thans. Example: 082002 to 200208 If you try to find the one's between July and...

It sounds like one of the previous queries was a group query where you were summing 'goodsin'. Now it is still looking for this 'sumofgoodsin' value which is either no longer there or the field was renamed. Check the query that is prompting for the parameter for a field with Expr in the field...