Time/Date problem

[Bigmo2u]

Gents I have my tables set up with the Short date in the table. I know this might fall into the query catagory but it also has to do with the tables, so I am not sure where to put it.

Problem: I run a query on the date and when I export that to a .txt (Fixed Length) file it pulls in the Time portion as well.

Try#1: Making the field a TEXT field with Short Date format. File one show what i am doing.

Try#2: Query a specific Date and it works fine. File 2 show this.

I have a feeling I am trying to fool Access But I am not sure.

Thanks in advance for any help on this.
Craig

 

[neileg]

Applying the format at table level only affects the display in table view. If you want to change the format in your export, you should apply the format to the field in the query instead.

 

[Bigmo2u]

Applying the format at table level only affects the display in table view. If you want to change the format in your export, you should apply the format to the field in the query instead.

Neileg - how I do this? Or please point me to material that can help me do this.

The other question I have is that when I put [Enter Date mm/dd/yyyy] in in two different criterias and try to export to a .txt file I get a "too few perimeters. expected 1" error. Here is my code:

SELECT tblClaims.[Claim #], tblClaims.SSN, tblMBRinfo.[SDN 1], tblMBRinfo.LName, tblClaims.[Claim Received], tblClaims.[Start Date], tblClaims.[End Date], tblClaims.[Disbo DN Date], tblClaims.[DN Reason 1], tblClaims.[DN Reason 2], tblClaims.[DN Reason 3]
FROM tblMBRinfo LEFT JOIN tblClaims ON tblMBRinfo.SSN = tblClaims.SSN
WHERE (((tblClaims.[Claim Received])=[Enter Date mm/dd/yyyy])) OR (((tblClaims.[Disbo DN Date])=[Enter Date mm/dd/yyyy]));

 

[neileg]

Open your query in design view. Highlight the date field and open the property sheet. Select the format you want.

You are using the same parameter prompt twice. You should capture the user input in a form and refer the query to the form. Say the text box is called MyDate in the form called MyForm. YThen the parameter in the query should be:
Forms!MyForm.MyDate

 

[Bigmo2u]

Thanks for the help neileg.