Recent content by benlaird24

How though? What kind of query should I use, and where does the expression go?

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...

Why is that? What is wrong with basing your form off a table and having other fields referencing a query?

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?

I think that worked....thanks alot...never would have thought of that

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...

Thanks for the advice...One thing though. I was doing what you said, I had time1, time2, time3, and time4. They all look at my time field in my table. For each i have their specific criteria... time1- time>4:00:00 PM and time<7:00:00 PM time2- time>7:00:00 PM or time<6:00:00 AM (and doesnt seem...

I can incorporate all 4 queries into 1 if I need. Then in another query, I would need to make my criteria the time, but instead of printing the events that happen in a particular time frame, I want to be able to count the occurrences of each time frame. I know this is kind of vague, but any...

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...

To clarify: I have the one field date of event in my table, and I assume I need to keep it there. Based off of that date, which is entered by the user, I have the query I made convert the date to the day of the week. My day of week field is not in my table, which is what I think you suggested...

I understand now. I got this to work in a separate query. One more question. I have a form where all the info in my main table is entered. I want the user to be able to type a date in, and i have another field in the table where the appropriate day of the week automatically changes. Can i put...

Maybe I don't know enough about this, but can't I add the day of the week to my table without using any sort of query? I was trying to do it in the design view of my table, not with any type of query.

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...