Recent content by corrado

Thank you very much- I found that I was using OR instead of AND... Thanks again.. DJ

I have a query that is based on a table and have a column of data that shows completion dates of (11/15/02, 11/02/02,11/17/02, etc...) I want to prompt the user to enter in a start date and an end date and want to show any data that is included in this start/end date. I have the following SQL...

Thank you both for your replies. I will be trying both approaches. I will not be needing to change data right away but may need to change the data in the future. I am still gathering my requirements and will take these into consideration. Thank you very much.. DJ

I have a form and would like to have a drop down box appear that holds a list of values (names). I have additional columns in the form that were taken from a table which holds the (names) address, age, phone number, car, etc.. Upon selecting a name, I would like the remaining boxs to have the...

Thank you. If detected, can Anti Virus rid the virus? I will check on Wed when I am home.

I am saving .jpg files to my desktop and I can open them fine for about a day, but when I go back the next day it shows that it is now a VBscript and I cannot open it. I had a bunch of .jpg files in 'my pictures' folder and I cannot access any of them. Is there a way to stop this madness. I...

You may be able to do this by creating seperate data providers and inserting the data you need from each of the data providers. This may work; if you need calculations, you'll need to have relationships for the objects needed from each of the reports in order to create one single report.

Yes it is set as a text field. I set it to short date (date/time)and brought back correct information. Thank you DJ

It should also bring back 10 OCT 2000

I had sent out a message a few days ago and had responses, however this is still not bringing back correct data: I'm only concerned with the where clause. The [ACCOUNT Query].MAJCOM works fine. Issue: want to display only dates that are older than 1 year from todays date. (for Account.Letter...

Terry, Thank you so much- I used this below to solve the question: WHERE ((([ACCOUNT Query].MAJCOM)=&quot;PRIMARY&quot;) AND ((ACCOUNT.LETTER)<DateAdd(&quot;yyyy&quot;,-1,Date()))); Thanks again DJ

Hello terri, This is the SQL statement I have... I would like two where clauses so I am attempting to use AND operator towards the end. SELECT [ACCOUNT Query].[ACCOUNT], [ACCOUNT Query].[RANK], [ACCOUNT Query].[MAJCOM], [ACCOUNT Query].[CUSTODIAN LAST NAME], [ACCOUNT].[LETTER], [CUSTODIAN INFO...

I am trying to display (in Query) a letter date that will read the column value and minus one year from that date (that date i.e. meaning today's current date). Value(s)of Account.Letter 10 OCT 00 15 FEB 99 25 MAR 00 15 JUN 00 27 SEPT 00 01 MAR 01 I want to display any date that is greater...