Query columns renaming themselves??

[Phonik]

Hi all,

This is a strange one. I have a VERY simple query that runs directly off a single table which contains about 7 fields and one PK. I am pulling through 4 columns from this table including the primary key. I am renaming the columns using the format "NewName: Record_Id" format. I have also tried changing the caption on the query column properties.
Basically, the problem is that I save and close the working query but when I either close the database down or make a change to another form or query, the column names all get changed to a single value of the table, currently "Report Title". When the query is run, all the columns are shown with the same header name and the data results are all the same.
I have checked my relationships and they are fine and I have also done a compact/repair but without any luck. Can anyone please help me?

Thank you.

Gareth

 

[Rabbie]

Can you post the SQL of your query please.

 

[Phonik]

Hi,

Thanks for your reply.

The SQL is: SELECT [Reports].Report_Id, [Reports].Report_Title, [Reports].Report_Dept, [Reports].Availability
FROM Reports;

 

[Guus2005]

That is very strange indeed. The query you show should pose any problem.

Something is seriously wrong with your database. Backup your database before it is completely corrupt. Did you reboot?

Remove the query and start over.

 

[Phonik]

Thanks for your suggestion Guus2005

 

[neileg]

The SQL you have posted doesn't rename the fields. I'm not sure what you were expecting. It should look something like:
SELECT [Reports].Report_Id AS Newfield1, [Reports].Report_Title AS Newfield2, etc.