using the same field in a query but need different captions/headers

[crobaseball]

So I'm using the same field in a query, price. But I need it listed twice in the table it creates, one as cogs_mfn, and the other as cogs_afn. The problem is that since the field that the data is coming from is exactly the same, the caption remains consistent, whether one or the other. I've tried to create separate expressions, but that doesn't work either. Anyone have any ideas? Thanks.

[CJ_London]

not quite sure why you are having a problem

in the query grid

Price1: Price..............Price2:Price

or SQL

SELECT.....Price as Price1, Price as Price2.................

[crobaseball]

When I run the query it then looks like this



Not sure what to say, this is just how it's coming out. I'm rather surprised. I would have though it would have been fine.

[crobaseball]

Shoot, the pics didn't attach correctly. Here are the links . . . btw, what the heck am I doing wrong? I've used pixentral to embed pics of my screen shots in the past, but this is the 3rd time where they aren't uploading. Thoughts?

http://www.pixentral.com/show.php?picture=1PvxOiqKH3dfvCqrUHjnSN1J6e4m3T0
http://www.pixentral.com/show.php?pi...i5rJ6Hj73FjU20

[crobaseball]

not quite sure why you are having a problem

in the query grid

Price1: Price..............Price2:Price

or SQL

SELECT.....Price as Price1, Price as Price2.................

For anyone who has had a chance to review, this does not work.

[CJ_London]

this does not work

Sorry to hear that - perhaps you can help me. I've got a form that doesn't work either - can you tell me why?

[CJ_London]

Sorry, hadn't realised you have posted some images. I suspect if you look at the properties for the cogs_afn column in query design, you will see you have 'cogs_mfn' in the caption property

[crobaseball]

Sorry, hadn't realised you have posted some images. I suspect if you look at the properties for the cogs_afn column in query design, you will see you have 'cogs_mfn' in the caption property

There doesn't appear to be a way to do this in the query. Once you have a single field, it will always only show one caption, i.e. I don't know how you can make this unique. I tried to build the expression a number of different ways and none worked.

But I figured out a workaround: create a subquery which builds the expressions separately, then use that subquery as part of your other query. It will allow for a second set of fields, with the exact same values/fields.

[CJ_London]

in query design, right click on the column and select properties and add a name under caption



then run the query

[June7]

As Ajax demonstrated, can have as many aliases for the same field in query as you want. Don't understand why you want to.

Why doesn't it work, what happens - error message, wrong results, nothing?

[CJ_London]

or you may have set it in your table

[CJ_London]

can have as many aliases for the same field in query as you want. Don't understand why you want to.

The problem is that in the query view the OP appears to have two different fields aliased with the same name - but in design view they are not aliased (and sql would not allow two fields to have the same alias anyway). I believe the issue is not with the sql code or aliasing, but what is displayed - i.e. using captions which I suspect the OP has set inadvertently or perhaps when designing his table copied a field (with a caption) to create a new field, changed the field name but forgot about the caption

[June7]

I never set Caption property (nor most other properties) in the table.

[CJ_London]

nor do I - only causes confusion