I have a table of Shipment Detail. containing: doc no. , item no. , qty. I need to make a query : :::doc no. - item no - carton count - qty carton count is 1...

what is the best way to go about doing this? i just created a report that first runs a query for current month info in teradata sql assistant and exports to...

is there a way to get around this?? i have an access database that is set up with a link to a text file that is created via teradata sql assistant. this...

i have a form that displays rep name (RepNm combo box), but also has an ad id (hidden). i want to have a cascading combo box automatically populate ad name...

is it possible to join on dates? for example inner join mytbl on date() = mytbl.eff_dt and date() = nz(mytbl.exp_dt,date())

is it possible to use a table saved in an access file as a filter for a passthrough query that retrieves data from a server? e.g. select odbc.col from...

anyone know if there is a way using sql to return min effective date and max end date for every change in a value in another column. for...

Is there a way to align dates using SQL in Access? My problem is as follows: I have a table that only shows the start date of a particular contract for each...

im new to the world of sql, so im not sure if this is can even be accomplished in a single query or if two separate queries are required. i am trying to put...

I have a table that has a Start field and an End field both of which are Date/Time type fields. I want to compare the records in the table for data entry...

Hi NG I have a table: SE_Data. All Fields are text. I have two queries on the table: SE_Data

Hello again. I am attempting to write a query that will locate records with differences in identicle fields. Monthly, we get a list of projects within the...

Hello Everyone, I am trying to build a query in MS Access, I would like to be able to subtract a set amount of minutes from the Now() function. What...

I am trying to create a new field in which it shows the sum total of 10 fields (Charge Time, Charge Time 2, Charge Time 3, etc.); what is the easiest way to...

Is there an easy way to setup aquery where it will calculate overdue tasks based on the computer date (I don't want to have to go back in and chage the...

i am very new to access and need help pulling info from 3 tables, all three tables have- id, last name, first name and DOB i would like the report to end up...

i have made a "find duplicates" query using a table named patient_list2 the query returns the following feilds- last name, first name, DOB, id i need to delete...

Hello All, I'm trying to use an ODBC SQL Passthrough. I seem to be running into a size limit for QueryDef.SQL I have a query string that is about...

Hello All, I would like to Update a record if it satisfies a condition (i.e. the Primary key exists) otherwise I would like to Insert a new record into that...

Hello all, I would like to combine Phone numbers from a fax, home, work and mobile fields all into 1 column to populate a list of all the phone numbers. It...