Hello all, have following sql view query: SELECT TABLE1., TABLE1.COST, TABLE1.QT_PRICE, TABLE1.ZPR1, TABLE1.ZPRC, TABLE1.ZQCM FROM TABLE1 WHERE (((TABLE1.) In...

I have a table showing user test scores from multiple locations. There is a field for location number, and each location is assigned a unique number. There...

Hello. I have a make-table query that references a pass-through query. The Make-table query is used to pass parameters since I cannot pass them directly to...

Hello, I have an odd problem, I am using a Union query to join two queries together. The odd thing is that I am getting duplicate records in the union. When...

Hello, I need assistance in the expression to select a unique symbol or number to search for all records that end with this unique ID.For example.....I...

Howdy. I want a list of donors, with their 3 most recent donations. I am very confused as to how to get the top three donations records for each of the...

Given this query: SELECT CompanyID, CompanyName, Inactive FROM tblCustomers UNION SELECT VendorID AS CompanyID, CompanyName, Inactive FROM tblVendors WHERE...

OK, so I'm trying to clean up some phone number data. some phone numbers added to the database in it's old version (pre-Access) were entered as (###)###-####,...

Hi, I have a date field with values of MM/DD/YY. I want to create a separate field called year which would only list the year. Is there a way to obtain the...

Hello, In my database i have an invoice amount that the field properties is set to double standard and auto in the invoice table.It is not needed to be in...

Access Developers, Any VB or Access SQL query language will be greatly appreciated. Petra

I have a database that works well on 8 different computers. On the 9th computer, all of the reports are showing on the monitor as if the fields and the Text...

How do I have null values show up on a query?

Hi there I have a table and I need to obtain the sum of all of the values in a particular column. Firstly, how do I distinguish which column I want to sum up;...

Dear Developers, I would appreciate help in troubleshooting why the subform data appears only when I view the subform in a new window, but not when I view the...

I have one table, Customers and one table called Emails. Each customer can have several emails, and these two tables are linked with the field CustomerID. For...

Hi there, I have a parameter query with wildcards set up for a table with a long description field. It works great if the user just wants to locate the word...

Dear Developers, Any info is appreciated. Thanks, petra

I have a few thousand records that all contain a date field in the British format of dd/mm/yy. I want to create query that groups the records into months. So,...

I have a db with 59,000 records. Two fields one is a dept code and the other a permission code. I also have a matrix (on paper) of acceptable combinations of...