Hi, I am trying to write a query that would allow me to calculate the proportion of a specific value in a field against against the sum of all the values in...

I am creating a small database to collect labor information on a job by job basis. I will have the operators logging information into the database using a...

I'm sure this will not be too advanced for someone but I'm lost with it, I'm using Access 2000. I have a table with almost 1 million records and 8...

Hi, I want to create the following query: SELECT .., ., ., . FROM 13 WHERE . NOT IN ('*REQ', '*RA', '*MNA', '*MA'); But I get error from Acces regard the IN...

Hi ALL, please help How can I capture result of this SQL in my Textbox(txt1.value): SELECT Max(+1) AS Expr1 FROM TBL7 INNER JOIN country ON TBL7.Country =...

Hello guys, I have a table, say tblItem, with a primekey. The second table, say tblCustomer, contains the foreign key to the first table with a 1-to-many...

Hi all I have a main form which displays contact details for a particular person, and then a subform which currently displays the name and position of all...

I'm doing a long conditional statement that checks if 2 fields have 0 or 0 values. It must be a problem with the syntax I'm using. Here's my code that is...

I am using a query as a mail merge source. I have some e-mail address that are duplicates and I want them to be maintained that way in the table. Is there an...

Hi everyone, I am hitting a brick wall! I have been trying to "flatten" a Table generated by a Maketable query based on a Crosstab query... The reason behind...

Each day I must review a multi-office list of files identified by "Claim ID". I append these daily lists into one table, then use a query to pull the files...

I'm getting this weird error. Does anyone know what this is? Runtime Error 3188. Could not update; currenlty locked by another session on this machine. This...

Hi, I am new to access i have a database and need to generate reports based i=on that, eg. 1 Volume of work in to process. 2) volume of work completed, 3)...

Can Use the the Today function with a Perameters Query. Something like... between and Today ? Thanks for the input and have a great day.

I'm really stuck. Within my database I have two related tables. I would like to search within 6 fields of one table and pull back any hits in terms of a...

I work with a large amount of data in Microsoft Access, where a client could attend a hundred appointments all on different dates/times. Using a query, I...

Hi Thank you for using time on my issue. I have created a query "quyRoundPrices" that give me the following result Year Round FirstP SecondP Long ...

Hi, I have a table (with 1000 records) which I use to append data to. It has a auto number field contains number from 1 to 1000. After I deleted the 1000...

Is there a way to do something like an if else so that I can run one of two selects based on a form field? Something like IF form!fiield = true selct...

Is this possible: I have 2 tables: Schedule and Monday Monday has the fields called Monday (date field and primary key) Slots (number) Schedule has the...