I have two tables, Demoraphics1 and Demographics2. In Demographics1 I have a lot of different data of which ID and Age are two sets. Demographics2 contains...

Hello, I am trying to create a query from table Recruits that shows the last 30 days recruits sum from todays date and the last 30 to 60 days recruits...

How can I make a query in Access that will automatically include newly added fields in the SQL query statements? I want to be able to add a new field and then...

Hi everyone, thanks for all the help you've given me so far. I now have a new problem I haven't been able to wrap my head around. I have a table of updates...

Hi all, Access 2003 - I'm trying to get a list of birthdays grouped by month. My db has "Clients" and "Spouses". I create a query for each of them filtering...

I have a couple of linked tables - one contains a list of customers and their balances, and the other contains product information for every customer. ...

Why is this giving me two rows for 2 different contact_id's when the mailing address for them is the same? When run alone, the third select brings back only...

Hi, I have a products table linked to a shipments table which tracks the dates of the shipments of each product. The tables are linked by ProductID. How can...

i have a simple query that references a text box on a form as a parameter. the text box holds a date and uses the Short Date format for its Format...

I have an unbound date field that displays the date on a calender when the a specific date is pressed. I am trying to develop a query to look up records based...

I have a single query constructed such that I have a number of separate SELECT statements that prompt the user for input, and each of these is joined by UNION...

I have a query that looks at a field containing a date and time (Availability Goal). Based on the this information, I want the query to find the next...

I've seen similar postiings but can't find the right answer... I've got a form with 4 combo boxes (location, start date, end date, customer). I want the...

I have a table of data (.CSV file) that I'm trying to use Access 2003 to analyze. Each record within the table is essentially a business day (Monday-Friday)...

I have a table of data that contains a record for each BUSINESS day (Monday-Friday) of the year. The table/date does not contain any records for non-business...

I have to table in a field a from table 1 I type 3 name and in a field a from table 2 I type 5 diffrent name I want to mix them in a 1 field by query I need...

I have a field called the calcel date. It is either blank or have a date in it. I need to produce a query (which leads to a report) that would exclude any...

Nikon D90 DX 12.3MP Digital SLR Camera with 18-105mm f/3.5-5.6G ED AF-S VR DX Nikkor Zoom Lens Price:Too low to display Image:...

Is there a query or another way that I can change the way my data is arranged? This is how the table is now: Address, Name 105W 200N, Paul 203N 500E,...

Hi, I have an MS Access Table that I use to store log information and it looks something like...