Hello all,
I have the following formula for one of the fields in my query, and I am
getting an error message "Invalid Procedures Call".  
Exp 1: Mid([Student]![Student Name],InStr(1,[Student]![Student Name]," ",0),6)

I am trying to remove all characters after a tilda sign:
original field text:  86.HCGS.100794..GTEW~MPVERC
desired field text:  86.HCGS.100794..GTEW
I created the following module, but it does not recognize the "*" wildcard

I'm trying to create a query that will calculate how much someone has
contributed year-to-date to their supplemental health care plan.  Basically
the employee agrees to contribute an amount of their choosing.  This amount
is then divided out so that the individual pays a certain ...

Hello Reader!
I have designed a query with two tables. One is linked (with Sql server
2000) table and othe is Local table, I have defned relationship between One
field (both are text fields). When I try to execute this query, execution

I have an employee dbs that we use to keep track of all employee info.  We
are beginning to use the dbs for more - to keep track of schedules and # of
employees on duty in an hour.  I am stumped.  I need help starting with the
tables and then i would to end up with rpt or ...

SELECT Q.*, D.TargetDate AS GRRCHTarg, D.ActualDate AS GRRCHAct
FROM (qryRpt5YrProgress4 AS Q LEFT JOIN tblPkgDates AS D ON
Q.[5YrPkgID]=D.PkgID) LEFT JOIN tblPkgDateTypes AS DT ON D.DateTypeID = DT.ID
WHERE DT.DateType = 'GRRC Hearing';

I am working with two tables. Each table contains a field for a zip code.
Table A has an 11 digit zip code and Table B has an 11 digit zip code. I
currently run a join query to capture all matching records.
Table B also has zip codes less than 11 digits. I am trying to write a ...

I am creating a Vehicle Bookings database and have created a query which
identifies any clashes for bookings of vehicles to eliminate double bookings.
When a user books a car, i would like the database to check with the query
to see if the vehicle is available and if it is, accept ...

explain me the steps to use the dlookup function like how we use in EXCEL

I have not used access in awhile.  I have dumped a lot of data into an access
database and I need to compare two date fields that would essentially need to
measure the number of days between the invoice date and the payment date.  I
created the following expression, but cannot ...

Hi everyone, I'm trying to create a SQL passthrough query or SQL view and
this ones driving me mad!
SQL Server 2000 for back end
Access 97 for front end

I want to build a query where the data from the table products1 to be
inserted into the table products.
I have made he following query which does not update :
UPDATE products INNER JOIN products1 ON products.Productid = products1.

I have a Crosstab query that uses a rolling 6 months of week numbers
for column names but will not sort the week numbers in order of the
date.
TRANSFORM Count(test.Status) AS TEST

i have here for my database some investments...
and then, for every investment, there are different terms which the user will
choose from...
either days, months, or years.. and then i want the maturity date to be

Someone please help.  Is there a SQL or Visual Basic statement that can be
used to set/change the values in a field in an Access 2003 query to a default
value?