#N/A errors
Thu, 14 Aug 2008 06:29:01 -0700
I am trying to sum a colume that has some cells with '#N/A'. The cell with
the total, displays a '#N/A' now. How can I have that cell display the total
of the numbers entered when there are the errors in the sumed cells. Thanks. ...
|
running serial number - different group of products
Thu, 14 Aug 2008 02:02:03 -0700
i am in the middle of developing a barcode recording db. User will input
product code, quantity and serial number (SN). There are 9 products, where
each product has its OWN SETof serial number.
snenario: FIRST INPUT
product A, 5 units, starting SN -> SN0001, ending SN0005
product B, 2 units, starting SN -> ...
|
Access Novice in the true sense of the word
Wed, 13 Aug 2008 21:52:00 -0700
Hi
I have this result from a query. If the sale date and the receipt date are
the same I don't want to bring them through in my query. Easy to do in excel
not so easy in access. So I want to see Cust 2 but not Cust 1. Any
suggestions?
Cust Invoice# Amount Emp Sale Date Rcpt Date
Cust 1 ...
|
Append query
Wed, 13 Aug 2008 20:01:19 -0700 (PDT)
I am using an append query (Query1)to add the name of the current
logged on user to a table using
Expr1: fGetFullNameOfLoggedUser()
I then have a text box on a form that displays the information
contained in the table.
All works fine if I run the query, whilst it is in design mode, and
adds the name as man ...
|
HELP! Changing a template- very lost
Wed, 13 Aug 2008 19:49:00 -0700
I have opened up a Customer Service Database and made my entries but I have
not been able to change the template, I would like to add 2 new fields but
when I look up help it tells me to do things that arn't on my screen. I am
guessing it's because it's a template not one Iv'e started from scratch. I am
getti ...
|
numbering rows in a table
Wed, 13 Aug 2008 16:35:01 -0700
i have a table with 100 odd names and the members id list is the primary key
with auto number
i then select names from this list and create a second table again it has
the members list primary key and auto number
what i want to do is to manually number the records in the second table,not
using the auto num ...
|
Datasheet tab
Wed, 13 Aug 2008 13:20:00 -0700
I'm studying for the Access 2007 exam.
In the book they keep refering to a tab on the ribbon named "Datasheet."
It is supposed to be to the right of the "Database Tools" tab.
Can anyone tell me why this tab isn't showing on my ribbon? ...
|
|
|
Query of Expired Docs
Wed, 13 Aug 2008 12:36:05 -0700
I have a query that runs expired certifications for me. I would like to drop
this information into a mail merge with "Your certification for ... (column
name)... has expired"
Is there a way to produce this information from my original query or by
querying off of my original?
I would also like it to NOT ...
|
Create a record on current mont
Wed, 13 Aug 2008 11:38:01 -0700
Hello, I have a query named qryYearlyReview and it gives me all the employees
whos Date Of Hire are in the current month. The fields are:
1) FirstName
2) LastName
3) DateOfHire
4) CurrentMonth: Month([DateOfHire]) Criteria: Month(Now())
I want to run something in my Main Form that would run this query an ...
|
linked table using multiple delimiters
Wed, 13 Aug 2008 10:52:34 -0700
N:\IMAGES\646_660\646\002637;290362142;\26\1\0001.tif
the above line is a sample of the text file that i need to be linked to. i
need to have my linked table to make delimters at "\" and at ";"
is there a way of doing this?
...
|
