Greetings forum members:
I have a simple inspection data table that contains the following five fields:
1. Primary Key
2. Asset ID (Duplicates OK)

I need to know how to get a combo box for possible answers to a question I am
asking when I run a query...so that the user does not have to type in his
answer, just select it from a menu?...Thanks

i found some examples of criteria language online. I don't think it's
correct, if it is, i don't know why it's not working.
I'm looking to pull some records where the number is less than 400.
What I found what

I am exporting data from the database and using a query to gather that data.  
There is a field that is causing problems. This field is kept in a different
database that we access via ODBC, and it is a text field.
I need to convert it to number field or remove the leading 0's from ...

I want to use a query that returns records in the current month from a
date field, but cant work the query out - anyone help please
Thanks
Alec

SELECT Ingredient,MenuItem, NumberofOunces
FROM tblIngredients
UNION SELECT ItemName, Ingredients, NumberofOunces
FROM tblInHouseReceipt;

Is it possible to create multiple identical records in a select query from a
numeric variable generated separately?  
I am in the process of creating shipping tickets, and depending on how many
items are being shipped, I will need to break the shipment into a different

I need to calculate the difference between two fields in a query. The query
is called “qryRemote” and within the query are the fields “10-8Time” and “10-
97Time”. The data entered into these fields are in the format “0000” through
to “2400”. I need to subtract the “10-8Time from the ...

I have a query that has submit dates... 9/3/2007, 10/15/2007, etc.  I need a
way to group all dates together for one month and label it as September or
October, etc.
So, on my report, I have a field called month.  I'd like to group the dates

I have a crosstab query that is finally correct.  I have dates as the
parameter:  Start Date and End Date and they are my column headings.  The
problem I'm having:  I first sort by emp numbers and then by date, but my
dates are in the correct order across the columns, it may be ...

Well, actually, I'm the one who must be stupid, but anyway...  This query
gives me blank columns:
SELECT [Order Details].[Order Number], [Order Details].[Part Number], [Order
Details].Qty, tblPartNumbers.Alloy, tblPartNumbers.Thick FROM [Order Details]

Hi - I need an Excel formula to generate the number between a range of
numbers. For example:
30112500    30112590
30222500    30222590

I have a query that basically shows a few records with the recordID being
the first column, and then two prices (Buyer price second column and Seller
Price the third one).
It looks like this:

Hi Access MVPs,
I'm using Access 2003. I have a built a query that creates calculated
values.  For example:
Price: [MatShip]+([MatShip]*[Markup])+[MatCredit]+

I have a query that basically shows a few records with the recordID being
the first column, and then two prices (Buyer price second column and Seller
Price the third one).
It looks like this: