I have a part number field that had to be defined as text due to the make up of the part numbers. I need to query for a number and it will not find them. How...

I have a make-table query that is not sorting consistently. I am sorting on one of the fields in the query, CAMPNO. I ran it once, and manually looked at the...

I have generated the criteria that I want to use to filter a sub report, into a table (the values for this come from a list box), and since the criteria need...

i'm using a2k and am starting to get the error in the heading about 'Item not found in the collection' when i execute the following VBA code. i've read a few...

I have a summary query where the records are grouped on the following fields: -SaleMonth -Car -MileageBand -RegPlate And the only other field, 'Price', is...

I have a few different tables that all have the same information in them but the tables are split up by different departments. I want to do a total count of...

I want to update a field called "rate" in the "department" subform table from a field called "rate" in a temporary table called "sheet1". I am getting...

Using Access 2003, is it possible to have a query create a text file with no user intervention? Thanks -- Bill Gable

I need to redefine the date of entries to match a 24 hour schedule that starts and ends at 06:00 each day instead of 00:00. I haven't been able to find...

I have an access table I want to change: text field 444 444 444 to a number field 444444444 text field 444-444-444 to number field 444444444

I have a database full of enrollment numbers for each month of the year. The date field is formatted - m/yyyy. I want to do a query for September enrollment...

I have a parameter query that requests the user to enter a region. I have a field that contains 12 regions numbered 1 through 12. I often need the same data...

I am working on a query that has a created column based on one column with codes in a lookup list from a table in the database. This new column...

I am needing a query to power a report that my boss wants done by this friday. i have been working on this report for a couple of weeks now, without getting...

I want to join two tables A and B. Both have multiple columns. The field that is exactly the same for two tables is "Phone Number". I want to put all fields of...

Hi I am trying to create a query to group pathnames when all I have in my source table is a fully qualified filename. ie I have a record that looks...

Hi, I am having a lil bit of a problem trying to do the Following ... I want to have a Query which brings up a Combo Box / Drop Down Menu, when you choose...

I am looking for a more efficient (read faster) way to append new records to and update existing records in a master table. My master table, tblMaster, is...

I am running a query that prompts for a date and runs a week from that day. Right now, no matter what is entered, it returns all of the records in the table....

I have a query that I want to compare food cost from month to month. I want to parameter the months using a form. In the table the months are dates and in...