I have 3 tables Customer, Items and Purchase.
Customer and Purchase are connected by ID. With what query do I record all
the changes that users make. Lets say... new purchase was made but it changes
the current item and does not record who had that item before.

What would be the syntax to select random 500 rows from a table containing
40K rows?
Thank you for all the help.
Regards,

I would like to display totals from 2 different formulas in query.  If
condition a= xxx *3.20, if condition b=xxx *0.59.  I don't have a clue on how
to use the iif statement.  Thanks for your help.

I’ve a question about selecting records from a table into another table.
I’ve 2 tables, T_OE_Occurences and T_OE_Occurences_Queried.
What I want is a query that copies current budget year into the table
T_OE_Occurences_Queried. Our bookyear is from April till March.

I have 2 SQLs that work individually to provide a single date in a drop down
combobox on my form (see below). How do I combine the 2 SQLs to setup a
single SQL statement to provide a date in the following scenario? If I select
a PSEID from the combobox and the PSEID is not found in ...

I need to write a query to help me clean up some letter codes in my database.
The codes could have any of the following formats...
XY001.01
AP002

Hi
I have this sql query designed to show the top 10 records in a given field.
But I want to modify it so that I can use this one query to step through each
of the given fields and append them to the final report as opposed to having

I have two tables in Access 2007 which have a 1 to 1 relationship.  When I
try to run a simple query I get the following error message:
"The wizard is unable to open your query in Datasheet view, possibly because
another user has a source table open in exclusive mode.  Your query ...

I have a column [days] in my access query that houses a formual of [dte of
pay]-[dte ref].  The results of this formula calculate into a range of 0 -
2281 days.  What I need to do is create another column that will tell me the
number of months it has been.  So, I if [days] ...

Is there a way to use Jet SQL to modify field properties such as DefaultValue?
I know it may be something like ALTER TABLE but I cant find any text on its
usage

Hello, I am trying to create an IIF statement to test if the first character
in a field is a 1,2,8 or 9.
Something like the following:
IIf(Left([possible_SO_match],1)="1 or 2 or 8 or 9",[Possible_SO_Match],"No

In Access 2003, is there a way to force the field size on a text field in a
mktbl query?
I am linked to a SQL table, the field is 16 characters, but I need the text
field to be 17

I have table "closures" that I am trying to run a delete query against. I am
trying to use a pass-through query (connected to Oracle) as a dynamic filter
so I am only deleting pertinent records. I get "Could not delete from
specified tables" error. I have read through similar ...

I know this is a common question, but I haven't found a complete answer.  Is
there a technique to generate a sequentially-numbered, calculated column in
an Access query so that the records in the query output are numbered 1
through N, where N is the number of records ?

I would like to know if there is a way to do sub-totals in a crosstab query.
I would like to have multiple sub-totals by Location name, Salesrep and
Region.
Thanks.