| Thread | Last Post | Replies |
|
| Recommendation on how to use semi-fixed variables in a Query | 01 Mar 2008 08:24 GMT | 1 |
I need to use about 8-10 variables that will only 'seldom' change in the calculations of query fields. Because the variables will be used in multiple expressions within the query, it would seem to be best to only have to change them/it in just one location. Should I use a ...
|
| Calculate days between dates in a query | 01 Mar 2008 07:51 GMT | 7 |
I have a query that lists dates when an oil well was either put into production or taken off production. There are several wells in the database and the query retrieves all the wells. The SQL for the query is as follows; SELECT [Base Wells].[WELL NAME], [All Daily Production ...
|
| Delete Query Please help | 01 Mar 2008 07:18 GMT | 2 |
How do I delete the contents of column? I have a table where I need to empty the contents of a column(field) there are thousands of records. There are some records that have data in this field I need to make this field blank for all the records in the table. How do I this ...
|
| Group only by certain day | 01 Mar 2008 01:39 GMT | 4 |
Good afternoon, I have a query set up where i want the results to show only Thursdays within a Date Field. I have no idea how to accomplish this. I went through the datepart and date
|