Hi, please help if you can. i need to filter data and have built a query but i cant get it to work. there are 10 columns in the query each contains a date, or...

I have a function that returns a string that I would like to use as the criteria in a field in the QBE query grid. I know the return value for the function is...

Dear Olden: This is your basic aggregate query, also called a totals query. SELECT SKU, SUM(QTY) AS QTY FROM YourTable GROUP BY SKU Notice that you cannot...

Hello, I thought that if I put six different expressions in a query, that Access would go through the table data six times and essentially run six...

I am trying to alter the following query: SELECT dbo_Requests.Req_Date, dbo_Requests.Version, dbo_Requests.File_Name, dbo_Requests.Company_Name,...

Writing a QBF but having problem searching a time field. It was created as a text field, so I wrote my criteria as a text field, see below. If Not...

Hi guys, I've had this problem before and never fully resolved it so am trying again, this time with a different tact. I have a form containing 6 combo boxes....

Hello: I need to add a calculated field to a table containing tens of thousands of records in Access. This field will contain the time lapsed by Trip and...

I am teaching myself Access and SQL as I need it on the job, and I want to thank everyone who has contributed to this discussion group for all of your very...

What is the best way to filter through multiple fields to get an answer for another field? i.e. I have 10 seperate fields I want to filter through. Each field...

How can you compress / group by on a crosstab query when the amount of column names are unknown ? If I run a crosstab query for example I may have 1, 2, 3 or...

I am new to databases. At the moment I'm trying to make a film database. I want the query to search for a given films actors. However I would like the...

Hello, I have a Query based on 2 tables and another query. All three are joined by the field ID (PK in the tblComplete List of Contacts table). I want to...

Hi Group. I'm sure this should be straight forward, but I just can't get my head round the most efficient way to do it... I have 2 tables. PARTS(14,000...

HI guys, Hoping you can help. I have a pivot table that has "status" for rows and "months open" for columns. I want to change the column headings to use...

Hi there I would like to be able to query by form (with criteria based on a number of fields) to select just one record, and for that chosen record to be...

I have a report that specifies two dates. and . I am needing to show Boats that have docked and departed by date. The critiria for Departtime is "Between ...

This is the original post: I took my main table NameAddr this file contains all of our customers with assigned customer numbers. Each of the 14 branches has a...

i am building a qquery in design view in Access which creates 33millions rows. When i try and save the query it says "invalid argument". I don't know why.

Hi, I have searched the KB and I have found some articles but I cannot seem to work it out for my purposes. What I'm trying to do is that I want to sum...