I am trying to create a report to print 3x5 index cards using a select query
filter, I can do this and all three cards are using to be using the paper
filter but this creates three duplicate cards. *I am using 8.5x11 card stock
for the index card creation(so I don't confuse you).* ...

Selecting an "Address" Field from a Table, I enter an Asterix, then Upper
Case letter - say an A - , and then another Asterix in the 'Criteria' area.  
The end result is   Like "*A*"
When the Query is RUN, it returns all 'Street Names' containing an A whether

I've been trying to wrap my head around this one and am stuck.
I have a table with WorkDate and ShiftNum fields. I have a form that prompts
for the criteria. Query AND works fine. Now the fun part. I want to enter
just a date get the results for all shifts (or the shift with no ...

Hi, the following query would select all rows where done=true and copy it to
the TaskDone table. But how do I also remove it from the Task table after
the copy procedure???? Give me REMOVE codes. Thanks
INSERT INTO TaskDone

I am used to use MS Access to view a SQL Server database table. One day
after I have modified the table structure and deleted a column XXXX outside
MS Access in a tailor-made program, when I tried to open the table in MS
Access, I got the following message.

I am trying to turn a list of transactions of several partIDs into a list of
current stock based on the principle of first-in-first-out. This means
outflows are served by first using the oldest quantities in the inventory.
Consider this example:

Is there a way to update my inventory quantity records in my inventory table?
To me, the formula would be: quantity on hand - quanity sold = quantity
remaining.  However, I did not sell every type of inventory.  Those that
weren't sold, access leaves that "quantity remaining" ...

how do I make a left((x),3) formula into a number format? When I run it as a
make table query it comes out as text.
I have changed the properties to general number.
Will

I’m not sure if this question belong in Query or Forms but here we go…
I have TableA, QueryA, and FormA
In TableA there are three checkbox  fields… Field1, Field2, and Field3.
QueryA is a Query of TableA.

What I have is a table called Leases it contains a start date and end date.
What I want to do is get the average length of the lease from the start date
to the end date and if the end date is null I want to use the current date.

i am trying to query a table in access from another program through SQL. My
source table has blank spaces, in the field description such as 'Equity  
Style Box'. My source table is a linked table of which i do not have primary
control over. When i attempt to put brackets around ...

I have a table with three columns; [BeginDate],[EndDate],[Number].
If a given date falls within the [BeginDate] and the [EndDate] I want to
return the value in [Number].
Sound simple enough, but I can not figure out how to do it in a query.

I am using access to link to tables within the database (SQL) of our company
software package, when writing a query I am unsuccessful when using a date
range as criteria. I am using "Between #14/11/2005# And #20/11/2005#"
-(Australian date standard) and receive data outside this ...

After creating a form, my screen flickers when I move the mouse across a few
labels. I can repeat the problem because the labels are all the same ones
that are causing the problem. Any ideas why? How do I fix this?
Dale

I am new to posting on forums though i have browsed them often.  
The question i have is to do with how to produce a Report using data that is
only remotely related to the Report's content.  Let me explain.
The Report that i have created has a simple layout and is called