Hi everyone, I have a table with the following data upon which I would like to report: SomeDt SomeValue 1-sep-09 100 12-dec-09 ...

I am using Microsoft Access 97 and have an internediate level skill. I have a a query to filter records by both street name (Boiler Street) and expiration...

I am trying to create a query that will delete a duplicate record in a table. I want to delete the older record and keep the new one created. I have used the...

Hi, I had a string with "I'm a boy" with the single code... therefore system prompt error thinking it was end of sql statement.. how do I eliminate this error...

I have a table imported from some other programme which I have no access to. The data is in text format and has strings. Example "123456789". I need to...

HELP!!!! Nothing is working for me. I need an expression that displays all members that, equals Active if the memberships field is active and not active if...

I have two tables (Individuals and Census) - with a one to many relationship...One individual may have many census codes. Census codes define when an...

I am having 4 records for each customer with different dates, so how can I get the last records for this customer. I also want to see 4 other fields in my...

I have a database which has data values in one field where the data contains values that have parentheses which also contain a string (Letter). One value...

I'm having problem setting a parameter in an append query. I want to optionally use all records or only active records (Inactive field = False). In the...

I have a check book with deposits and checks written on the account. I would like to run a query and show a running balance next to each entry. Please help.

I have a query that someone had helped me with and it works great: However when I run this against 91,000 records the query runs forever. When running...

Hi All, Is it possible to create a Make Table query in access (2.0 and 2003) that creates the table into a SQL Server database? Following the steps: 1-...

This is a hard one. I have been struggling for a while PLEASE PLEASE HELP I have a query that has two fields admission date and discharge date. I have a...

I have what I believe is a unique situation. I have a query with many complex calculations that generates a value that I need in another query. The problem is...

I have created a query on a table: USFed2008TaxRate&Amt and created the following IIf statement expression for the field: TaxRate in that table based on the...

I have two select queries; one for one type of revenue booked by sales reps which is called 'Bookings' and the other for another type of revenue generated by...

Hello, I was wondering if someone could help me with my query. I am creating a db to track keys and employee info for our school. I am trying to create a...

Help with AND/OR, IIF, ISNULL, ISNOTNULL, LIKE?? In my simplified example, I have Last Name, First Name, DOB, Document Type (receipt, check, invoice) and...

This is from an Access non-expert--no sql background and little vba. Is there an equivalent Access expression to Excel's "countif" function? This could be...