Hi All I have a table which stores drawing types and their revisions along with the date completed. I want to do a query which will only show the most recent...

From Table1: StaffID Prod1 Prod2 2222 200 120 1111 170 190 2222 130 180 1111 200 150 etc etc

Hello, In a table there is a text field, in which dates are entered. For example the date December 3rd 1975 is entered: 03121975 (dd/mm/yyyy) What I need is...

All I am trying to do is add a parameter into the schedule_to field that says: Between And If in my query I delete the expressions that I have put in prior...

My data in tballnumcount query is something like this.. this query runs fast and there are about 11462 records sr numvalue numcount latest 1 14 ...

I'm trying to update a number field with numbers that have dashes in them. For example: I'd like to change 620-46-3 to 620463. I know this can be done with...

How can I update a field in a query using a linked table?

I'm trying to use a data field in the LIKE Function... This is my data..first line is thefiled names ...each additional line is a sample record.. Flight # ...

Hi Guys, I am trying to produce a query based on balances of accounts with my company. The data in the table contains the following information: Week...

I have a table in access that is laid out like the following: Mo Year Sold Price Mdl_line Mdl_yr Orig_resl_amt Gap VIN (unique) aug 2007 ...

I have a need to match records from two separate tables and the like fields are not identical. One table contains 6 unique digits of an account number and...

Also posted in : microsoft.public.sqlserver.programming Hi, I'm not very experienced with creating queries and am having some difficulty creating what I...

I am writing an update query that calculates Years of Service (YOS) based off of the start date. My current expression...

I have been able to acheive the result I need in excel 07 but have no idea how to do it in access 07. I have the follwing two queries. Query1

Hi all, I could really use some help here. I'm trying to run a query to pull the last commission used by all of our brokers. I know this isn't that...

I know that to change the price in a query I have to use the Update function. However, I don’t know the exact syntax for it. Example: I need to change the...

I have a query that sums a field Quantity with criteria 0. When the results are displayed on the screen shows correctly. However, if you go to the quantity...

Hi - I've generated a 'report' and one column is an amount field. I notice that some of the amounts have the $ sign and some do not. Is this an easy fix? ...

Yes, I have tried the suggestions in thread "Can't access design view". I get the error message (" is not a valid name. Make sure that it does not include...

Does access accepts the "%" sign for missing values in a query?