When running a query that picks values fromm multiple tables, the query fails if one table do not have a record that matches the selectrion criteria. I.e. I...

want to group more than one campaign results together. I have 3 queries for each campaign to get the results then the 4th queries format some of the...

How can I use the format function in a query to filter records for a weekly report. Similar to the Month and Year format in the report wizard.

Hi, I'm trying to figure it out where I can enter the date myself rather than using "DATE ()". 1) I create the queries and it's work but this is not what...

I have a sales table that has rolling totals by week (7 days). Day 1 sales = day 1 total. Day 2 sales = day 1 + 2, etc. I can figure out a given day's total...

I have a table called t, it has three fields called CustomerID, DateOrdered, QuantityOrdered. Now I want to know how many items ordered totally in each...

I have a table containing prices for items, linked to a customer database. One key is CompanyID, indicating what company the spesific price is valid...

I need to put first and last names in an expression. I have done this but how do I put a space between the names?

I need to create a primary key field on a table which already has 2500 records. Is there a way I can filter a query to only return records whose primary...

I wanna prepare a make-table query. I have a field name with "number of students". there are values like 0,1,2,3..etc. in it. What I want to do is that when...

Simplified, I have one customer table with customer no. and name and one order table with customer no, order no, valid date from and valid date to. That means...

Need help trying to figure out how to make a 2 field query showing multiple phone numbers (home, business, mobile) with the contact ID in the...

How do I go about getting the programs that are in "programs" to be alphabetized? I have Windows ME. thanks in advance. cl.

I have a questionnaire database that contains participant’s demographic information such as age, salary range, employee type, age group,...

Please explain why there isn't an Append Update Query function. How can I create a query to append and update data?

I have 2 dates I want to know how many days weeks and months went by (for rental purpose) I did Days: - and this gives me a flat number of days (26 days, 13...

Hi, I'm having what seems like a common problem where ' (apostrephes) with a record are causing trouble when run through a query. I've read about double quote...

I have a table where there could be multiple rows for each lender which I would like to combine in a query. For example: Lender Property Type Lender A ...

I really need some help. I have been trying to get this to work for hours but can't solve it. I have a list of Facilities that were inspection (tbl1). In the...

Hi there, We've just converted our Access 2000 databases to Access 2003. A simple SQL query: Select ID, format(MaturityDate, "dd-mmm-yy") as MatDate From...