Search results

Hi this should be very simple, but it's not for me. I am creating a database logging machine error's. Each error has a recorded start and end time, which I enter. I want the database to enter the elapsed time into a third field, 'ElapsedTime'. I see how to do this in the builder, just...

Hi- I have created a pivotchart from the results of a query...When I open the chart under the form menu on my main DB screen, it opens straight to the chart. However, in my switchboard, which is opening the form in edit mode, it doesn't open to the chart, but to the form view. I have the default...

I have created a pivotchart which displays my information from my query perfectly. However, I want it to look like a report (date on bottom, nice title, etc...). The chart in design view won't let me add anything. (Adding things like =Now() in a text box in the footer won't show up). Any ideas?

Hi, I asked a question before concerning this same project and made some progress but have one more hangup. I am trying to just count the number of records that have a time field in one of four ranges: 6am-9am 9am-4pm 4pm-7pm 7pm-6am I have used the total feature in the query design window to...

I have 4 different queries which return incidents that happen in different time spans during the day. They work fine. However, I want a query which will count how many records each of the previously mentioned 4 queries returned, and puts it in a pie chart or something like that. What do I need...

Hi- I want to have a field that automatically prints the day of the week based off a date inputted in another field. This is my expression in the default value window. =WeekdayName(Weekday(#10/10/2004#),False) 1) Instead of the date that is in there, i want it to use the date from my other...

Hello- I have created a switchboard, which is linked to a form for a table i've created. Under the Database utilities, and switchboard manager, i have the option set to open the form in edit mode not add. However, the form, when opened only shows 1 entry, not all 30 some that are in the table...