Hello Ya'll
I am trying to put together a Inventory Database, But my one Big problems is
because there is multiply locaations in the warehouse the part number get
listed multipy time on my import Excel Spreed sheet.

I had 2 queries I need to combine.  One has information about services and
the other one has info about loans.  I had [Date], [ID] and several check
boxes on each query (check boxes are different on each query)
What I want to do is combine both in order to display the [date], [id] ...

Let's say, select MoveSign From Money,
when MoveSign=1 I want to join it with Client table
but when MoveSign=2 I want to alter the join to Supplier
and this be done when the query is on the loose

good Day,
I have a qryupdateinventory, that updates tblinventory from
tblinventorydetails. I would like to add a field  for "last update performed
on". I guess this I would use a last updat performed on would be a system

Good day,
I have a qryupdateinventory and I run it on close of my frminvoices. I
wanted to know if I could either eliminate the pop up box that comes up or
customize it?

I’m having an extremely large amount of trouble with a query.
My trouble begins when I try to do a query based on the ‘date of research’
field contained in the ‘cost’ table. The query will only return data when the
Junction table between ‘Industry classification’ and ‘Generic asset

I'm a beginner in Access.  I was adding the fields in "criteria" and received
an error message, "The string returned by the builder was too long".  How can
I increase the field in criteria?  Please help!

Im having a hard time making a query. Here is my problem.
A letter is sent to a company each year. Every 3rd year a visit is made to
the company. The year that a visit is made a letter does not need to be sent.
If a company request a visit then a letter does not need to be sent that ...

I am trying to set up a database to store my cd collection data and im a
little stuck trying to write a query parameter that when i enter my parameter
value it searches for anything with my value in.
E.g. i want to search for song names, i want it so if i put in "song" as my

I am redesigning my company's advertising database. I have a table
(tbl_Issue) containing 12 check boxes, 1 for each month. This is useful
in the form, as the salespeople want to see which months the ad is
running. Ads often run all 12 months.

I have a field in an access table which contains records of varying lengths
anywhere from 2 to 30 bytes.   I need a query to select records with, say 16
bytes only, or whatever length I need

I have an input variable that represents a StartDate.  When I try to look at
StartDate+1, the query gags.  I need to look at data for each of the 4 days
following the StartDate.  How do I represent this expression?

I am extracting data stored in a sequel table.  The field I am wanting to
group on the date is a date/time field.  How do I group on only the first 10
characters (the date) and ignore the time?

I created a simple select query for a single table only (as a checking
because I'm having a problem when I migle it with other tables).  I put a
parameter in the date field and it did not return all "equivalent date".  
When i checked my table (date format deleted), i noticed that ...

Does anyone know if it is possible to do a COUNT DISTINCT within a MS Query.
I can do this in a passthrough query but when I am in the MS Query design
interface I don't know if this can be done.
I have tried putting the following in the field section