Hi i have a db with employees and their traveling. the traveling table has a departure and arrival date. All im trying to do is to make a query for finding ...

I'm using Sql 2000 and Access 2003. I have a work order form with a check box. When the work order is completed the user checks the box and moves to the next...

I know I'm missing something obvious, but I need help. I have calculated fields msg1, msg2, and msg3. I want msg3 to equal msg2 if it exists (ie, not null...

I am under-going a college project that involves a supermarket delivery system. One of the fields in my tables looks up a date from another table. However,...

I have a table which i need to dispaly and add 1 to the number in the field based on the last record entered. field 1 in the table is an auto number field. At...

I have a table which i need to dispaly and add 1 to the number in the field based on the last record entered. field 1 in the table is an auto number field. At...

1.01 million is perfect I need the land , I will bleed purple in july and christ help me you hang me out on this one I will do...

I HAVE FOUR FIELDS FIELD1,FIELD2,FIELD3,FIELD4 AS SHOWN...

Hi - I'm trying to run a query as part of a VBA procedure, and what I want it to do is to grab the value for a parameter (the current month) from another part...

I have an access table which I need to update the school names The school codes(SchCode) are codes are consistent from year to year but the school...

Following the SQL given below, with the corrections that the table name is and the Cost Column is Called , I have the following SQL that gives me the error...

I am trying to construct a query that will sum the contents of a particular field based on todays date. Can't seem to find any examples of this. Select...

I am running a query that counts all Adult and Juvenile audio book cassettes. I have call numbers like BOOK CAS J GANTOS (which is a juvenile cassette) and...

I have a query with a date field, an employee field, and a score field. In the criteria for the employee field I have . I then made a graph consisting of the...

I need to create a single query from the following queries that will allow me to create a report of all fields from all queries. QUERIES: 1....

I have an Access 2000 db in which I need to essentially duplicate an existing query about 20 times, varying the field being searched on with each one. Rather...

Hi, I have an extensive query that I need to export into an Excel spreadsheet - however the memo field only copies over the first 255 characters - is there a...

SBcnt Table: ----------- 013180 013180 013180 above 3 are unique records

I created a query to check for duplicates as the following: SELECT .CustomerNo, .ApplicationNo, .Carrier FROM INNER JOIN ON (.ApplicationNo = .ApplicationNo)...

I'm trying to take the date stored in INVDATE and calculate COVDATE. The COVDATE is simply the first day of the next month. So, if INVDATE is 3/5/2007, then...