Search results

You posted your last reply while I was composing mine! If your query actually succeeded in deleting loads of records then you won't find any duplicates now because they will all have gone....I hope you have a backup copy of your original table?:eek:

What you need to do is save your "find duplicates" query and then make a new query joining the original table to your list of duplcate records. You will then be able to add in your date field to do the delete query.

I haven't worked my way through your code to work out what is wrong but what I had in mind was a lot simpler than that! Try something along the lines of: SELECT Count(Oneofyourvariables) AS CountOfX, [08/02VA].Load_Date, [08/02VA].Status, etc etc etc FROM [08/02VA] GROUP BY...

Given that you need to get the data into text delimited ready for uploading into an Oracle database, my "dirty" way of going via Excel may well be most efficient after all, as you can go straight from the Excel file to text delimited without having to go back into Access at all. The thing that...

I take it that you mean you're trying to use the "Find Duplicates Query Wizard" to work out duplicate records. You can look for duplicates without using the wizard and using as many fields as you like: Make a new query using all the fields you need to compare. Use the Group By function which...

Check that you've actually saved the query in its own right before doing a "save as". Export reverts to the data selected by the last saved version of the query - that's caught me out on more than one occasion.

I've had to do similar and the way I did it was very quick & dirty - not elegant at all. Export the table to Excel. Copy & special paste (transpose) the whole lot. Sort by what is now the first column (which now has your field names in it). Re-transpose the sorted data. Re-import into Access...

Make a query selecting the yes/no field and the text field. Turn the default "select" query to an "update" query (It's on the toolbar or in the Query menu). Put yes (with no quotes round it) in the criteria row for the yes/no field and "this is a confidential file" (with quotes) in the "Update...

Actually even my so-called smart-alec solution was not nearly smart enough and a good deal hairier than I originally thought. I was awake half the night working this one out (sad nerd), so here is the logic - if I have the time/energy & anybody is actually likely to use it I'll try coding it...

If you want a real smart-alec solution to this, displaying age in years/days, try the following: Define a field "age" in your query: age: IIf(Year(Date())/4=Round(Year(Date())/4,0), Int((Date()-[DOB])/366) & "yr " & Int(((Date()-[DOB])/366-Int((Date()-[DOB])/366))*366) & "days"...

Not as elegant as Pat's but another solution is to add leading zeros to your list: A.001 A.002 .... A.010 A.011 .... A.100 B.001 B.002 etc. This should also get the sort to work properly. Just worked out however that this is what you meant by not wanting to use decimal places into the...

I have come across this exact problem before! As far as I can see it is a "feature" of Access, and you can't solve it by setting table properties. However, I use 2 solutions, depending on the circumstances: 1. Create a query selecting all the records from your table. Format the troublesome...

I'm not quite sure what you're after - an actual product to save you writing a new database or some useful hints & tricks. For the latter I have found that the book "Access 97 Bible" contains a CD with some clever tricks using combo boxes and forms, which I have found quite inspirational (I am...

You're right - it is the time stamp that's causing the problem. Easy to solve though using the function Dateval (which only looks at the date part of the date/time), as in SELECT blah blah FROM CoA WHERE Datevalue([CoA.CoA_Date]) Between [Start Date] And [End Date]; You may need more...

Make a query that groups the County names in your table, then use the query to make your combo box. This will mean that each County name only occurs once, your table is untouched and also if any new counties are added to the table they will show up automatically in the combo box.

Yes you do need 2 queries! [To make things clearer I'm calling your main table Invoice and the one with the definitive list of names Names.] Do something like this: First query, use the 2 tables Invoice and Names, joined by payee name. Change the join properties so that you select everything...

I think I understand your question.....if this doesn't make sense I probably didn't... First make a query that simply groups your tblInventory table and get the maximum value of date (grouped by whatever else you may be interested in - I'm not sure what else is in that table: eg inventory...

Have you thought of doing it with an Iif statment? You could make a field like this: Field: IIf([EmployeeStartDate]+90>=Now()-14 And [EmployeeStartDate]+90<Now(),"Time for meeting",Null) This will print "Time for meeting" if the date falls between the employee start date and the 14 day period...

OK, how about this... Supposing your date column is called "dateval" I assume that at present you are using something like group:month([dateval]) to group the columns of your crosstab table. Instead, try group: Month([dateval]) & "-" & Year([dateval]). This will give a composite group named...

Try adding an extra row heading "year" which is the year part of your date. Then they'll be separated out in the crosstab. I don't know if that's the format you wanted but at least the years aren't mixed together any more...