473,385 Members | 1,673 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Merging two time fields in a report and sorting by time

4
Hi all,
need help with pulling two fields together into one for a report.

Both fields are time fields and are on different tables.

I want to pull them both together into one field on a report so that they can be sorted by time in one list.

Any help,

Gracias.
Mar 17 '08 #1
2 1087
FishVal
2,653 Expert 2GB
Hi, there.

The tables should be joined in relevant way and the mentioned date fields may be concatenated. Thus obtained query could be used as report recordsource.

Expand|Select|Wrap|Line Numbers
  1. SELECT ...... , tbl1.dteField1 & ' ' & tbl2.dteField2 AS txtBothDatesTogether FROM tbl1 INNER JOIN tbl2 ON ...... ;
  2.  
Regards,
Fish.
Mar 17 '08 #2
NeoPa
32,556 Expert Mod 16PB
I think maybe you're talking about a UNION query.

You don't give any details however, so helping further would be difficult.
Expand|Select|Wrap|Line Numbers
  1. SELECT *
  2. FROM [Table1]
  3. UNION ALL SELECT *
  4. FROM [Table2]
Mar 18 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Ralph | last post by:
Hello I am using the report wizard in A2K to print 4 fields with my table as my data source. I would like the order of the fields to stay the same a; b; c; and d. When I make "print 1" and sort on...
1
by: Grim Reaper | last post by:
I asked this question, earlier, and received an answer that I am not sure about how to do. Basically, I am printing mailing labels with a "Sorting/Grouping" section that groups the label types...
3
by: Mat N | last post by:
Hi, I've been trying to work out how to create a report based on crosstab query for which the number of fields is variable. For example in a situation where you show customer billing by year in...
1
by: svdh | last post by:
I have posed a question last saturday and have advanced alot in the meantime. But I am still not there Problem is that I try to merging various fields from various tables in one document in Word...
3
by: Kirsty Ryder | last post by:
Hi I have two tables containing largely unrelated data. Eventually I want a report that lists the contents of each table simultaneously in date order as it were. I think this is better explained...
9
by: MLH | last post by:
Trouble is, it doesn't happen every time. Yesterday, for example, it happened only once and not again afterward. Some days ago, a similar situation. Today, well - I tried 7 times straight to open...
1
by: hylander | last post by:
My apologies for what to many of you will probably seem a simple problem. I have a number of queries which result in numerical answers. Is it possible to have access total these for a report. The...
8
by: babyangel43 | last post by:
Hello, I have a query set up in Access. I run it monthly, changing "date of test". I would like this query to be merged with a Word document so that the cover letter is created in Word, the fields...
8
by: sara | last post by:
Hi - I have looked at all posts and tried both Allen Browne's Report Sorting at run Time ( Select Case Forms!frmChooseSort!grpSort Case 1 'Name Me.GroupLevel(0).ControlSource = "LastName"...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.