I have a database with a header table and related details table with the following structure.
1) The Header table has a Primay Key Code of type text.
2) The detail table has a concatenated Primary Key of Code and Date which are type text and text.
3) The relationship has been ...

I first tried to join the CAN Number fields in both tables.
The error below pop's up????
Type mismatch in expression.
Second:

I have two tables:  Table 1 has a "family number" field
where all students in the same family have the same
number.  I want a field in table 2 to be the letters "GP"
plus the related family number in table 1.  In other

I have established to calculated labels in two different
tables by concatenating 3-4 different fields on both
tables.
I want to join the labels on my tables since they are

If I want to create a table for Invoices, what is the best way of
incrementing the Invoice number from an arbitrary start point.
Would it be:
1. Use an Autonumber field?

I am looking for a simple way of automatically including a
users log on/ user id when they alter data within a access
table / form.

I am working an MS Access db for controlling contractor access to controlled facilities.  Throughout the db I use the function "Date()" and "Time()".  Recently the db program has been producing errors that basically state the functions are not recognized.  The same error has ...

Does anyone know if you can develop an ACCESS DATABASE for a point-of-sale terminal
There is a Dell POS terminal that offers CRS, GERS, RETEK, PowerPay, TCI (as well as other) icons as retail software solutions
I need to create a database for a single terminal.  I would like to ...

how come my memo field in access always trims the trailing spaces? acccess
97.

Can someone help. I have some pivot tables that I am
using.  I am grabbing the data from a form (where the user
will enter the information".  For some reason the pivot
table cannot be updated beyond this point.  Can you only

hello - basically i want to create a unique ID but i want it to b
something specific i choose (such as MS1, MS2, MS3 etc.) but i woul
like it to carry on into new columns automatically like autonumbers d
- can anybody help

I am new to relational database design and have just hit upon the idea that with the project that I am working on I might be better off using one large table (more fields) and not trying to relate multiple tables of data
If I do it this way is it reasonable to use Access to enter ...

I was wondering if anyone else has experienced this
problem?
When I use an "&" sign on a form or Switchboard, it is
replaced with a "_" once the form switches to form view.

i have a field as date/time and i want to put a
validation rule on tis field so that any entry that is
more than 7 days ahead of the current date will be
refused with a validation text any help will be very much

I am starting to track shrink in a produce department for
a local grocery store. There are 35 items all together so
far that could be tracked but some are not always used. I
have created a form to list each item, give it a