Re: Day number to day name
NomoreSpam4Me@xxxxxxxxxxx wrote:
HI, i have a query that gives me the number of the day, ei: sunday is
1, monday is 2 .....saturday is 7
What i wanna do is take that 2 and bring it back to Monday. How can i
do this? IS there a way to do this in a report?? I know its easy to do
in vba, but i ask criteria in my report and each time a run it it give
me a bug......
weekdayname(weekday(date()))
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
.
Relevant Pages
- Re: using a form with combo box to input criteria
... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
(microsoft.public.access.forms) - Re: using a form with combo box to input criteria
... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
(microsoft.public.access.forms) - Re: using a form with combo box to input criteria
... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
(microsoft.public.access.forms) - Re: Running 2 reports in a form together
... Form where the report is run from is called "clientanddate" ... Dim strReport As String 'Name of report to open. ... here is an example that tests criteria and builds a filter string to use as a parameter in OpenReport ...
(microsoft.public.access.forms) - RE: Trouble passing query criteria using VBA
... As I said try not refering to the form at all and use this criteria --- ... what the extra report is for. ... "KARL DEWEY" wrote: ... critera using VBA, then email the results in the report format using VBA ...
(microsoft.public.access.macros) |
|
