Recent content by RainX

Hi all, I currently have two strings that look like this 070707 and 020709. What i need to do is compare these two dates and see which one is greater. Is there any easy way to do this since the year is just yy instead of yyyy? Thanks in advance

Worked perfectly! Thanks alot

Hello all, Is there anyway to create a table from a query like you can in oracle? i.e. Create Table [B_match] AS SELECT * FROM [B_All] Take care

Thanks keith. That works!

Hi all, Is there any way to open an image (Whose path is stored in a text box) in ms paint or internet explorer when one clicks on a button within a form? Take care

Hi all, I'm trying to export a query into a text tab delimited file by using DoCmd.TransferText acExportDelim, "ImportSpecx", stDocName, File_Path, Yes I've also tried DoCmd.TransferText acExportDelim, "ImportSpecx", stDocName, File_Path, True But none of these export the Query Field Names...

bump.. anyone?

I believe the precinct type is number. Would that cause a problem? Take care

That didn't work either. Weird eh? Thanks once again for helping me in trying to figure this out.

Thanks ill give it a try! Well its still showing up as No Results Found. If i change HAVING ([o.precinct] LIKE '72*' AND (o.type='62')) To HAVING left([o.precinct],2)=72 AND (o.type='62') it works fine though. Any idea why?

^^ Thanks for replying. I changed that but its still showing up as empty or 0 for the record count Do RecordSets Allow the criteria LIKE to be used as the source?

I have a recordset and the problem is that it isnt counting the records for two of the 3 queries at all. Basically the RecordCount is 0 when it really isnt Here are the two it isn't working for SELECT s.idnum,s.precinct,s.grp, s.direction as...

Re: Optimization Thanks i've indexed those fields and it sped it up a little, but its still pretty slow. I tried splitting it into two queries as well but that ended up taking alot longer. I dont understand why though. If i run the queries by opening up the form and choosing the selections from...

Thanks for the tip but changing the like to equal doesn't make the query return anything because (Sosx.[Voting History Combined]) looks like this 073N4N061N2N053N4NN041N2V033N4N and [forms]![SOS Report Generator]![Combo2] looks like the voter code pattern mask in the VC table i.e. *021P* Any...

Hi all, Let me first setup how i accomplished this particular query, and then you guys can help me with improving it. I currently have a search form which has 4 combo_boxes each based on a query ---- * Combo1 = "SELECT [EMY].mmmyy, [EMY].Description, [EMY].Primary, [EMY].[Pattern Mask] FROM...