Hey all .... I have a query where I would like remove the parameter prompt and automatically obtain records between the 16th of last month and the 15th...

Hello .. I imported data from excel to a new table, and tried to append it to an existing table in my database. There are less fields in the import (named...

Hello .. I'm not sure where to post the following. Originally I posted it in the general access newsgroup but have had no reply .. apologies if this is also...

Hello, There is a line number in a detail form for a list of an employee's expenses. As far as I can see I cannot use the "auto" number feature as the...

I have problems using dates as parameters in select queries. I changed the date format from mmddyyyy to ddmmyyyy. Initially my parameter query where I select...

Hello .. I have a parameter query, which asks for the Initials of a Technician which works fine, but I would like to be able to select all records if no...

1. I am importing a text data file in access which has text fields enclosed in double quotes e.g. "George Brown", I would like to create a query remove the...

Hello .. I am trying to create a query to update a field with a sequential number (not starting at 1) on certain conditions, by adding 1 to a value in a...

I have just inherited several databases that have been set up with year names as part of the field names (2007Total, 2008Total, 2009Total, etc.). Each year...

Hi. I am trying to write a sub query for an Audit Log that shows only the most current change for this sku. I have to pass the sku in, and it works fine for...

I have 23 employess all with varied skills. What I want to do is have a list of their capabilities, 8 categories to be precise and a list of their days off...

I want to transfer an access db to another computer. There is no cd burner on either pc. Can I put it on a floppy and then be able to work on it on the 2nd...

sI have a database that records people and donations they make over time. There are two table 1. Donors (with fields: ID, last name, first name) and...

HI- I have two tables 1. Donor information (with fields: ID, last name, first name) and 2. Donations (with fields: ID, gift date, gift amount). I have set up a...

HI- I have two tables 1. Donor information (with fields: ID, last name, first name) and 2. Donations (with fields: ID, gift date, gift amount). I have set up a...

I need to sort my query by group. Table created from electronic feed. User filed is made up of Division (320) / Person / Group examples: 320 Hurst, T ADM 320...

I've created a query with criteria to find all records attached to a specific item number. I also want the query to pull all item numbers. For example: ...

test

I want to use an unbound form variable in a query as a parameter, please tell me how to do it?

I have column licenseNo, it want to find out the duplicate values in that column, please help me out