Finding records

A

Apples76

I am working im Access 2000, and now have a requirement to create a query
that shows the records for items shown as received in a date range (decided
by user)

I have created the basic query but i am struggling with the following issue.

I have two fields in a table i wish to check, each of the fields represent
one activity. the first activity (MSV) will always be received first followed
by the second (quote) but the time inbetween can and does vary sometimes both
activities will be completed within the same month.

how can i retrieve a record which either activity took place within the date
range inputted by the user?


Thanks
 
A

Andy Hull

Hi

In SQL view you would use a query like...

select *
from <table>
where (MSV between [date1] and [date2])
or (quote between [date1] and [date2])

In Design view...
For the MSV column put the following on the line labelled "Criteria:"

between [date1] and [date2]

and for the quote column, on the line labelled "or:" also put

between [date1] and [date2]

The important part is to put the criteria for MSV and quote on different
lines so they are combined with an OR (else they will be combined with an AND)

hth

Andy Hull
 
A

Apples76

Thanks Andy,

that worked a treat.

Andy Hull said:
Hi

In SQL view you would use a query like...

select *
from <table>
where (MSV between [date1] and [date2])
or (quote between [date1] and [date2])

In Design view...
For the MSV column put the following on the line labelled "Criteria:"

between [date1] and [date2]

and for the quote column, on the line labelled "or:" also put

between [date1] and [date2]

The important part is to put the criteria for MSV and quote on different
lines so they are combined with an OR (else they will be combined with an AND)

hth

Andy Hull


Apples76 said:
I am working im Access 2000, and now have a requirement to create a query
that shows the records for items shown as received in a date range (decided
by user)

I have created the basic query but i am struggling with the following issue.

I have two fields in a table i wish to check, each of the fields represent
one activity. the first activity (MSV) will always be received first followed
by the second (quote) but the time inbetween can and does vary sometimes both
activities will be completed within the same month.

how can i retrieve a record which either activity took place within the date
range inputted by the user?


Thanks
Click to expand...
Click to expand...
 
Top