Could anyone please assist me with the generation of Invoice numbers
in queries.
I have a set of monthly invoices that are printed from a report based
on a query. I wish to be able to nominate the starting invoice number

This is a query I've used regularly in Access 2.0 and Access97 with no
problems.
Interesting enough, when I remove the "Document No" parameter, I don't get
an ODBC error.  Instead, I am prompted for the "date" and after I type in

I have a list of events in a table.  Some are repeating events.  I want to
create a query that will EXCLUDE certain events. In otherwords, when I run
the query, I want to NOT see certain events based on the ones I exclude in
the Query design.

Database for school applications. Father table linked to Mother table linked
to Student table.  I want to delete where the student ID has no father -
which can happen if data entered incorrectly.  I have designed a series of
select queries to identify the records to be deleted ...

I do not really know anything about SQL and would like to know is the
following is possible?:
I currenly have a ODBC link to our Drawing Database.  The table is called
dbo_DRAWMOVE.  Within this table the are the following fields:

hi
how i can find specific words into a text field using a parameter , i want
everytime to looking for different words .
thanks

I am performing an append query and the Invalid Argument message appears.
This code has been working for years. I've tried to isolate based on some
particular record but that seems to produce nonsensel results.  For example I
extract and isolate records 3000 to 7000 on the ...

I tried to use a control as a criteria of a Select command in a Combo Box but
the returned value d'ont atualizes after the second query. Therefore a tried
to use a variable as the criteria but the select command does'nt worked
properly.

I was wondering if it is possible to make an Append-Query run on its own,
lets say every minute or every 5mins, 10 mins, whatever the case.
The reason why I ask is that I have a table that has all the info relating
to an entry that is required.  These entries are later bundled ...

I'm hoping that Tom Ellison still is about on this page. I've just been
reading his posts for "help with calculations in a query" 11/04/2005 - Which
I have a similar problem with and have previous found help with on this site.
My problem is reading metered gas on consecutive times ...

In Access 97 you were able to write a parameter query that would get it's
criteria from a form control.  
I just recently upgraded to 2003 and can't seem to do this.  
Can anyone help on this?

I have a table that I need to pull only the max date for each item.  I will
give an example below.
Item          Unit of Measure     UPC           Effective Date
3                       EA               111                 8/8/2006

In the 2003 version, my queries were working fine.  Now in the 2007 version,
when I pull up one of the same queries and try to switch into Design View,
the following error is displaying:
    " is not a valid name. Make sure it is a valid parameter or alias name,

I have three tables, one for tools, one for signing them out and one for
returning them.  Trying to kill two birds here.  First I have been trying to
figure out how to return a result for the first time a tool has been signed
out but not returned.  Second once they have been ...

I need to measure the tallies in the "SEVERITY" column over the last six
months from the date range in the "START_DATE" column.  I hope that makes
since?
Table Structure: