Is It Possible To Generate An Auto-Incrementing Field? You know a field which just counts to the last record. Field Name 1

Since Access XP wont work with templates from 2000, where do I get templates for my version of Access? Microsoft jumps from 2000 to 2003 with absolutely...

Is it possible to somehow set the input to select top to a variable or at least use some other method to get the same effect. If I could just use something...

I have an Access table built with some relationships. It has an autonumber as Primary Key. I have an Excel file with all (except Primary Key) fields the...

I have about 20 fields of Yes/No data type. I would like to do a parameter query where I type in the name of a field, and it will display all the "Yes" of...

I am trying to build a report from a query, and here is what I want to do: We have a table on our main database that lists production, by date, for our...

I would like to make a query that would assign a value to yes or no. I am working on a database for church. I basically have to keep up with the points for...

I need to take a field that has a full name "First M Last" and split it into three different fields. All names use a space to seperate the first, last, and...

I'm creating a database for someone that contains a list of employees. Every 6 months they need to randomly select employees to partake in testing. I've read...

Hi all, I am making a new table from a query O.K. Upon running can I input the number of records I wish to be copied (say first 500). At the same time can I...

Good morning, I am trying to create a query which lists the price per day for a date range. If there is no price for a particular date however, I wish it to...

I once had a macro, where I first used a query to create a temporary table, then made use of this temprary table in some append queries to add records to...

Both queries perform the same function (at least it appears that way). Which query is better from a performance stand point. #1 SELECT...

Hi, I have a table with field physical damage (number) and this can be either 0,1 or 2. I need to calculate the percentage of occurrance for when is 1 and...

Hello! How is possible to type for example "à uinetas" and find a record stored in the database as "á uiñetas"? I'm looking to remove all the accents (or at...

I have two tables:- table(A) contains a date and a numerical value which can change at varying intervals (weeks, month etc.) Table(B) contains "date" (daily...

Using MSCAL.calendar.7 as calendar control in form. Need to use date selection output as criteria in query... need to reformat date in critieria to...

I have a query that accumulate the sum of material. The query has Material, Qty(sum), Assemble (Check Box) which is set to 'NO' and Material Type. If the...

I have a table with two fields. .... DATE and ROOM. I would like to total the number of hospital rooms completed on each floor on a specified date. I...

Can anyone pls help with calculating the previous Sundays date in visual basic, I need this as a default value in text box. Thanks.