I'm stuck on this one. I have two tables - tblContacts and tblHistory. There is a one to many relationship (1 contact to many history records) linked on...

Hello, I am creating a text expression in a query where I am concatenating fixed text phrases with a data field (eg. "See the picture at...

Good morning all, I have a query that have records of route and stop information, I need to put a sequence number starting from 1 to n (n is the next record,...

How do you allow a query to accept data to input. Pretty sure this works sometimes and not others. So if I have a form that looks to a query for information...

HI.. i need help on solving one big problem i can't get the solution.. I have a query that gets some values and also a month text from one table.. based on a...

Hi, How is it possible to merge 2 different tables together. Table1 has AddressID, ApptNum, ApptDate, CompletedDate Table2 has AddressID, NANum, NADate,...

Hi, I have created a query of personnel info which I am exporting to Excell via a macro with OutputTo. For printouts In Excell we are going to need page...

Hello, I have a Form with a subquery on it via tab control. I have one combo box on the main form that has employee names in it. When I select an employee,...

Hello everyone. It seems like I am posting daily these days. I have only been using MS Access since Novemberish and I appreciate all of the assistance I get...

Hi In a query I have gone to properties and changed unique records to yes but I am still getting unique records the query is one field only Any...

I have 2 queries that I'm desparately in need of help with... 1) I have a date field, where the date has been captured in either yyyy/mm/dd format, or...

Hello all. Yesterday I built a query, which had the source of two other queries. Built a report and everything looked fine. Today, I went into the report...

I am not a guru with access and this problem has me puzzled... I have a table wiht multiple months of data. The key fields are a cost code, report date and...

Hello, I am attempting to make an If-Then type expression that will give me multiple "Else" values. (doesnt have to be If-Then, any variation that will work...

Hi I have been trying to create a query that will find the duplicates accross and number of fields to bring back the values that need checking for...

When you create an action query in design view access provides a popup widow that allows you to select "Current database" or another database for Append...

I have reports that list the All Invoices for the "Current Month" & another for "Last Month". With the "Last Month" Query I have the date parameter recorded in...

Hi, Is it possible to insert all the fields from a query into a table using SQL code? For example, I have QueryA with 30 fields, but I don't want to have to...

I've created a query in Access which pulls out data on a rolling 12 basis (showing data for the previous 12 months), using the following expression: Between...

Sorry I've been away so long, people, but I've been immersed in Web 2.0. These newsgroup posts take too long to open and read, so here's some quick-fire...