I have a table in access that needs to be exported to an Excel spreadsheet. One of the requested design specifications for the resulting spreadsheet is that...

Using Access 2003, I want to write a query against information in the following sample format: Manufacturer Item Number Source System Acme ...

I am using Access 2002. I have a project that uses the "Find Duplicates" query to display duplicate records in a table, using "Part Number" as the field that...

I am already pretty frustrated with so much to tinker with OL2007. A year ago I loaded OL2007 to my laptop and migrated all the info from my previouse...

I cannot figure out how to write a report using two tables or queries that have NO FIELDS in common - every time I try it says they have to be joined by a...

I have an access database with a table of info for the past year. 236 records for each day x 365 days. What I need is an access query that will give me an...

Access 2003 I have a table with three fields. All the rows in column A and C have data in them, however column B may or may not have data. I need to create a...

In the design grid I have created a total line that has several group bys and firsts. I get the data I need but the column headings now say firstof and then...

Is thre a way to find out what make table query created a table? For example, I have a table that I created a month ago but can not remember what make table...

I have a column of 5 digit julian dates (ex 08066) that I need to convert to a calender date. The julian date is formatted as text. I am using access 2003. I...

I run a query in access 2003 and use the group by and first functions. Everything works fine except when I create a table from this data the column heading...

I am using access 2003. I have a query that pulls data based on group by and first in the total row and the data is good. My problem is when I create a...

I have the following set up as an expression in a query. ETConvert is a Time (Date/Time field). NewShift: IIf(=#6:59:59 AM# And ="B","A") Or IIf(=#6:59:59...

I have a table which includes a field for Date of service, a field for Test Code and a field for no. of services., and a second table which has these 3...

Hi, I have a cross tab query with hour of the day as column heading. The result shows hours, 0,1,2,3……..23 as columns, a total of 24 columns, I am...

Is there an easier way? Currently use in a query: 1.) DatePart("w",) = 5 and 2.) Day() = Between 15 and 21 and is the field name in a table with MANY...

Earlier this week, John Nurick helped with the answer pasted below. I have tried everything to try to make this work, but when I get to the part about the...

have a text field with a lot of different data in it. Here is an example: SERV: PS NJ////SAR #155097//OH #08468////SAR #158097//OH #08469////SAR #158098//OH...

I need text to number format preceeding with zeros or text to be right justified or preceed with zeros. I am importing a raw txt file into a dbase but there...

I am running a query on Sales data, which contains Opportunity Status and Fallout Reason field. In the Opp. Status field, the options are Closed...