Re: use result as a FIELD in the design grid

From: Duane Hookom (duanehookom_at_NoSpamHotmail.com)
Date: 07/15/04 

Date: Thu, 15 Jul 2004 16:44:41 -0500

I have looked back at this thread several times but I wouldn't want to make
a suggestion without creating tables, entering data, and then testing. I
haven't had the time to do this. I would be willing to accept a small sample
mdb from you which would save me a ton of time. You would need to email me
off NG to find out where and how to send it to me so that my email client
would delete it. If you are interested, email me at duane AT hookom DOT net. 

-- 
Duane Hookom
MS Access MVP
--
"VJ-mike" <anonymous@discussions.microsoft.com> wrote in message
news:2e20d01c46a7f$d6d1c8c0$a301280a@phx.gbl...
> Duane, I took the time to write the stuff out.  Did it not
> make sense to you?
>
> thanks, mike.
> >-----Original Message-----
> >I'm a visual person and would still beg to have you type
> some sample records
> >and the desired output. Without it, I am giving up.
> What's so difficult
> >about entering 10-12 records (significant fields only)
> and then how you want
> >the final query to display?
> >
> >-- 
> >Duane Hookom
> >MS Access MVP
> >
> >
> ><anonymous@discussions.microsoft.com> wrote in message
> >news:2abdb01c4683b$8c201b10$a601280a@phx.gbl...
> >> thanks Duane, but I have Field 'post1' already available
> >> in TableB...
> >>
> >> TableB basically has all the data in it.  TableA tells
> me
> >> which field contains the data I need for a certain
> >> record.  So a query of TableA will tell me I need
> >> field 'post1'.  But in the new (later) query, how do I
> set
> >> the query grid to:
> >>
> >> Field : post1 (from tableB)
> >>
> >> without typing 'post1' into the grid.
> >>
> >> Thanks for the patience!
> >>
> >>
> >> >-----Original Message-----
> >> >Have you looked at using a Crosstab query? If you set
> the
> >> Column Heading to
> >> >[Data Location] then you will end up with a column
> >> named "post1".
> >> >
> >> >-- 
> >> >Duane Hookom
> >> >MS Access MVP
> >> >
> >> >
> >> >"VJ-mike" <anonymous@discussions.microsoft.com> wrote
> in
> >> message
> >> >news:2bce001c46825$a960ab60$a301280a@phx.gbl...
> >> >> Ok, TableA has a field 'data location', and for a
> >> >> particular record the value there is 'post1'.
> >> >>
> >> >> TableB has a field 'post1'.
> >> >>
> >> >> In my query grid I want to use the found value
> of 'data
> >> >> location' for the particular record (result
> = 'post1'),
> >> >> and use that as the actual field name.  It's like I
> >> need a
> >> >> variable to hold the result of 'post1' and place it
> in
> >> the
> >> >> field/table box in the grid.  I haven't been able to
> use
> >> >> SetValue to put the literal 'post1' into the
> field/table
> >> >> box in the grid.  and what I do get is always
> proceded
> >> >> with an alias like 'Expr1:'.
> >> >>
> >> >> This situation stems from using a really ugly flat
> file
> >> as
> >> >> the source!
> >> >>
> >> >> Thanks for help,
> >> >> mike.
> >> >>
> >> >>
> >> >> >-----Original Message-----
> >> >> >This is one of those question that providing a
> little
> >> >> sample data and
> >> >> >desired output would make this a lot clearer.
> >> >> >
> >> >> >-- 
> >> >> >Duane Hookom
> >> >> >MS Access MVP
> >> >> >
> >> >> >
> >> >> >"VJ-mike" <anonymous@discussions.microsoft.com>
> wrote
> >> in
> >> >> message
> >> >> >news:2984e01c465fb$de8b3c00$a601280a@phx.gbl...
> >> >> >>
> >> >> >> I want to use a queried attribute value as a Field
> >> name
> >> >> in
> >> >> >> the query design grid.  I tried a Select
> statement,
> >> but
> >> >> at
> >> >> >> best, was comming up with something that required
> an
> >> >> >> expression name followed by the attribute - not
> the
> >> >> >> attribute value alone.
> >> >> >>
> >> >> >> thanks,
> >> >> >> mike in olympia.
> >> >> >
> >> >> >
> >> >> >.
> >> >> >
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

Relevant Pages