How can write a delete query to delete records in a table where the Date field formatted 1/15/04 is older than 1 yr. from today? Thanks

I have created a cross-tab query and I want to use a form to define the criteria of one of the fields. This field does not form part of the row heading, the...

Hi! I am trying to get this quiry to work right. What I want is to add the two queries together. So in the query I am having problems with I select the two...

I have an app that allows users to run a qry, then they can use icon for evaluating with Excel to export into excel. This has been working up until recently -...

I went to edit a query in Design View but the Tables are missing. My fields are all still there and show the correct table names. I selected "Show Tables" and...

I've run into a problem doing a parameter query I received help from this forum in developing. I've used the structure of this parameter query in several...

I have created a simple date query where the user has to enter a specific date to retrieve a set of records. The problem is that the query works perfectly for...

i would like to add a text box in my form that shows the company name when i write the company_id in a field. ie: company_id 001 the text box...

Here's the gist of a situation I have: I have 2 tables A and B. In one query (call it Q1) I find all record common to both tables, in a second query (Q2) I...

Say I have tblRates with the fields FromDate and NewRate. What's the easiest way to obtain the Rate on a particular day, which could be between two FromDates...

I have made a crosstab query and set the 'column headings' property of the query to have all the possible values. The query works but the order that...

I have a report based on a query that works like this: Customer Commodity #1 Wt. Price Total Commodity #2 Wt. Price ...

I'm having trouble constructing a query to retrieve records from a TableA based on an indicator in TableB and on getting the max date. Here's the data in...

Hi there! i'm building a locker monitoring system. in "Locker table" once i deleted a row it would automatically transfer to "Resigned table". How am i able...

I know how to create a crosstab query that has a total column. Is there not a way to get the difference between column headings? My example is pre and post...

How do I ensure no duplicates records for numeric field in Access query?

Hello I have built an Iif statement in a query that will not run because it says it is to complex. If I limit the amount of Iif''s the query runs fine. I...

hi, i have a problem with a query on an informix-database. everything works fine, as far as working with char or number fields. the problem is the date...

I have two columns I want to combine into 1. I want to do this in a query. 1 Company 2 Property into 3 CoProp "trim]"+"trim "is wrong.

I have a query that calls a function to get a list of concatenated values. I have used it before and it works, but I am trying to use it with a...