Search results

sorting a text date changed to date by CDate I tried to make another field in the query using just the changed date. SELECT PBOWES_LMS_DR_ILCTRANSCRIPT_VIEW.LASTNAME, PBOWES_LMS_DR_ILCTRANSCRIPT_VIEW.FIRSTNAME, PBOWES_LMS_DR_ILCTRANSCRIPT_VIEW.BUSINESSUNIT...

Thanks for the help.

Still can't get it to work Ok now I know I'm lost. Here is the Query. POSITIONSTATRDATE is the field that is text but contains a date. However whenever I try to use "cdate" I get an error and cannot change it from text to a date field! SELECT PBOWES_LMS_DR_ILCTRANSCRIPT_VIEW.LASTNAME...

Thankd Pat once again you are a life saver

Thanks Pat, not to sound to dumb but where do I use that expression?

I have a locked DB from corporate and the wizards made the [startdate] a text field and will not change it to a date field. I need to run some reports based on date calculations. Is ther a way to change the text field to a date field (short date) using a query? All help appriciated. thanks

Thanks for the help!

thanks, I know how to figure the days what I am having trouble with is getting it to report a disserent catagory on the report based on the amount of days.

In Excel, click Options on the Tools menu, and then click the General tab. Clear the Ignore other applications check box. If this option is selected, Excel ignores requests from programs that link to Excel data by means of DDE rather than OLE.

I have a database the logs [start date] and then [test date]. I want to run a query for a report that will calculate how many days between [start date] and [test date] and then report it in 4 catagories on a report. for example if it is greater than 1 but less than 30 I want it to be catagory...

In one of my queries it leaves a blank record in the last row. On the report it counts this line. How can I remove the blank row from a query?

Thanks Pat I will give that a try. However I converted the 2000 mde to a 2002 database and it deleted the corrupt file. I only hope the user has access 2002 so I will also try it your way. Once again thanks for the help!!

I have a database "MDE" it has been working withou problem however now record 7606 on the job log in table has "#error in the key firld and the db will not search or query anything past that record. Does anyone know. a. What caused this. and b. How can I fix it? It will not let me delete the...

Thanks for the assisance however could you please state that in english?

I am working on a production DB for a copy center my question is: can I divide 2 numbers and come up with a short time? I have [number of copies]/[copies per minute] and I want the answere to be in short time. Can anyone help with this. :confused:

Thanks but I still do not nuderstand how I would code that in the expression?? :confused:

I have inherited a database and am endining up with duplicate record numbers since the record numbers are entered by the user even though there is a subform that shows them the record number. I changed the control source on the mail form to "[Box Number Register Form].[Form]![BoxNumber]" this...

it does not say unbound. If I set my control source to boxnumer on the records table how can I have the box number on the subform populate the fiels on the form and in the table??

I have a text box on a form with the coomand "=[formname].[form]![fieldname], this box is populated when the subform autonumber textbox populstes. But it will not save the value to my table. Does anyoneone know how to make it save the value to the main form table??

I have a subform with an auto number. This autonumber is linked to a text box on my main form. Is it possible to limit the subform to one record only? If i enter data the autonumber populates the main form however if I tab over again it changes the autonumber. All help appriciated