Search results for query: *

OEM USR 56k voice/PCI fax card is very slow sending & receiving. works fine with data. If I query the modem after after a data call (ati6)it indicates the last connection at something like 42000/28800 but after a fax call (send or receive) it indicates 300. Using Microsoft Fax Monitor under...

How do I setup a form to default to the most recently entered data? For example, in Field1 I enter "A", and in Field2 I enter "B". When I click the new entry button, I want "A" and "B" to appear as defaults for their respective fields. I would like to...

I'm trying to set a default in a form for the name of the previous month. For example, on June 10, 2003, the default would read "May". If its not possible to set an entire name as a default, I could also use numbers, ie. "5" for "May" Thanks, Matt

How do I set the default in a form to the previous month? This question probably has a very easy and obvious answer, but I'm new to access and couldnt find it in Microsoft's help files. Thanks, Matt

I have three tables: A, B, and C. Tables A and C are each outer linked to table B. I also have two queries. Query 1 is based on table A. Query 2 is based on table C. I now wish to make an additional query (query 3) that combines queries 1 and 2. However, when I attempt this, the number of...

I have a table called "Maintenance Summary" that contains 1468 rows of data. I also have a table called "Months", which has no relationship to any other table or query, and contains 12 rows of data (numbers for corresponding months). I query various fields in the...

In a query, I have entered "Month: Month([NameofDateField])". This works to group a count by month instead of individual days. However, the query does not list months that have no corresponding data. How do I make the query include every month of the year, even if some do not have...

In a query, I have entered "Month: Month([NameofDateField])". This works to group a count by month instead of individual days. However, the query does not list months that have no corresponding data. How do I make the query include every month of the year, even if some do not have...

I'm trying to use an Nz function within a count. I realize that this is probably a simple question, but where do I insert the Nz function? I think I understand how to use the function, just not where to use it. Thanks for the help, Matt

I have specific dates (including day, month, and year) in a table with corresponding data. In a query, I wish to count this data for each month. For example, I want to have an individual count for each month Jan. through Dec.. How do I tell a query to separate these months and count according...

I am using a query to look up the year of a date in the "date" field of a table. In a column of the query I enter: Year: datepart("y",[date]) The query then returns incorrect numbers. For example, if a date read "12/4/01", it may list "348" as the year...

I have a list of dates in a table. They are in the short date format (ie. 5/16/03). I would like to look these dates up by month and year, and return only the month and year to the query. I cannot use criteria in the "date" field of the query, as the entire date, including the day...

I am currently designing a fairly simple database. I wish to sum the quantity for a single item that contains multiple entries (each with a distinct date). For example: Date Item Quantity 4/7/03 Concrete 5 4/16/03 Concrete 2 2/3/03 Backhoe 1 2/5/03...