RE: Datasheet View shows too many fields
From: JL (JL_at_discussions.microsoft.com)
Date: 11/19/04
- Next message: slacker: "RE: Enter Parameter Value"
- Previous message: Michel Walsh: "Re: How do I access files that were e-mailed to me in spread-sheet fo."
- In reply to: JohnL: "RE: Datasheet View shows too many fields"
- Next in thread: John Spencer (MVP): "Re: Datasheet View shows too many fields"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 19 Nov 2004 03:59:01 -0800
The only way that I know that "*" will appear is when you double click on the
"*" in the table in Design view or you put it in yourself.
"JohnL" wrote:
> Thanks for you quick reply. After some trial and error, I was succesful when
> I removed the preceeding comma and space as well as the asterisk. Thanks
> again.
> Do you have any idea why the wildcard is appearing, seemingly on its own?
>
> "JL" wrote:
>
> > Hi JohnL,
> > If you remove the "*", then it will just show the first two field. The "*"
> > is selecting every fields in the given table.
> >
> >
> > "JohnL" wrote:
> >
> > > I have only two fields in the design grid, but when I run the query, all the
> > > fileds in the field list appear in the Datasheet view.
> > > The SQL is as follows:
> > >
> > > SELECT tblPNList.MaterialNbr, tblPNList.MaterialDesc, *
> > > FROM tblPNList;
> > >
> > >
> > >
- Next message: slacker: "RE: Enter Parameter Value"
- Previous message: Michel Walsh: "Re: How do I access files that were e-mailed to me in spread-sheet fo."
- In reply to: JohnL: "RE: Datasheet View shows too many fields"
- Next in thread: John Spencer (MVP): "Re: Datasheet View shows too many fields"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
