Re: SQL Statement
On Feb 24, 3:10 pm, mrdjmag...@xxxxxxx wrote:
Hello,
Can you have a select statement that returns a literal AND normal
query results without a UNION?
Say I have a parameter, like and employee ID, passed to a procedure.
I want to run a query which returns the top 4 records in the result
set PLUS the values from the employee ID passed in.......So, 5 records
total.
The query is long, so I'm hoping to do it without a UNION.......
Much Thanks
Provide an example of the output you want to see, as well as the table
definition and some sample data.
David Fitzjarrell
.
Relevant Pages
- Re: merge two tables in one queie
... Sorry, my mistake, I was using Union All. ... employee number Data Data1 ... You can build a UNION query. ... with the date is MicroDate and the Employee number is EmployeeNumber ...
(microsoft.public.access.queries) - Re: merge two tables in one queie
... I was using UNION ALL. ... employee number Data Data1 ... You can build a UNION query. ... with the date is MicroDate and the Employee number is EmployeeNumber ...
(microsoft.public.access.queries) - RE: Sub report message
... performs the first join and then include that query in your SQL statement." ... Left join employee table to issue table. ... 1.I checked the main report query to see if there was a problem. ... All site staff are listed including all of the Food Service ...
(microsoft.public.access.reports) - RE: How to code/perform a search
... You really don't want to use a query for this. ... It will locate the employee id in the form's recrdsetclone and make the ... use a text box to capture search criteria from the user. ... The After Update event is to ...
(microsoft.public.access.formscoding) - RE: How to code/perform a search
... You really don't want to use a query for this. ... It will locate the employee id in the form's recrdsetclone and make the ... Dave Hargis, Microsoft Access MVP ... use a text box to capture search criteria from the user. ...
(microsoft.public.access.formscoding) |
|
