Search results

Fifty2One, Thx for the input, i had not thought of linking to the file, however, that could offer a solution. Rgds Growlos

Hi, Is it possible to selectively filter the records in a csv file when importing into an access table, ie, only specific records from the csv file are imported ? I have a large number of csv files each with a large number of records and most of the data is not required. There is one...

Leigh, I will create a table containing the current rating and previous rating per row using your 1st query. Once I have the new table I will create the comparison values +R... etc from that. To run the query for individual horses would be a bit of a pain as there could be approx 10,000...

LPurvis, Thx, I am using your query code to get the current and previous rating, now you have provided the code for that I should be OK with the comparison. One point, the 1st query is taking quite a while to run, I had approx 280,000 records and the query is still running. Does that sound OK...

Hi, Would anyone please be able to assist me with some VBA code to be used in an access database ? I have an access table containing the horse name, the race track, the date and the official rating that the horse performed to on that date. I hope to be able to compare the rating achieved on...

Thank you for the replies, I will be able to get it to work now. Rgds Growlos

Hi, Could anone please help me with the VBA code for a "Not Like" comparison ? I get an error when I try to use the "Not Like" comparison If Range("A" & i).Value Not Like "CLOS*" Then If I use <> "CLOSED" And <> "CLOSE" And <> "CLOSING" then it all runs OK, however I would prefer...

Hi, Would anyone please be able to help me with some VBA code to repetitively clear the contents of a cell range in an excel worksheet subject to some values in other cells of the same worksheet ? In cell E2 I have two possible values, "In Play" or "Not In Play" (quotations marks only for...

David, Thanks for the reply and explanation, I had forgotten about the field size for the text fields and there were quite a lot of those, no wonder it failed. I ended up using the append option as you suggested to create the table and got it to work OK that way. Rgds Growler

Hi, Would anyone please be able to let me know if there is a fix for a message I get when running a make table query. The message is "Not Enough Space On Temporary Disk". The make table query uses a union query as a data source and the union query is taking data from two tables in two...

Thx for the replies, I will try the ALTER COLUMN option as I need to update the field at this point rather than have the numeric value cascade through to other tables that are relying on a text value. Thx

Hi, I have a field in a table that is refreshed from external data that gets refreshed as a number field. Can I use a "Data Definition" SQL specific query to change the field format to text. If it is possible would anyone please be able to illustrate the SQL query structure by way of an...

namliam, Thx for the reply and reference to the topic using queries as a solution. I have managed to get the single records to split into multiple monthly records by adapting the queries in the solution you provided for "Tinynoo". However, I have not managed to get the [Cost] value to be...

Hi, I was provided some code in response to a topic I created in the "Queries" forum where I asked the following: Is it possible to create a table containing multiple records from a date range in a single record where the multiple records show the monthly splits of the single record date...

Thanks for the replies and the solutions. Rgds Growler

Hi, Would anyone please be able to help me with a query to remove all spaces between data stored in a text field? For example: 08 CG 52 should convert to 08CG52 07 FR SR 56 should convert to 07FRSR56 Ther is no uniformity to the data, ie, there could be 2, 3, 4 or more blocks of info in...

Hi, Is it possible to count the number of distinct values for a field in a query using the query grid and a function/formula? I have a field that contains some duplicate values and rather than count the full list as "Count" would do, I hope to be able to obtain a "Distinct Count" of the...

Rich, If you do not mind, I need a bit more assistance with a closely related topic. In my same report as discussed above I also have a column consisting of feedback values re course satisfaction etc. I tried to apply similar syntax to get an Average using the below formula in the control...

Rich, Many thanks, that worked a treat. Regards

Hi, Would anyone please be able to help with a conditional total in a report? What I wish to do is to total the values of a report numeric field only if the value of another text field equals a specific value. For example I have a monthly breakdown in numeric values of a training program in...