Transfer Text

J

jim

I have a macro that I want to transfer text from the query I posted below. I
need to create a specification for the transfer. When I open the query and
select Export/Text, a dialog box appers that states "Too few parameters.
Expected 1". The query is based on anotehr query that asks for a date, but I
do not know if this is the reason for the error. Any help will be appreciated.

SELECT Left([DATE],2) & "/" & Mid([DATE],3,2) & "/" & Right([DATE],2) AS
DATE1, Left([NAME],InStr(1,[NAME]," ")-1) AS L_Name,
Mid([NAME],InStr(1,[NAME]," ")+1) AS F_Name, Right([LOCATION],11) AS
LOCATION1, [DNP BY DATE COMPa].[ACCT#], [DNP BY DATE COMPa].[MTR#], 60 AS
Connect_Fee, 0 AS Disconnect_Fee, [DEPOSIT1]/100 AS ADD_DEPOSIT, [DELQ]/100
AS DELQUINT, [CURRENT CHGS]/100 AS [CURRENT AMT], 100 AS AFTER_HOURS,
IIf([Status]="ELECTPAY",[DELQUINT],[DELQUINT]+[ADD_DEPOSIT]+[CURRENT
AMT]+[AFTER_HOURS]) AS TOTAL, [DNP BY DATE COMPa].REMARKS
FROM [DNP BY DATE COMPa];
 
G

Gina Whipp

Jim,

That is exactly the reason for the error. You're going to have to use a
form to supply the parameter or the TransferText will not work. On that
same form you can place a button to run your macro.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have a macro that I want to transfer text from the query I posted below. I
need to create a specification for the transfer. When I open the query and
select Export/Text, a dialog box appers that states "Too few parameters.
Expected 1". The query is based on anotehr query that asks for a date, but I
do not know if this is the reason for the error. Any help will be
appreciated.

SELECT Left([DATE],2) & "/" & Mid([DATE],3,2) & "/" & Right([DATE],2) AS
DATE1, Left([NAME],InStr(1,[NAME]," ")-1) AS L_Name,
Mid([NAME],InStr(1,[NAME]," ")+1) AS F_Name, Right([LOCATION],11) AS
LOCATION1, [DNP BY DATE COMPa].[ACCT#], [DNP BY DATE COMPa].[MTR#], 60 AS
Connect_Fee, 0 AS Disconnect_Fee, [DEPOSIT1]/100 AS ADD_DEPOSIT, [DELQ]/100
AS DELQUINT, [CURRENT CHGS]/100 AS [CURRENT AMT], 100 AS AFTER_HOURS,
IIf([Status]="ELECTPAY",[DELQUINT],[DELQUINT]+[ADD_DEPOSIT]+[CURRENT
AMT]+[AFTER_HOURS]) AS TOTAL, [DNP BY DATE COMPa].REMARKS
FROM [DNP BY DATE COMPa];
 
J

jim

I created a form where one can input a date, and on this form, added a button
that executes the query. The query looks at the date inserted on the form. I
still receive the same error. "Too Few Parameters, expected 1". Any
suggestions?

Gina Whipp said:
Jim,

You're welcome!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Argh!! I was afraid of that. Thanks Gina.

Gina Whipp said:
Jim,

That is exactly the reason for the error. You're going to have to use a
form to supply the parameter or the TransferText will not work. On that
same form you can place a button to run your macro.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have a macro that I want to transfer text from the query I posted below.
I
need to create a specification for the transfer. When I open the query and
select Export/Text, a dialog box appers that states "Too few parameters.
Expected 1". The query is based on anotehr query that asks for a date, but
I
do not know if this is the reason for the error. Any help will be
appreciated.

SELECT Left([DATE],2) & "/" & Mid([DATE],3,2) & "/" & Right([DATE],2) AS
DATE1, Left([NAME],InStr(1,[NAME]," ")-1) AS L_Name,
Mid([NAME],InStr(1,[NAME]," ")+1) AS F_Name, Right([LOCATION],11) AS
LOCATION1, [DNP BY DATE COMPa].[ACCT#], [DNP BY DATE COMPa].[MTR#], 60 AS
Connect_Fee, 0 AS Disconnect_Fee, [DEPOSIT1]/100 AS ADD_DEPOSIT,
[DELQ]/100
AS DELQUINT, [CURRENT CHGS]/100 AS [CURRENT AMT], 100 AS AFTER_HOURS,
IIf([Status]="ELECTPAY",[DELQUINT],[DELQUINT]+[ADD_DEPOSIT]+[CURRENT
AMT]+[AFTER_HOURS]) AS TOTAL, [DNP BY DATE COMPa].REMARKS
FROM [DNP BY DATE COMPa];


.
Click to expand...


.
Click to expand...
 
G

Gina Whipp

Jim,

Please copy/paste the code for the button here... Also, what is the name of
the field on the form?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I created a form where one can input a date, and on this form, added a
button
that executes the query. The query looks at the date inserted on the form. I
still receive the same error. "Too Few Parameters, expected 1". Any
suggestions?

Gina Whipp said:
Jim,

You're welcome!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Argh!! I was afraid of that. Thanks Gina.

Gina Whipp said:
Jim,

That is exactly the reason for the error. You're going to have to use a
form to supply the parameter or the TransferText will not work. On that
same form you can place a button to run your macro.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have a macro that I want to transfer text from the query I posted
below.
I
need to create a specification for the transfer. When I open the query
and
select Export/Text, a dialog box appers that states "Too few parameters.
Expected 1". The query is based on anotehr query that asks for a date,
but
I
do not know if this is the reason for the error. Any help will be
appreciated.

SELECT Left([DATE],2) & "/" & Mid([DATE],3,2) & "/" & Right([DATE],2) AS
DATE1, Left([NAME],InStr(1,[NAME]," ")-1) AS L_Name,
Mid([NAME],InStr(1,[NAME]," ")+1) AS F_Name, Right([LOCATION],11) AS
LOCATION1, [DNP BY DATE COMPa].[ACCT#], [DNP BY DATE COMPa].[MTR#], 60
AS
Connect_Fee, 0 AS Disconnect_Fee, [DEPOSIT1]/100 AS ADD_DEPOSIT,
[DELQ]/100
AS DELQUINT, [CURRENT CHGS]/100 AS [CURRENT AMT], 100 AS AFTER_HOURS,
IIf([Status]="ELECTPAY",[DELQUINT],[DELQUINT]+[ADD_DEPOSIT]+[CURRENT
AMT]+[AFTER_HOURS]) AS TOTAL, [DNP BY DATE COMPa].REMARKS
FROM [DNP BY DATE COMPa];


.
Click to expand...


.
Click to expand...
 
J

jim

Gina,

Here you go:

SELECT Left([DATE],2) & "/" & Mid([DATE],3,2) & "/" & Right([DATE],2) AS
DATE1, Left([NAME],InStr(1,[NAME]," ")-1) AS L_Name,
Mid([NAME],InStr(1,[NAME]," ")+1) AS F_Name, Right([LOCATION],11) AS
LOCATION1, [DNP BY DATE COMPa].[ACCT#], [DNP BY DATE COMPa].[MTR#], 60 AS
Connect_Fee, 0 AS Disconnect_Fee, [DEPOSIT1]/100 AS ADD_DEPOSIT, [DELQ]/100
AS DELQUINT, [CURRENT CHGS]/100 AS [CURRENT AMT], 100 AS AFTER_HOURS,
IIf([Status]="ELECTPAY",[DELQUINT],[DELQUINT]+[ADD_DEPOSIT]+[CURRENT
AMT]+[AFTER_HOURS]) AS TOTAL, [DNP BY DATE COMPa].REMARKS
FROM [DNP BY DATE COMPa]
WHERE ((([DNP BY DATE COMPa].Date)=[Forms]![F_DNP Date for KAMO]![F_Date]));

The name of the field on teh form is F_Date. Thank you.

Gina Whipp said:
Jim,

Please copy/paste the code for the button here... Also, what is the name of
the field on the form?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I created a form where one can input a date, and on this form, added a
button
that executes the query. The query looks at the date inserted on the form. I
still receive the same error. "Too Few Parameters, expected 1". Any
suggestions?

Gina Whipp said:
Jim,

You're welcome!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Argh!! I was afraid of that. Thanks Gina.

Gina Whipp said:
Jim,

That is exactly the reason for the error. You're going to have to use a
form to supply the parameter or the TransferText will not work. On that
same form you can place a button to run your macro.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have a macro that I want to transfer text from the query I posted
below.
I
need to create a specification for the transfer. When I open the query
and
select Export/Text, a dialog box appers that states "Too few parameters.
Expected 1". The query is based on anotehr query that asks for a date,
but
I
do not know if this is the reason for the error. Any help will be
appreciated.

SELECT Left([DATE],2) & "/" & Mid([DATE],3,2) & "/" & Right([DATE],2) AS
DATE1, Left([NAME],InStr(1,[NAME]," ")-1) AS L_Name,
Mid([NAME],InStr(1,[NAME]," ")+1) AS F_Name, Right([LOCATION],11) AS
LOCATION1, [DNP BY DATE COMPa].[ACCT#], [DNP BY DATE COMPa].[MTR#], 60
AS
Connect_Fee, 0 AS Disconnect_Fee, [DEPOSIT1]/100 AS ADD_DEPOSIT,
[DELQ]/100
AS DELQUINT, [CURRENT CHGS]/100 AS [CURRENT AMT], 100 AS AFTER_HOURS,
IIf([Status]="ELECTPAY",[DELQUINT],[DELQUINT]+[ADD_DEPOSIT]+[CURRENT
AMT]+[AFTER_HOURS]) AS TOTAL, [DNP BY DATE COMPa].REMARKS
FROM [DNP BY DATE COMPa];


.
Click to expand...


.
Click to expand...


.
Click to expand...
 
G

Gina Whipp

Jim,

Where's the code behind the button because nothing wrong with what you have
below (except that you are using Reserved Words for field names which should
be avoided... http://allenbrowne.com/AppIssueBadWord.html).

Is *DNP BY DATE COMPa* a table or query?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,

Here you go:

SELECT Left([DATE],2) & "/" & Mid([DATE],3,2) & "/" & Right([DATE],2) AS
DATE1, Left([NAME],InStr(1,[NAME]," ")-1) AS L_Name,
Mid([NAME],InStr(1,[NAME]," ")+1) AS F_Name, Right([LOCATION],11) AS
LOCATION1, [DNP BY DATE COMPa].[ACCT#], [DNP BY DATE COMPa].[MTR#], 60 AS
Connect_Fee, 0 AS Disconnect_Fee, [DEPOSIT1]/100 AS ADD_DEPOSIT, [DELQ]/100
AS DELQUINT, [CURRENT CHGS]/100 AS [CURRENT AMT], 100 AS AFTER_HOURS,
IIf([Status]="ELECTPAY",[DELQUINT],[DELQUINT]+[ADD_DEPOSIT]+[CURRENT
AMT]+[AFTER_HOURS]) AS TOTAL, [DNP BY DATE COMPa].REMARKS
FROM [DNP BY DATE COMPa]
WHERE ((([DNP BY DATE COMPa].Date)=[Forms]![F_DNP Date for KAMO]![F_Date]));

The name of the field on teh form is F_Date. Thank you.

Gina Whipp said:
Jim,

Please copy/paste the code for the button here... Also, what is the name
of
the field on the form?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I created a form where one can input a date, and on this form, added a
button
that executes the query. The query looks at the date inserted on the form.
I
still receive the same error. "Too Few Parameters, expected 1". Any
suggestions?

Gina Whipp said:
Jim,

You're welcome!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Argh!! I was afraid of that. Thanks Gina.

Gina Whipp said:
Jim,

That is exactly the reason for the error. You're going to have to use
a
form to supply the parameter or the TransferText will not work. On
that
same form you can place a button to run your macro.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have a macro that I want to transfer text from the query I posted
below.
I
need to create a specification for the transfer. When I open the query
and
select Export/Text, a dialog box appers that states "Too few
parameters.
Expected 1". The query is based on anotehr query that asks for a date,
but
I
do not know if this is the reason for the error. Any help will be
appreciated.

SELECT Left([DATE],2) & "/" & Mid([DATE],3,2) & "/" & Right([DATE],2)
AS
DATE1, Left([NAME],InStr(1,[NAME]," ")-1) AS L_Name,
Mid([NAME],InStr(1,[NAME]," ")+1) AS F_Name, Right([LOCATION],11) AS
LOCATION1, [DNP BY DATE COMPa].[ACCT#], [DNP BY DATE COMPa].[MTR#], 60
AS
Connect_Fee, 0 AS Disconnect_Fee, [DEPOSIT1]/100 AS ADD_DEPOSIT,
[DELQ]/100
AS DELQUINT, [CURRENT CHGS]/100 AS [CURRENT AMT], 100 AS AFTER_HOURS,
IIf([Status]="ELECTPAY",[DELQUINT],[DELQUINT]+[ADD_DEPOSIT]+[CURRENT
AMT]+[AFTER_HOURS]) AS TOTAL, [DNP BY DATE COMPa].REMARKS
FROM [DNP BY DATE COMPa];


.
Click to expand...


.
Click to expand...


.
Click to expand...
 
J

jim

Gina,

On button click, the procedure is to run a Macro, so I'm unsure as to
retrieving the Code behind that.

*DNP BY DATE COMPa* is a query.

Thanks for helping.

Jim

Gina Whipp said:
Jim,

Where's the code behind the button because nothing wrong with what you have
below (except that you are using Reserved Words for field names which should
be avoided... http://allenbrowne.com/AppIssueBadWord.html).

Is *DNP BY DATE COMPa* a table or query?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,

Here you go:

SELECT Left([DATE],2) & "/" & Mid([DATE],3,2) & "/" & Right([DATE],2) AS
DATE1, Left([NAME],InStr(1,[NAME]," ")-1) AS L_Name,
Mid([NAME],InStr(1,[NAME]," ")+1) AS F_Name, Right([LOCATION],11) AS
LOCATION1, [DNP BY DATE COMPa].[ACCT#], [DNP BY DATE COMPa].[MTR#], 60 AS
Connect_Fee, 0 AS Disconnect_Fee, [DEPOSIT1]/100 AS ADD_DEPOSIT, [DELQ]/100
AS DELQUINT, [CURRENT CHGS]/100 AS [CURRENT AMT], 100 AS AFTER_HOURS,
IIf([Status]="ELECTPAY",[DELQUINT],[DELQUINT]+[ADD_DEPOSIT]+[CURRENT
AMT]+[AFTER_HOURS]) AS TOTAL, [DNP BY DATE COMPa].REMARKS
FROM [DNP BY DATE COMPa]
WHERE ((([DNP BY DATE COMPa].Date)=[Forms]![F_DNP Date for KAMO]![F_Date]));

The name of the field on teh form is F_Date. Thank you.

Gina Whipp said:
Jim,

Please copy/paste the code for the button here... Also, what is the name
of
the field on the form?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I created a form where one can input a date, and on this form, added a
button
that executes the query. The query looks at the date inserted on the form.
I
still receive the same error. "Too Few Parameters, expected 1". Any
suggestions?

Gina Whipp said:
Jim,

You're welcome!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Argh!! I was afraid of that. Thanks Gina.

:

Jim,

That is exactly the reason for the error. You're going to have to use
a
form to supply the parameter or the TransferText will not work. On
that
same form you can place a button to run your macro.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have a macro that I want to transfer text from the query I posted
below.
I
need to create a specification for the transfer. When I open the query
and
select Export/Text, a dialog box appers that states "Too few
parameters.
Expected 1". The query is based on anotehr query that asks for a date,
but
I
do not know if this is the reason for the error. Any help will be
appreciated.

SELECT Left([DATE],2) & "/" & Mid([DATE],3,2) & "/" & Right([DATE],2)
AS
DATE1, Left([NAME],InStr(1,[NAME]," ")-1) AS L_Name,
Mid([NAME],InStr(1,[NAME]," ")+1) AS F_Name, Right([LOCATION],11) AS
LOCATION1, [DNP BY DATE COMPa].[ACCT#], [DNP BY DATE COMPa].[MTR#], 60
AS
Connect_Fee, 0 AS Disconnect_Fee, [DEPOSIT1]/100 AS ADD_DEPOSIT,
[DELQ]/100
AS DELQUINT, [CURRENT CHGS]/100 AS [CURRENT AMT], 100 AS AFTER_HOURS,
IIf([Status]="ELECTPAY",[DELQUINT],[DELQUINT]+[ADD_DEPOSIT]+[CURRENT
AMT]+[AFTER_HOURS]) AS TOTAL, [DNP BY DATE COMPa].REMARKS
FROM [DNP BY DATE COMPa];


.



.
Click to expand...


.
Click to expand...


.
Click to expand...
 
G

Gina Whipp

Jim,

Then the first thing I'm going to suggest is... if that is where the date
originates from that is where the criteria for the form should go... (Since
the second query needs that date filled in from the first query... make
sense?)

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,

On button click, the procedure is to run a Macro, so I'm unsure as to
retrieving the Code behind that.

*DNP BY DATE COMPa* is a query.

Thanks for helping.

Jim

Gina Whipp said:
Jim,

Where's the code behind the button because nothing wrong with what you
have
below (except that you are using Reserved Words for field names which
should
be avoided... http://allenbrowne.com/AppIssueBadWord.html).

Is *DNP BY DATE COMPa* a table or query?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,

Here you go:

SELECT Left([DATE],2) & "/" & Mid([DATE],3,2) & "/" & Right([DATE],2) AS
DATE1, Left([NAME],InStr(1,[NAME]," ")-1) AS L_Name,
Mid([NAME],InStr(1,[NAME]," ")+1) AS F_Name, Right([LOCATION],11) AS
LOCATION1, [DNP BY DATE COMPa].[ACCT#], [DNP BY DATE COMPa].[MTR#], 60 AS
Connect_Fee, 0 AS Disconnect_Fee, [DEPOSIT1]/100 AS ADD_DEPOSIT,
[DELQ]/100
AS DELQUINT, [CURRENT CHGS]/100 AS [CURRENT AMT], 100 AS AFTER_HOURS,
IIf([Status]="ELECTPAY",[DELQUINT],[DELQUINT]+[ADD_DEPOSIT]+[CURRENT
AMT]+[AFTER_HOURS]) AS TOTAL, [DNP BY DATE COMPa].REMARKS
FROM [DNP BY DATE COMPa]
WHERE ((([DNP BY DATE COMPa].Date)=[Forms]![F_DNP Date for
KAMO]![F_Date]));

The name of the field on teh form is F_Date. Thank you.

Gina Whipp said:
Jim,

Please copy/paste the code for the button here... Also, what is the
name
of
the field on the form?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I created a form where one can input a date, and on this form, added a
button
that executes the query. The query looks at the date inserted on the
form.
I
still receive the same error. "Too Few Parameters, expected 1". Any
suggestions?

Gina Whipp said:
Jim,

You're welcome!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Argh!! I was afraid of that. Thanks Gina.

:

Jim,

That is exactly the reason for the error. You're going to have to
use
a
form to supply the parameter or the TransferText will not work. On
that
same form you can place a button to run your macro.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have a macro that I want to transfer text from the query I posted
below.
I
need to create a specification for the transfer. When I open the
query
and
select Export/Text, a dialog box appers that states "Too few
parameters.
Expected 1". The query is based on anotehr query that asks for a
date,
but
I
do not know if this is the reason for the error. Any help will be
appreciated.

SELECT Left([DATE],2) & "/" & Mid([DATE],3,2) & "/" &
Right([DATE],2)
AS
DATE1, Left([NAME],InStr(1,[NAME]," ")-1) AS L_Name,
Mid([NAME],InStr(1,[NAME]," ")+1) AS F_Name, Right([LOCATION],11) AS
LOCATION1, [DNP BY DATE COMPa].[ACCT#], [DNP BY DATE COMPa].[MTR#],
60
AS
Connect_Fee, 0 AS Disconnect_Fee, [DEPOSIT1]/100 AS ADD_DEPOSIT,
[DELQ]/100
AS DELQUINT, [CURRENT CHGS]/100 AS [CURRENT AMT], 100 AS
AFTER_HOURS,
IIf([Status]="ELECTPAY",[DELQUINT],[DELQUINT]+[ADD_DEPOSIT]+[CURRENT
AMT]+[AFTER_HOURS]) AS TOTAL, [DNP BY DATE COMPa].REMARKS
FROM [DNP BY DATE COMPa];


.



.
Click to expand...


.
Click to expand...


.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export text with current date 1
In a Join, 0 doesn't join -0; why not? how to workaround? 2
Find Max Value of Text Field 7
query construction 7
VBA coding question.... Need expert help 0
Transfer Text 3
SQL help - queries very slow 1
Simple VBA crashes Access 2007, why? 3

Top