I want to add a query that creates a table on;y with information from a
certain date.
To specific it would be from 01/01/2007, but I don't necessarily want to fix
that date as I want to state anything that was worked on this year.

I have a validation rule in the table to specifically enter one of 8 state
abbreviations. ="IA" Or " IL" Or "IN" Or " MI" Or "MN" Or "MO" Or "OH" Or
"WI"
The Validation text that appears if not followed is Not a valid R3 State

Isn't there a simpler way of doing a pseudo-autonumber in a query?
I saw in one post someone mentioned doing a subquery (IncNum: (SELECT
Count(*) FROM thetable As X WHERE X.sortfield <= thetable.sortfield)).  That
might work on tables with small number of rows, but I'm working ...

I have a scenario were I am managing an inventory database.Each item stored
is based on a project. Once the project is over and if there are inventory
spares left out , the items should be moved to a table called Rawmaterial to
be used for future project.

Sorry if this posting shows up twice, I think my first post attempt crashed...
I think I am missing something fundamental but I do not know what. I don't
know what this issue could potentially be called so searching forums has not
been helpful.

Hiya there. I'm building a query, where by it includes a parameter e.g.
[Please enter Application Name:]
If the user searches for a word 'aim' its okay as that's listed on the
actual records/table as 'aim' but if the user wants something from 'adobe' in

I have 3 tables that are joined by the field [addnr]. I want to query table
one and get a result from table 3 by going thru table 2. The problem is that
all 3 tables have the [addnr] field but values in table 1 are not found in
table 3, only in table 1 & 2. And table 2 & 3 are ...

Hi...
I get the following error when trying to run a query that has a concatenate
thinghy in:
Undefined function 'Concatenate' in expression.

Afternoon,
I'm having a big problem with a form which generates various SQL statements
based on combo boxes.
I have found out that SQL uses US date formatting but whats happening now is

Need your opinion for this queries,
In one of my field's table, i have mix hex and decimal value. Since i just
need only hex value in my queries, i need to convert or change the decimal to
hex. The possible function, in my mind is using function IIF([myfield] =

I have a field in a table called a Job Site.   An example of a record I'm
having a problem with is as follows:
SR-099 MISSION SITE
SAN ELIJO INTERSECTION NE

Hi. I have a query that search between dates.
But once the main program from where my linked has Date and time together I
had to make a short date:
I had this:

I have a query "Emp" running from a large emp database based on date criteria
- a parameter pops up to input the beg date and the end date.  Then I created
a crosstab query based on the "Emp" query, that will group by emp team and
then emp name within the team.  Across the ...

I have a database that I just created.  This table that I am working in is
InvoiceTable.  My first field is Job #.  This is a drop down menu from a
query off of the POTable that has found the duplicate Job #'s and
consolidated them.  My second field is where I am stuck.  The ...

I have a table with customers and orders.  It looks something like:
Date / Customer / Order
1/07 / James / Stapler
2/07 / James / Paperclips