Objective: Employees that are scheduled to be off today should be excluded from the list of available. I have 1 table with 2 text fields EmployeeName and...

Can anyone help me to determine a discount formula? I need to perform a QBE Query with a 15% on the price. I know that I have to go to design view, and at the...

I have a select parameter query that uses a form for the selection criteria. I want to be able to leave the field null on the form which in turn will select...

I want to keep the master list in tact, only deleting the duplicates in the second one and then creating a new list from that. Thanks alot -- Flo

Can this be simplified? UNEstNtWt: IIf(.="WT",Round(*0.05+, 6),IIf(.="VOL",Round(,6))) Thanks in advance!!!

Hello - I have a query that modifies a dataset that I have, and it is ALMOST working the way I want it, however it needs a small change and I can't figure...

I have enter the following statement and the results I receive are correct except that each result is repeated over 900 times. How do I get it to give me...

I have the following sql statement SELECT UTADBA_PARCEL.PARCEL_ID, UTADBA_PARCEL.LINK_ID FROM Serial INNER JOIN UTADBA_PARCEL ON Serial. =...

Anyone know how to write a query that can insert a blank row into a table after a set of criteria? Example: Pretend a set of data is sorted by START DATE....

I would like to create a new record for each loan number that is in a certain criteria/status. Would this be an IF statement? Thank you.

Hi, I am using Pivot Chart view (Stack Bar) of a Crosstab Query to display Yearly Sales by Quarter: Year Q1 Q2 Q3 Q4 2007 10 15 ...

I am trying to calculate "Total Hrs per Student" by adding (across the row) the duration which is the number of hours a student spends per session with a...

Hi, I have a table, Tickets, with a field, Manager, and about 4000 rows. I have another table, called Managers, that has 20 rows, listing every possible...

Hello, I'm trying to create an Access form based on two different queries, but I get an error message stating that I may need to choose fields from only a...

I have the following sql statement SELECT UTADBA_PARCEL.PARCEL_ID, UTADBA_PARCEL.LINK_ID FROM Serial INNER JOIN UTADBA_PARCEL ON Serial. =...

I am having a hard time writing a query to check for availability (time wise). I have a table 'tblUsr_Avail' which has 3 fields 'sDate','sTime','eTime',...

i have a query bound from a table i have this field.. Qty of Shts Physical Progress Size_value Eqv A Size Earned A Size i need to this...

I am totally at a lost on even what to do here. Below is a sample of over 13,000 records that need to be analyzed and reported. The goal is to analyze each...

Hi, I have the following union query. It work fine exept that the result set does not sort (on second column). SELECT tblTargetCommunes.TC_ContactID,...

Is it possible to remove multiple spaces? For example, I have data imported into a table that presents 5 spaces before the first character. I want to...