Writing a query

[Amber]

Hello,

I am using a script to make a query.
I have 10 fields for each record in my form (of the main
table). half of them with date and the other half is with
names.
I would like that if I choose a date and open the report,
only the fields with this date will appear in the report.

I mean, if for record number one I have 4 dates written
with 4 names. for date "A" I have only 2 names out of the
four I have for that record. For record number two I have
5 days, none of them is date "A".

In the report I would like record one to appear ONLY with
the two dates that match date "A" ( not all the four
dates) and record number two shouldn't appear at all.

Is it possible to put only part of the record?

 

[Fons Ponsioen]

It appears to me that a changed table structure with three
fields RecordNum, Date1, and Name1 would be more usable,
this would simplify reports and queries.
The reason I put a suffix 1 to the Date and Name is that
these are reserved words and could cause problems with
queries and reports.
Hope this helps.
Fons

 

[Amber]

Thank you fot your answer.
But I think I wasn't clear. It is not that for every
date , you have one name. So how will this table help?

Thanks a lot

 

[Fons Ponsioen]

The idea I did not explain very well is:
When you have one field for date and only one field for
name etc. it is simple to make a query to restrict data
fora report or form giving specific limited data. You can
restict output to between this data and that date and limt
to certain names, with the structure where you have
several dates and names for each record, reports are much
more complicated to write speciall if you wish to display
data from different fields in on textbox.
If you care to You could post some sample data and sample
report, how your data is stored and how you want it
displayed to ensure I undertand more clearly what you
realy want.
Hope this helps.
Fons