Database Design

M

Mike George

I need to design a database which will allow only one
record to be returned, the table has Ages (between 18 and
80) and Premiums (between $10 and $150). The ASP form
will request age and premium and I need to return only
that record, any suggestions as to how I accomplish this
 
J

Jeff Boyce

Mike

Are you saying you need a query that, given Age and Premium, returns ...
?what?

Are you saying that the table has more than one record with the same Age &
Premium?

What have you already tried?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Designate font as italic of another 0
Microsoft 365 Activations, Users or Devices? 0
Adding data to MS Access from csv file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How do I clear a form? 0
Word OLE to check spelling in text box 1
OLE Word spelling 0
Space at end of multi page list to accommodate new entries 1

Top