I need to create a query that will be generated every Friday morning.
This query should look up all values for the period between last week's
Friday and the current week's Thursday.
Is this possible?

I want to export access report into excel without any changes in
formatting- what are my options. Infact there are some already
predefined fields in excel . i want the fields in access report to
directly fit in the excel pre defined columns. Is there a macro in

Is there a maximum number of records or sources to include in a query?  I'm a
beginner user and am trying to create a query to pull information from five
tables.  There are four tables with about 15 records and 7 records from the
fifth table.  I've gotten as far as the one table ...

How do I create a report (through a query) to only show fields that have
something in them?  I"ve got a table and through a form I enter chip
signatures into multiple fields There are at least 8 to 10 different chip
signature fields that could be entered and some of the records ...

I need this query to return an error if the second number typed in does not
exist in the table...
UPDATE [Table, main inventory part data] SET [Table, main inventory part
data].[# On Hand] = [# On Hand]+[Enter Number Parts Received]

Please answer this question for both using in query and using in VBA.
Is there a ceiling functio in Access?  e.g  Ceiling(5.23) would give a
result of 6
Thanks,

SQL:
SELECT Test.[ID], Test.[First Name], Test.[Last Name], Test.[Crane
Certification], Test.[Physical], Test.[Lincense], Test.[Safety Card]
FROM Test

Okay guys this is the last one.
My query will pull everything that has this months date in it.  When
the query finds a date that falls in this month it also prints the
dates by the person's name that does not fall in this month.  How can

Is there an easy way to get all the dates for all the Mondays, Tuesdays, etc.
for a given year? Thanks.

Please disregard the first post with the same subject(i hit enter to soon).
I have a database that has two columns
out rec#                   src file#
1                                A

I have a table keeping track of attendance for employees. We use a point
system, so that if an employee is absent or late, points are deducted. How
can i add the points field to each record?? There is a 15 minute grace period
in this as well, i would want it to look something ...

I have a Trips form and a Visit sub form, the Visit sub form has a sub form
called “Trips” in the trips form.
In the Sub Sub Form “Visits” I want to filter the pets to only show the pets
from the customer selected in the primary form.

I'm a complete novice so bear with me. I have been asked to set up an
enquiries database that includes an Enquiry field, Keyword1, Keyword2,
Keyword3 and Keyowrd4 fields (among others). I would have preferred one
keyword field with free text but the boss, you know ...

Year([SalesDate]) = Year(Now()) And Month([SalesDate]) = Month(Now()).
I have several dates in one query.  I would like to be able to make a
query the only showed the dates that expired in this month but when I
put the expression above in my query accross the board it requires

I am trying to sort out a form (linked to a query) for a database which will
allow the user to enter 3 criteria to filter records and view a report. The
criteria are;
1. Journal Name