Querying dates between two tables

[Freeman girl]

I have a query that has multiple columns with dates. I need to be able to
query one column against another column. Is that possile?

Example: Column A has an admission date to a hospitalization
Column B has an authorization date.

I need for my query to only pull hospitalizations (column A) that occurred
after authorizations were issued (column B)

Is it possible to tell one column to look at and query against another column?

 

[KARL DEWEY]

It is very easy if you are talking about the same record --
SELECT [Column A], [Column B]
FROM YourTable
WHERE [Column A] > [Column B];

 

[John W. Vinson]

On Thu, 4 Mar 2010 15:19:01 -0800, Freeman girl <Freeman

I have a query that has multiple columns with dates. I need to be able to
query one column against another column. Is that possile?

Example: Column A has an admission date to a hospitalization
Column B has an authorization date.

I need for my query to only pull hospitalizations (column A) that occurred
after authorizations were issued (column B)

Is it possible to tell one column to look at and query against another column?

Yes; you can use a criterion on column A such as

[Column B]

The brackets are essential and should contain the actual fieldname of the
other field. Note that relational database tables are NOT spreadsheets; the
proper jargon term is "field", not "column".

You might want to open your query in SQL view and post the SQL text here so
people can see more clearly what you're dealing with.

Also note that your subject line refers to "between two tables" and your text
"between two columns"; both are doable but the technique will be different.

 

[PieterLinden via AccessMonster.com]

SELECT [AdmissionDate], [AuthorizationDate]
FROM MyTable
WHERE [AdmissionDate]>[HospitalizationDate];

 

[Freeman girl]

Thank you for your help, this did the trick!

It is very easy if you are talking about the same record --
SELECT [Column A], [Column B]
FROM YourTable
WHERE [Column A] > [Column B];

--
Build a little, test a little.

I have a query that has multiple columns with dates. I need to be able to
query one column against another column. Is that possile?

Example: Column A has an admission date to a hospitalization
Column B has an authorization date.

I need for my query to only pull hospitalizations (column A) that occurred
after authorizations were issued (column B)

Is it possible to tell one column to look at and query against another column?

 

[Freeman girl]

Thank you for the clarifications. This helped tremendously!

On Thu, 4 Mar 2010 15:19:01 -0800, Freeman girl <Freeman

I have a query that has multiple columns with dates. I need to be able to
query one column against another column. Is that possile?

Example: Column A has an admission date to a hospitalization
Column B has an authorization date.

I need for my query to only pull hospitalizations (column A) that occurred
after authorizations were issued (column B)

Is it possible to tell one column to look at and query against another column?

Yes; you can use a criterion on column A such as

[Column B]

The brackets are essential and should contain the actual fieldname of the
other field. Note that relational database tables are NOT spreadsheets; the
proper jargon term is "field", not "column".

You might want to open your query in SQL view and post the SQL text here so
people can see more clearly what you're dealing with.

Also note that your subject line refers to "between two tables" and your text
"between two columns"; both are doable but the technique will be different.