Hi, I have a query with the following fields: Date, Part Number, description, etc.. I need a 2 criteria.. 1 for Date and 1 for Part Number and I want them to...

hi here is what I need. I need to run a query that picks the data i specify from this week's Monday back to and including the previous week's Monday. i need it...

I need to build a query (to be used for eternity) to return records for dates between 01 July (the year prior) and 30 Jun (the current year) based on the...

There are two fields in my query. "From" and "To". For sake of ease, let's say both these fields are US Cities. How can I pull all the records that show...

I'm trying to remove a leading space in a text field using the update query and LTrim. I'm getting an error "Undefined function 'LTrim' in expression"....

Hi, I have a database for my high school students. I have it set to add up the grades and test scores so that we can verify their credits for graduation. ...

I have an Access db developed with Access 2003 that will work (with adjustments to references) with 2002 and 2000. Presumeably it will also work with Ofice...

Counting 1 total of 4 fields (not summing). I’m not sure how to set up the SQL for the query I need. I have 2 tables: 1. including fields: Size,...

I'm trying to create a macro that runs 3 action queries sequentially: An Update, an Append, and a Delete query. Problem is, when I copy the SQL code into a...

I have 31 columns in a table and 1000 records with several x's in each record. How can I total the x's in each record? I know I can use a query but I don't...

Hello, Sorry for bringing up an old topic but I've been searching the web for a way to insert a blank line into a report after individual systems and I found...

HI, I have a database that list publications and articles in the publications. I use two tables. Table 1 is the one containing publication names. Table 2...

When I put yes - there is no change. It seems to be counting the number of entries and not the number of yes/no answers. How do I get the query to pay...

We have an employee database. I would like to run a query that tells me who was working for us at a point in time. Example: what drivers were working for us...

I am new to Access downloads i cannot find the meaning of tlkpProperty

I have a table with the following fields that tracks the date an inspection was requested/booked for each field respectively(formated in Medium Date)...

I want to create a formula that can test each vendor name field and return a 1 if they are all the same or a 2 if they are different. I tried a nested IIF...

I have created a very large database of stock prices and company financial information. The queries are PAINFULLY slow. For example, I queried the database...

I am trying to use the example you shown here http://allenbrowne.com/ser-67.html but unfortunatly the columns are coming without value. any help please. I...

In my Access 2000 mdb I am trying to create a report that must choose the correct mailing address to send the letter to... The database holds 3 sets of...