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 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 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 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 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...

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...

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.

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...

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...

I have a FirstName and a LastName field that I am trying to join in a query under a column named Owner. The method that I am trying is as follows: Owner: & "...

Hello, Can anyone help me with this problem? I need to append a flat table to two tables. I have two tables Observations and ObservationsB that are set up to...

i have a table that includes records for multiple deals (i.e., 100 records for deal ABC, 125 records for deal XYZ). from that master table, i would like to...

I don't have a ton of Access use experience but: Job Titles is a column in the database. In Queries, the user can type in a word and it will find the job...

In Access XP, I'm trying to use the values of several calculated fields to create additional calculated fields, all within one query. Is there a way to do...

I am trying to apply a label field to a query record based upon where it falls in a second lookup table. The look up table has a start date and an end date...

Hi all, Simple: I want to write a query to import data from a flat file(comma delimited) into a exisiting table in access using Access 2003? I don't want to...

Thank you for your readings. I have Quary1 and Quary2. Quary1 has text1 and Quary2 has text2 as fields. tex1 is same as text2 except it's orientation in a...

This is a complex query that shows debt agings for all our customers from CURRENT, 1-30, 31-60, 61-90, 91-181, 181-360, 360+ days. I have 2 tables joined,...

I have query that is the source for a sub-report. The main report using grouping (person, client). The query uses the client ID that appears in the client...

I have created a form from which to create tailored reports via several unbound input fields. There is an underlying query to form these reports. What I am...