I suddenly have a problem mail-merging labels and letters in WORD from an ACCESS Database. I am guessing it is an incompatible problem but I just can't seem to...

Hi, I have a number of queries from which I want to export to excel. I can export a query to an invidual workbook. But how do I export another query to form...

I am in the beginning stages of setting up a call database that tracks calls made by sales people. The table includes separate fields for date and time. A...

A table lists all the shipments by item, by order line, by date from the year 2003 thru the present. One of the fields is a week number, YrWk, where 200420...

I came to this group to ask why I was losing most of my memo fields in a UNION query, but John Spencer posted earlier that "Crosstab queries, summary queries,...

I have a form that displays an outing for members to sign up. There is a subform where I display the members of the organization (via a combo box), using a...

Hi, i need a form where we search for a detail and the result should be published in the bottom, based on the result the user will decide what to do next in...

I need to round either up or down to the nearest quarter. Is there a function in access that works like Mround in excel where I can pass it the number and...

I have a combobox with an event that adds a record if the 'id' doesn't exist. I try to requery the control (combobox) but I get an error 2118 saying I must...

Thanks to John Spencer, I resolved one problem in my union query (Thank you, John). But I have another problem. Some of my fields in my union query are...

I have some queries whereby I need to join two tables based on two date fields that are in both queries. Sometimes date 1 or date 2 will have NULL values,...

Calling all query gurus! I have a crosstab query where I group on two fields, and I can get the query to show all the first field but not the second. By...

I have created an unmatched query using the wizard. However I wanted the query to check more than one field before returning the unmatched records? Any ideas?

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

I have a list of numbers( that come from a formula--Eg. FR1 + FR2) in one of my query fields. I would like to take these numbers and give them a ranking. The...

I placed a question on here a few days ago about wanting to take a SQL statement behind an Access 2000 query and use it in a VBA statement. More specifically,...

Hi, this is a little complicated... I am working on creating an ASP page which uses an Access database (on the internet). In Access I created 3 nested queries...

I have a table that tracks each customers visit to my store. I hold promotions on occaision that bring customers that haven't visited my store in awhile....

Hi TT, just in case "TT" 'tt' (other post) Another clever method Michel once demonstrated: NewField: IIf(True,Null,#1/1/1900#) -- you end up with...

I can create a pivot table to show data from a query in the view that the user would like to enter the data into. However, the pivot table will not let me...