Expression question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I need to make a query in which I want it to ask the user for a value that
he needs to see in another table. How can I make an expression that opens a
user box making a question like, "what is the 1st value of the X field", but
before this window, I need to have another window giving me the first value.
How do I make this?

Thank you so much,

Luís
 
lmgraca said:
Hi there,

I need to make a query in which I want it to ask the user for a value that
he needs to see in another table. How can I make an expression that opens a
user box making a question like, "what is the 1st value of the X field", but
before this window, I need to have another window giving me the first value.
How do I make this?

Thank you so much,

Luís
Click to expand...

It *sounds* like you are asking about a Parameter Query. Take a look at
the description of this kind of query in the Help file & see if this
will give you what you need.

I have no idea what "before this window, I need to have another window
giving me the first value" means. Sorry.

LeAnne
 
Dear LeAnne,

Thank you so much for your help.

What I was trying to explain was that I needed a query that when you would
run it, you would get a question box asking you how to write certain values
by words. My idea is a box that would ask you how to write a certain value,
the box would say "write €30,57". This value would come from a certain table,
and afterwards you would "write thirty euros and fifty seven cents", this in
order to have the table, from where the value came with a field with the
number written in words.

Thanks again for your help

Luís
 
lmgraca said:
Dear LeAnne,

Thank you so much for your help.

What I was trying to explain was that I needed a query that when you would
run it, you would get a question box asking you how to write certain values
by words. My idea is a box that would ask you how to write a certain value,
the box would say "write €30,57". This value would come from a certain table,
and afterwards you would "write thirty euros and fifty seven cents", this in
order to have the table, from where the value came with a field with the
number written in words.

Thanks again for your help

Luís
Click to expand...

I'm sorry, but I can't make heads or tails of your description. Could
you post some information about your tables, fields, and how they are
related?

LeAnne
 
Back
Top