How do I manipulate a text field so it reads as a date field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a query that will give me different variables (summed
$$ amounts from different time frames) that comes from one column in a table.
I want it to pull this into different columns in my query. I would like to
assign different date parameters, Q-1, Q-2, Q-3, etc. so I am getting totals
of money made for each quarter. This seems to be too much for my query to
run, but I am certain there has to be an easier way. Can anybody help??
 
I am trying to create a query that will give me different variables (summed
$$ amounts from different time frames) that comes from one column in a table.
I want it to pull this into different columns in my query. I would like to
assign different date parameters, Q-1, Q-2, Q-3, etc. so I am getting totals
of money made for each quarter. This seems to be too much for my query to
run, but I am certain there has to be an easier way. Can anybody help??
Click to expand...

Not without a clearer undestanding of your table structure, no. The
subject line of your message doesn't appear to have anything
whatsoever to do with the question!

Note a couple of things: a Parameter cannot be used to choose which
fieldname to search; and if you have data (dates? quarters?) stored in
fieldnames, your table design probably needs to be reconsidered.

Please describe your table, your current query, and give us a bit of
help understanding what you want calculated.

John W. Vinson[MVP]
 
I have been trying to create a query in Access (I have '02) and I have hit so
many walls I can't see straight!

Here is the scoop:
My department conducts different seminars throughout the year for Financial
Services. Our agents whom work all over the United States are rated based on
their production. Here is how we break the production down:

Line of Business
Premium Credit Amount
NAFYC (Net Annual First Year Commissions)

There is a table in our main database (ODBC table) that lists production
daily. The Primary Keys are the Agent ID (how we identify them), the Source
Audit Date and the Line Of Business. The table could look something like
this:

AGT_ID SRC_AUDIT_DATE LINE_OF_BUSINESS PREM_CR_AMT NAFCY_CR_AMT
123456 1/1/2006 ONESCO $3.00 $1.25
123456 1/13/2006 Group Annuity $4.00 $2.50
789123 2/1/2006 ONESCO $2.00 $3.00
789123 2/15/2006 Group Annuity $1.00 $4.00

I also have a table (not an ODBC table) that I record attendance by Agent ID
and Seminar Code to show which Agents have attended what seminar.

What I am trying to do is create a report (obviously a query first - which I
can't seem to do) that will show:
Demographics about each agent that attended a specific seminar (which I have
set up to enter the Seminar Code)
Sum of PREM_CR_AMT from 3 months (by SRC_AUDIT_DATE) before the Seminar (to
show their production prior to attending the seminar)
Sum of PREM_CR_AMT from 3 months after the Seminar (to show that the seminar
was beneficial in their production in hopes that they are making more money)
Sum of PREM_CR_AMT from 6 months after the Seminar (for same reason).

I can't seem to figure a way to do this. I've exhausted every resource so
far. I've gotten closer and closer and end up hitting a wall. Any help you
can give me is greatly appreciated!! : )

If my description above is not helpful, please feel free to give me a call
directly. My numbers are listed below. If they were and you think you know
how to get different variables from different time frames pulling from the
same PREM_CR_AMT column but obviously different SRC_AUDIT_DATE rows in one
query? Or several queries?? Please let me know if you are able to help.
 
Back
Top