Search results

Hi, I have a table with following data: Acct# Cash$ 1 $0.00 1 -$0.02 2 $0.00 2 0.02 I would like to get the following result: Acct# Cash$ 1 -$0.02 2 $0.02 how to just use query (not VBA code) to the result? Thank!

Thanks you so much for your help!

I have a field called Full Name and data looks like this: Mary Smith Mary S. Smith Mary S Smith I only need the last name. Please give me some hints. Thanks!

This is the question when I go for an job interview. So I don't know the meaning of the two fields. Since 1/a and 4/a have the same value "a", so these 2 rows are not unique; 2/b and 3/b are the same; 3/c and 3/b have the same value "3". So only 5/d is the unique row, because 5 and d are not...

I have a table with following data 1 a 2 b 3 c 4 a 5 d 3 b how to get the unique row which is 5/d Thanks!

Thank you for the hint!

I have a table called “Allocation” with following data: ClientID Amount 3 $50 2 $200 1 $100 I need to create a report sort by clientid Ascending, so I created a query called “q_sort_clientid”. The report’s record source=“q_sort_clientid” and the result...

I have a table with following data: 1 a 2 b 3 c 4 a 5 d 3 b how to use dynamic query to retrieve the unique row which is 5/d. Thanks!

It works. Thanks!

I have a report with 10 labels (lbl1, lbl2, lbl3…lbl10) in the page header. I want to set each label with different captions. The caption data is from another table called Bank (BankID, BankName), and I have 10 banks in the Bank table. My problem is that I don’t know how to create the label...

Thank you all! The code works fine.

Thanks! Bob I guess I did not explain my question clearly. My question is: I need to generate a report based on table1, but instead of the labels are B1, B2 and B3, I would like to use the BankName from table2. Thank you so much for the help! Table1 ClientID B1 B2 B3...

I need to set the label’s caption based on the data in a table. But I couldn’t find the label’s caption property in “Private Sub Report_Open(Cancel As Integer)” event or other events of the report. Any hint or suggestion? Thanks! Lucy

I tried to export the date/time field data to a text file. For example, the data is: 1/1/2008, but it turned out 1/1/2008 0:00:00 in the text file. I don't want the 0:00:00 appended. Which step I am missing? Thanks!