access and excel functionality question

[Aaron]

I notice that access does a wonderful job in the pivot
table of allowing you to analyze data with along a wide
range of timeframes based on the date and time entered for
each record. In excel, I had to add columns in excel and
give them a respective format (i.e. year, month, week,
etc). Does excel have the same capability now as access
to look at a date and break it down in the pivot table
automatically?

Second question...the reason I think I need to export data
into excel is because I still have some v-lookups on excel
that I use to calculate repair costs (by looking at the
fabric type and amount used). I assume I don't have that
capability in access, do I?

Thank much,
Aaron

 

[John Vinson]

I notice that access does a wonderful job in the pivot
table of allowing you to analyze data with along a wide
range of timeframes based on the date and time entered for
each record. In excel, I had to add columns in excel and
give them a respective format (i.e. year, month, week,
etc). Does excel have the same capability now as access
to look at a date and break it down in the pivot table
automatically?

A Pivot table is actually an Excel spreadsheet constructed for you by
Access. I don't know enough Excel to answer the pivot table question
though.

Second question...the reason I think I need to export data
into excel is because I still have some v-lookups on excel
that I use to calculate repair costs (by looking at the
fabric type and amount used). I assume I don't have that
capability in access, do I?

Access is MUCH more adept at looking up data (it's a relational
database, that's what it's FOR) than Excel is. Rather than using
DLookUp (the Access analog of VLOOKUP) I would suggest using Access as
it was designed - a relational database! Create a Query joining your
table to the repair costs table by fabric type, and setting criteria
on the amount used. Without knowing the structure of the tables I
can't specifically design the query, but that's the technique!

 

[Naresh Nichani MVP]

Hi:

Try this (assume you wnat to try this in field NewID -- trap the KeyDown
event as follows) --

Private Sub NewID_KeyDown(KeyCode As Integer, Shift As Integer)
If Shift = 2 And KeyCode = 66 Then
MsgBox "Now"
End If
End Sub

Regards,

Naresh Nichani
Microsoft Access MVP